QTpro

Fatal Error - QTpro

Fatal Error

by radhavallabh » Wed Jun 08, 2022 5:07 am

Hi dear;
I am on 1.0.8.15 using latest QTPro
I am getting below error on stats_low_stock_attrib.php
Fatal error: Uncaught Error: Call to undefined function qtpro_sick_product_count() in /xx/admin/stats_low_stock_attrib.php:55 Stack trace: #0 {main} thrown in /xx/admin/stats_low_stock_attrib.php on line 55

Also I already checked I have the admin/includes/functions/qtpro_functions.php uploaded yet I get this error.

Also on QTPro Doctor page I get below error
Fatal error: Uncaught Error: Call to undefined function qtpro_normal_product_count() in /xx/admin/qtprodoctor.php:74 Stack trace: #0 {main} thrown in /xx/admin/qtprodoctor.php on line 74


Please can you help fix this issue;
Thank you in advance;
Regds./
radhavallabh
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact:

Re: Fatal Error

by raiwa » Wed Jun 08, 2022 3:05 pm

O.K. sorry, I missed this.
The function file is included in the Admin siteWide hook you removed to avoid the additional queries.
Put the hook back in place and comment out or delete the entire "listen_injectSiteStart" function,

Or try to use it and apply the index modifications in the database like suggested by @ecartz
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: Fatal Error

by radhavallabh » Thu Jun 09, 2022 4:04 am

raiwa wrote:O.K. sorry, I missed this.
The function file is included in the Admin siteWide hook you removed to avoid the additional queries.
Put the hook back in place and comment out or delete the entire "listen_injectSiteStart" function,

Or try to use it and apply the index modifications in the database like suggested by @ecartz
Hi;
I tried making the index modifications dear but seems I am making some error in creating them due which they do not work..
Can you please help me with the correct sql to run for creating the indexes ;
It would be great if it were to work as is....

THank you in advance;
Very Warm Regds./
radhavallabh
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact:

Re: Fatal Error

by raiwa » Thu Jun 09, 2022 8:09 am

Code: Select all

ALTER TABLE `products_attributes` DROP INDEX `idx_products_attributes_products_id`, ADD INDEX `idx_products_attributes_products_id` (`products_id`, `options_id`, `options_values_id`) USING BTREE;
Please report back if this helps.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact:

Re: Fatal Error

by radhavallabh » Thu Jun 09, 2022 8:54 am

raiwa wrote:

Code: Select all

ALTER TABLE `products_attributes` DROP INDEX `idx_products_attributes_products_id`, ADD INDEX `idx_products_attributes_products_id` (`products_id`, `options_id`, `options_values_id`) USING BTREE;
Please report back if this helps.
Hi dear;
Thank you for the above detailed code;
I ran the same in database, but on the admin end again it giving the slag issue. , It is taking parsing time of 12.57 seconds.

Any other ideas dear of how we can still use the hook?

Very Warm Regds./
radhavallabh
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact:

Re: Fatal Error

by raiwa » Thu Jun 09, 2022 8:56 am

No. I'm sorry.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Contact: