Store Upgrade Error 3.0 to 6.0.1
Expresso Store
3 months ago
I just updated EE from 3.5.12 to 7.5.14. When I try to update Store from 3.0 to 6.0.1, I get the following error:
```
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tax_override' in 'exp_store_orders':
ALTER TABLE exp_store_orders MODIFY COLUMN tax_override TEXT DEFAULT NULL
ee/legacy/database/drivers/mysqli/mysqli_connection.php:146
```
All of the other add-on's updated without issue.
```
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tax_override' in 'exp_store_orders':
ALTER TABLE exp_store_orders MODIFY COLUMN tax_override TEXT DEFAULT NULL
ee/legacy/database/drivers/mysqli/mysqli_connection.php:146
```
All of the other add-on's updated without issue.
3 months ago
I ended up running this in phpMyAdmin and I was able to upgrade to 6.0.0:
ALTER TABLE exp_store_orders ADD COLUMN tax_override TEXT DEFAULT NULL;
ALTER TABLE exp_store_orders ADD COLUMN tax_override TEXT DEFAULT NULL;
3 months ago
One other thing that I noticed, when I'm in the Store add-on and click on Dashboard on the left (see attachment), I get an error:
404: Item does not exist
Sorry, we could not find the item you are trying to access in the system.
URL: cp/addons/settings/store_
404: Item does not exist
Sorry, we could not find the item you are trying to access in the system.
URL: cp/addons/settings/store_
3 months ago
Solid...
I believe that 404 was fixed in the 6.0.1 release. Worth upgrading if you haven't yet 😊
Cheers,
-Tom Jaeger
I believe that 404 was fixed in the 6.0.1 release. Worth upgrading if you haven't yet 😊
Cheers,
-Tom Jaeger