2004 Posts in 533 Topics by 435 members
E-Commerce Modules
SilverStripe Forums » E-Commerce Modules » user error on /dev/build after installing ecommerce 0.6
Discuss about the various e-commerce modules available:
Ecommerce, SS Shop, SilverCart and SwipeStripe
Alternatively, have a look the shared mailinglist.
Moderators: martimiz, Nicolaas, Howard, Sean, Ryan M., biapar, Willr, Ingo, Jedateach, swaiba, simon_w
| Go to End | Next > | |
| Author | Topic: | 1272 Views |
-
user error on /dev/build after installing ecommerce 0.6

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.
Thanks.
-
Re: user error on /dev/build after installing ecommerce 0.6

29 March 2010 at 2:04am
Did you already have an "_obsolete_hasShippingCost" column in your database?
-
Re: user error on /dev/build after installing ecommerce 0.6

29 March 2010 at 4:05pm
Yes, in the table "order". thanks
-
Re: user error on /dev/build after installing ecommerce 0.6

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)
-
Re: user error on /dev/build after installing ecommerce 0.6

30 March 2010 at 4:13pm
I deleted _obsolete_hasShippingCost but now i get another error (see attached)
-
Re: user error on /dev/build after installing ecommerce 0.6

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:
-
Re: user error on /dev/build after installing ecommerce 0.6

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.
Please help!
| 1272 Views | ||
| Go to Top | Next > |


