QTpro

Fata Error - QTpro

Fata Error

by radhavallabh » Fri Apr 15, 2022 9:43 am

Hi Dear;
I installed the latest addon version on 1.0.8.13;
I am getting below error on catalog.php

Fatal error: DB: [1054] Unknown column 'products_options_track_stock' in 'where clause' from ..../xx/xx/includes/system/versioned/1.0.8.1/database_core.php on line 44

Please can you help me fix the issue;
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: Fata Error

by raiwa » Fri Apr 15, 2022 9:52 am

You need to install one of the options attributes qtpro modules (product info or pi module) to add the required database column.
See QtPro documentation:
Installation Point 2:
2a. [mandatory] In Admin =>Modules => Pi[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Pi[product_info] uninstall the core module
"Options and Attributes".
OR
2a. [mandatory] In Admin =>Modules => Content[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Content[product_info] uninstall the core module
"Options and Attributes".
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: Fata Error

by radhavallabh » Fri Apr 15, 2022 10:17 am

raiwa wrote:You need to install one of the options attributes qtpro modules (product info or pi module) to add the required database column.
See QtPro documentation:
Installation Point 2:
2a. [mandatory] In Admin =>Modules => Pi[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Pi[product_info] uninstall the core module
"Options and Attributes".
OR
2a. [mandatory] In Admin =>Modules => Content[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Content[product_info] uninstall the core module
"Options and Attributes".
Done Thank you dear;
But it does not sort the options with pa.sort_order like Ajax Attribute Manager, How to achieve that dear please can you guide?
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact:

Re: Fata Error

by radhavallabh » Fri Apr 15, 2022 10:42 am

radhavallabh wrote:
raiwa wrote:You need to install one of the options attributes qtpro modules (product info or pi module) to add the required database column.
See QtPro documentation:
Installation Point 2:
2a. [mandatory] In Admin =>Modules => Pi[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Pi[product_info] uninstall the core module
"Options and Attributes".
OR
2a. [mandatory] In Admin =>Modules => Content[product_info] install and configure the
module "QTPRO Options".
2b. [mandatory] In Admin =>Modules => Content[product_info] uninstall the core module
"Options and Attributes".
Done Thank you dear;
But it does not sort the options with pa.sort_order like Ajax Attribute Manager, How to achieve that dear please can you guide?
For the Ajax Attribute Sort Order to work in QTpro

I changed line 44 on product_loader.php to

ORDER BY pa.sort_order

Will that be Ok dear?
Please confirm if it will not cause any issues with the addon working?
Regds./
radhavallabh
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact:

Re: Fata Error

by raiwa » Fri Apr 15, 2022 10:52 am

should be O.K.
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: Fata Error

by radhavallabh » Fri Apr 15, 2022 10:57 am

raiwa wrote:should be O.K.
Thank you dear...
Regds./
radhavallabh
radhavallabh
VIP Member
VIP Member
Posts: 364
Joined: Tue Oct 27, 2020 4:09 am
Contact: