Database query failed

[Trax]

When trying to create a "tariff plan" i go select the "Shared Hosting" option and get error

"Database Query Failed"

http://prntscr.com/dntqtv

[fly]

Hello

It means that some error concerning mysql occur. The exact error you will see in the billmgr.log.

Please show information from the log or write to our support team for fast help.

[Trax]

Here's everything logged from the moment i press to select the "Shared Hosting tariff"

Dec 26 10:22:11 [17132:2] libmgr EXTINFO Start thread 
Dec 26 10:22:11 [17132:2598] conn WARNING Ignore empty 'elid'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [][] 'func=authenticate.billmgr&username=1'
Dec 26 10:22:11 [17132:2598] db EXTINFO begin transaction
Dec 26 10:22:11 [17132:2598] core_module INFO Request [11.111.111.111][trax(1)] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&sok=ok'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name as name, orderimage, orderpriority, intname FROM itemtype WHERE parent IS NULL ORDER BY orderpriority'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&sok=ok&out=devel&step=pricelist.add.step1'
Dec 26 10:22:11 [17132:2598] wizard WARNING Wizard finished with bad last step
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1&checkonly=on&sok=ok'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1&checkonly=on'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name as name, orderimage, orderpriority, intname FROM itemtype WHERE parent IS NULL ORDER BY orderpriority'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step2&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1&checkonly=on'
Dec 26 10:22:11 [17132:2598] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step2&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT * FROM itemtype2project WHERE itemtype='21' AND project='1''
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT currency FROM project2currency WHERE project = 1'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT * FROM currency WHERE id='53''
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name FROM account WHERE level = 15'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name as name FROM pricelist WHERE isgroup='on' AND project=1 AND itemtype=21'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name FROM nameserver WHERE freedomain='on''
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT DISTINCT nt.id, nt.name FROM notifytemplate nt LEFT JOIN notifycontent nc ON nc.notifytemplate=nt.id WHERE nt.notice='vhostopen''
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT id, name as name FROM itemtype WHERE parent IS NULL'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT t.id, t.name FROM doctmpl t JOIN locale l on l.langcode=t.locale WHERE t.doctype = 'license' AND l.active='on''
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT c.id, c.iso FROM project2currency p2c JOIN currency c ON c.id=p2c.currency WHERE p2c.project=1'
Dec 26 10:22:11 [17132:2598] processing WARNING can not find module: pmipmgr
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO mgr_err::Missed::Missed(std::string const&, std::string const&) (lib/libmgr.so.5.83.1 + 0x4d) [*0x7efc8672a166]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO processing::InternalModule& GetBinaryModule<processing::InternalModule>(std::string const&) (lib/billmgr.so + 0x1b6) [*0x7efc8659c69c]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO Service::SupportedModules() (lib/billmgr.so + 0x9c) [*0x7efc8659c94a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO Service::SupportedModulesStr() (lib/billmgr.so + 0x4a) [*0x7efc861a6471]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceList::TuneProcessingModule(isp_api::Session&, Service&) (lib/billmgr.so + 0xe1) [*0x7efc861aaa41]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceList::plFormTune(isp_api::Session&, int, int) (lib/billmgr.so + 0x1e61) [*0x7efc861ac4ae]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceListAddStep2::WizGet(isp_api::Session&) const (lib/billmgr.so + 0x25e) [*0x7efc8364126b]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Wizard::Get(isp_api::Session&, std::string const&) const (lib/libispapi.so.5.83.1 + 0x14b) [*0x7efc83629980]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::FormAction::ModuleExecute(isp_api::Sessio n&) const (lib/libispapi.so.5.83.1 + 0x120) [*0x7efc83629c13]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::ModuleAction::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x43) [*0x7efc8362bdad]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::FormAction::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x1cd) [*0x7efc83643ee3]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Wizard::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x43) [*0x7efc8363376a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0xaa) [*0x7efc8363614a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.83.1 + 0x5fa) [*0x7efc83644d09]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libispapi.so.5.83.1 + 0x0) [*0x7efc8364974a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libispapi.so.5.83.1 + 0x0) [*0x7efc8363376a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0xaa) [*0x7efc8363614a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.83.1 + 0x5fa) [*0x7efc83643fc4]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Wizard::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x124) [*0x7efc8363376a]
Dec 26 10:22:11 [17132:2598] libmgr ERROR Error: Type: 'missed' Object: 'processingmodule' Value: 'pmipmgr'
Dec 26 10:22:11 [17132:2598] item WARNING can not get itemtypes Type: 'missed' Object: 'processingmodule' Value: 'pmipmgr'
Dec 26 10:22:11 [17132:2598] db EXTINFO Query: 'SELECT DISTINCT pm.module FROM processingmodule pm WHERE pm.module IN ()'
Dec 26 10:22:11 [17132:2598] db ERROR query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO mgr_db::Fail::Fail(std::string const&, std::string const&, std::string const&) (lib/libmgrdb.so.5.83.1 + 0x57) [*0x7efc7c1315c6]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libmysql.so.5.83.1 + 0x0) [*0x7efc7c13191e]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libmysql.so.5.83.1 + 0x0) [*0x7efc84e54306]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO mgr_db::Connection::Query(std::string const&) (lib/libmgrdb.so.5.83.1 + 0xb6) [*0x7efc84e592ac]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO mgr_db::Cache::Query(std::string const&) (lib/libmgrdb.so.5.83.1 + 0x2c) [*0x7efc861a70f7]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceList::TuneProcessingModule(isp_api::Session&, Service&) (lib/billmgr.so + 0xd67) [*0x7efc861aaa41]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceList::plFormTune(isp_api::Session&, int, int) (lib/billmgr.so + 0x1e61) [*0x7efc861ac4ae]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO aPriceListAddStep2::WizGet(isp_api::Session&) const (lib/billmgr.so + 0x25e) [*0x7efc8364126b]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Wizard::Get(isp_api::Session&, std::string const&) const (lib/libispapi.so.5.83.1 + 0x14b) [*0x7efc83629980]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::FormAction::ModuleExecute(isp_api::Sessio n&) const (lib/libispapi.so.5.83.1 + 0x120) [*0x7efc83629c13]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::ModuleAction::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x43) [*0x7efc8362bdad]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::FormAction::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x1cd) [*0x7efc83643ee3]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Wizard::Execute(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0x43) [*0x7efc8363376a]

