CE Phoenix Upgrader Utility

Database error? - CE Phoenix Upgrader Utility

Database error?

by RAC » Tue Dec 21, 2021 7:18 am

Hello @zipurman

Thank you for this great updater utility.

Even I used it with ease, very comprehensive instructions and easy to follow. I would highly recommend other users to use this tool, I am now running 1.0.8.7.

Initially I did have a few errors which I have worked through, however I have a database error which I am really uncomfortable attempting.

Under includes/error.log

[19-Dec-2021 08:10:29 Europe/London] PHP Fatal error: DB: [1054] Unknown column 'base_price' in 'order clause' in public_html/includes/system/versioned/1.0.8.1/database_core.php on line 44

Line 44 is :

trigger_error($line, E_USER_ERROR);
User avatar
RAC
Posts: 35
Joined: Mon Apr 19, 2021 5:36 am
Contact:

Re: Database error?

by zipurman » Tue Dec 21, 2021 5:16 pm

;) That error is not generated by the upgrade utility.

If you sort the products by price in your store in certain areas, this error will show. I believe its fixed in more recent versions. If you want to stay on 1.0.8.7, you can patch doing the following: https://github.com/CE-PhoenixCart/Phoen ... 919ca2ef9c
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact: