Skip to main content
This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.
[User Error] Couldn't run query: ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1) Duplicate column name '_obsolete_hasShippingCost'
I have given mysql database full permissions (including alter), but when i run /dev/build i get this error.
see full error attached.
Did you already have an "_obsolete_hasShippingCost" column in your database?
Yes, in the table "order". thanks
You seem to have upgraded at a previous moment. Simply remove the column by hand (or with your preferred SQL application). Columns named _obsolete can generally be removed without problems as they are remnants of old code.
(Not handling existing _obsolete columns could/should be considered a bug in /dev/build)
I deleted _obsolete_hasShippingCost but now i get another error (see attached)
I just deleted all records from Order (all the orders that people had made) and now i get a new error, see attached:
I have the same original problem and wouldn't have a clue on how to fix it.
The only issue this presents for me is that I get a non specific error while trying to access the reports tab in the backend cms.