[Trax]

And the second half of it

Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0xaa) [*0x7efc8363614a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.83.1 + 0x5fa) [*0x7efc83644d09]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libispapi.so.5.83.1 + 0x0) [*0x7efc8364974a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO ??? (lib/libispapi.so.5.83.1 + 0x0) [*0x7efc8363376a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::Action::Run(isp_api::Session&) const (lib/libispapi.so.5.83.1 + 0xaa) [*0x7efc8363614a]
Dec 26 10:22:11 [17132:2598] backtrace EXTINFO isp_api::InternalCall(isp_api::BaseConnection const&, isp_api::Authen const&, isp_api::Action const&) (lib/libispapi.so.5.83.1 + 0x5fa) [*0x7efc83643fc4]
Dec 26 10:22:11 [17132:2598] libmgr ERROR Error: Type: 'db' Object: 'query' Value: ''
Dec 26 10:22:11 [17132:2598] timer INFO TuneProcessingModule: 0.003312
Dec 26 10:22:11 [17132:2598] action EXTINFO Get message for error in action 'pricelist.add.step2' for level 29
Dec 26 10:22:11 [17132:2598] action EXTINFO Get message for error in action 'mgrerror_db' for level 29
Dec 26 10:22:11 [17132:2598] action EXTINFO Get message for error in action 'pricelist.add' for level 29
Dec 26 10:22:11 [17132:2598] action EXTINFO Get message for error in action 'pricelist.add.step1' for level 29
Dec 26 10:22:11 [17132:2598] db EXTINFO rollback transaction
Dec 26 10:22:11 [17132:2598] action EXTINFO Get message for error in action 'msgerror' for level 29
Dec 26 10:22:11 [17132:2598] core WARNING 0x7efc6c0187d0 Restart request
Dec 26 10:22:11 [17132:2598] libmgr EXTINFO Start thread 
Dec 26 10:22:11 [17132:2598] libmgr EXTINFO Thread 18f29c1c5f541f89 finished
Dec 26 10:22:11 [17132:2599] core_module EXTINFO Internal [][] 'func=authenticate.billmgr&username=1'
Dec 26 10:22:11 [17132:2599] db EXTINFO begin transaction
Dec 26 10:22:11 [17132:2599] core_module INFO Request [11.111.111.111][trax(1)] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok'
Dec 26 10:22:11 [17132:2599] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1'
Dec 26 10:22:11 [17132:2599] wizard WARNING Wizard finished with bad last step
Dec 26 10:22:11 [17132:2599] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1&checkonly=on'
Dec 26 10:22:11 [17132:2599] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step2&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1&checkonly=on'
Dec 26 10:22:11 [17132:2599] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&clicked_button=add&func=pricelist.add.step1&itemtype=21&operafake=1482747728927&progressid=false&sfrom=ajax&snext=ok&out=devel&step=pricelist.add.step1'
Dec 26 10:22:11 [17132:2599] db EXTINFO Query: 'SELECT id, name as name, orderimage, orderpriority, intname FROM itemtype WHERE parent IS NULL ORDER BY orderpriority'
Dec 26 10:22:11 [17132:2599] core_decoration EXTINFO Replace form value 'activate' with param value 'on'
Dec 26 10:22:11 [17132:2599] wizard EXTINFO Input name 'activate' found on form
Dec 26 10:22:11 [17132:2599] core_decoration EXTINFO Replace form value 'activate' with param value 'on'
Dec 26 10:22:11 [17132:2599] core_decoration EXTINFO Replace form value 'activate' with param value 'on'
Dec 26 10:22:11 [17132:2599] db EXTINFO commit transaction
Dec 26 10:22:11 [17132:2599] libmgr EXTINFO Thread 076923be885c84d6 finished
Dec 26 10:22:15 [17132:2] libmgr EXTINFO Start thread 
Dec 26 10:22:15 [17132:2600] conn WARNING Ignore empty 'elid'
Dec 26 10:22:15 [17132:2600] core_module EXTINFO Internal [][] 'func=authenticate.billmgr&username=1'
Dec 26 10:22:15 [17132:2600] db EXTINFO begin transaction
Dec 26 10:22:15 [17132:2600] core_module INFO Request [11.111.111.111][trax(1)] 'activate=on&func=pricelist.add.step1&itemtype=21&operafake=1482747733180&sfrom=ajax&snext=ok&sv_field=typelist'
Dec 26 10:22:15 [17132:2600] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&func=pricelist.add.step1&itemtype=21&operafake=1482747733180&sfrom=ajax&snext=ok&out=devel'
Dec 26 10:22:15 [17132:2600] db EXTINFO Query: 'SELECT id, name as name, orderimage, orderpriority, intname FROM itemtype WHERE parent IS NULL ORDER BY orderpriority'
Dec 26 10:22:15 [17132:2600] db EXTINFO commit transaction
Dec 26 10:22:15 [17132:2600] libmgr EXTINFO Thread 25ac2735f9632195 finished
Dec 26 10:22:19 [17132:2] libmgr EXTINFO Start thread 
Dec 26 10:22:19 [17132:2601] conn WARNING Ignore empty 'elid'
Dec 26 10:22:19 [17132:2601] core_module EXTINFO Internal [][] 'func=authenticate.billmgr&username=1'
Dec 26 10:22:19 [17132:2601] db EXTINFO begin transaction
Dec 26 10:22:19 [17132:2601] core_module INFO Request [11.111.111.111][trax(1)] 'activate=on&func=pricelist.add.step1&itemtype=21&operafake=1482747737179&sfrom=ajax&snext=ok&sv_field=typelist'
Dec 26 10:22:19 [17132:2601] core_module EXTINFO Internal [11.111.111.111][1] 'activate=on&func=pricelist.add.step1&itemtype=21&operafake=1482747737179&sfrom=ajax&snext=ok&out=devel'
Dec 26 10:22:19 [17132:2601] db EXTINFO Query: 'SELECT id, name as name, orderimage, orderpriority, intname FROM itemtype WHERE parent IS NULL ORDER BY orderpriority'
Dec 26 10:22:19 [17132:2601] db EXTINFO commit transaction
Dec 26 10:22:19 [17132:2601] libmgr EXTINFO Thread 7f0b3376c87852e0 finished

[fly]

Dec 26 10:22:11 [17132:2598] libmgr ERROR Error: Type: 'missed' Object: 'processingmodule' Value: 'pmipmgr'

It seems that IPmanager that require for hosting services is missing. Check if in IPmanager module added an integration with it.

[Trax]

This was fixed, it's a bug when adding hosting plans you have to make sure that a processing module was installed first.