US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > BILLmanager > Troubleshooting


Reply
 
Thread Tools
Old 12-25-2016, 11:53 PM   #1
Junior Member
 
Join Date: May 2016
Posts: 26
Trax is on a distinguished road
Default Database query failed

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

"Database Query Failed"

http://prntscr.com/dntqtv
Trax is offline   Reply With Quote
Old 12-26-2016, 07:51 AM   #2
ISPsystem team
 
Join Date: Jun 2013
Posts: 233
fly is on a distinguished road
Default

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.
fly is offline   Reply With Quote
Old 12-26-2016, 12:26 PM   #3
Junior Member
 
Join Date: May 2016
Posts: 26
Trax is on a distinguished road
Default

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

Quote:
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&progres sid=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&progres sid=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=fa lse&sfrom=ajax&snext=ok&sok=ok&out=devel&step=pric elist.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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::s tring 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:lFormTune(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:lFormTune(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 is offline   Reply With Quote
Old 12-26-2016, 12:27 PM   #4
Junior Member
 
Join Date: May 2016
Posts: 26
Trax is on a distinguished road
Default

And the second half of it

Quote:
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&progres sid=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=fa lse&sfrom=ajax&snext=ok&out=devel&step=pricelist.a dd.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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&progres sid=false&sfrom=ajax&snext=ok&out=devel&step=price list.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_fie ld=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=de vel'
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_fie ld=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=de vel'
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
Trax is offline   Reply With Quote
Old 12-27-2016, 05:42 AM   #5
ISPsystem team
 
Join Date: Jun 2013
Posts: 233
fly is on a distinguished road
Default

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.
fly is offline   Reply With Quote
Old 12-28-2016, 07:42 PM   #6
Junior Member
 
Join Date: May 2016
Posts: 26
Trax is on a distinguished road
Default

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

Tags
database, error, mysql

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 05:33 AM.