2071 Posts in 814 Topics by 448 members
Page: 1 2
|Go to End||Next >|
25 March 2010 at 6:52pm Last edited: 25 March 2010 6:53pm
[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.
29 March 2010 at 2:04am
Did you already have an "_obsolete_hasShippingCost" column in your database?
29 March 2010 at 4:05pm
Yes, in the table "order". thanks
30 March 2010 at 12:50am Last edited: 30 March 2010 12:50am
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)
30 March 2010 at 4:13pm
I deleted _obsolete_hasShippingCost but now i get another error (see attached)
30 March 2010 at 4:58pm
I just deleted all records from Order (all the orders that people had made) and now i get a new error, see attached:
31 March 2010 at 4:21pm
13 April 2010 at 11:43am
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.
Page: 1 2
|Go to Top||Next >|