1054 Error

[Jan]

Hi,

the 4.0.0.sql and 4.0.2.sql files are a specific files, because it depends on different upgarde methods if such file will be taken to the effect or not. So this is why all the commands are commented.

Just run them step by step to be 100% all the changes are made in your database. In worst case, the database will say you, such changes were made.

4.0.2.sql - even these queries can be run.

Jan

[jagg1010]

same here... those update sql files still have that commented out ALTER lines so I ended up also in those errors at checkout page

Manually changed all the db tables and it's working now.

[Jan]

Hi, which error do you exactly get? Which version of Phoca Cart do you use? This topic is two years old.

Jan

[jagg1010]

I think those two update sql files have only totally commented out lines. And without executing those commands everyone upgrading from an older phocacart installation runs into the mentioned problem from this thread.

[Jan]

Hi, no, this only happens for users who used development versions. Between development versions there is no update of SQL possible, so this commented code is here to inform users who tested development version that if they updated from Beta to RC, they should run these SQL queries. User who installed the stable, they have such changes included in standard installation process.

This is why it is recommended to use upgrade process between large version (3 - 4):
https://www.phoca.cz/documentation/86-j ... o-joomla-4

because when users follow this guide, they will have always up-to-date database structure.

Jan