Home » Forums » Ubercart » Support

beta 6, update database error

Submitted by JamesAmI@drupal.org on Tue, 02/26/2008 - 01:42
JamesAmI@drupal.org
Posts: 2
 Joined: 02/26/2008

Hi, when I ran update.php I got this:

Quote:
uc_order module
Update #6

* Failed: INSERT INTO {sequences} (name, id) VALUES ('{uc_order_products}_order_product_id', )


(everything else looked good to me.)
I tried running that sql command in phpmyadmin and got this:
Quote:
SQL query:

INSERT INTO {sequences}(
name,
id
)
VALUES (
'{uc_order_products}_order_product_id',
)

MySQL said: Documentation
#1064 - 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 '{sequences} (name, id) VALUES ('{uc_order_products}_order_product_id', )' at line 1


Should I be freaking out? Please forgive my noobness. Thanks.
permalink #1 Tue, 02/26/2008 - 06:41
gagarine@drupal.org

Posts: 13
 Joined: 01/23/2008

I have the same error...

permalink #2 Tue, 02/26/2008 - 07:58
spuky
Posts: 37
 Joined: 01/31/2008

dito is there some I don't quite get that sql statement...
so far I am happy with my testinstalation...

permalink #3 Tue, 02/26/2008 - 10:34
Lyle

Posts: 1605
 Joined: 08/07/2007
AdministratoreLiTe!

Forgive me, for I am a doofus. Fortunately, you don't have to do anything about it. The update function assumed you'd have orders already, and the lack of them broke the query. Since you don't have any ordered products, that query doesn't need to run anyway. Just pretend this never happened.

If you see anybody reporting this error, please point them to this post.

permalink #4 Tue, 02/26/2008 - 11:44
spuky
Posts: 37
 Joined: 01/31/2008

you are forgiven Smiling