Post by fabema » Mon Sep 30, 2013 2:29 am

Afrter I upgraded I got this error:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in /home/fabema/public_html/system/database/mysql.php on line 50

Please help
Thanks

Produse naturiste, produse bio si cosmetice naturale
la http://www.sanolife.ro


New member

Posts

Joined
Thu Oct 18, 2012 11:05 pm

Post by butte » Mon Sep 30, 2013 5:58 am

One thread offers a practical solution:
http://forum.opencart.com/viewtopic.php?f=19&t=106677
see also http://forum.opencart.com/viewtopic.php ... 44#p431649

to this problem:
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in

Plural threads and isolated posts accordingly bear cross-linkage, at least for the sake of noting its prevalence:
http://forum.opencart.com/viewtopic.php ... 21#p424887 (with a user's editorial comment below it)
http://forum.opencart.com/viewtopic.php?f=20&t=106706 (with perspectives)
http://forum.opencart.com/viewtopic.php?f=20&t=106973

Instances are beginning to proliferate a little bit, perhaps according to whether people search carefully first (or don't search). The snippet immediately above can be searched as-is; some do not try. The problem is known, it will undoubtedly be remedied in 1.5.6.1 in due course.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 13 guests