4 replies [Last post]
JamesAmI@drupal.org's picture
Offline
Joined: 02/26/2008
Juice: 20
Was this information Helpful?

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.

gagarine@drupal.org's picture
Offline
Joined: 01/23/2008
Juice: 27
Re: beta 6, update database error

I have the same error...

spuky's picture
Offline
Joined: 01/31/2008
Juice: 80
Re: Re: beta 6, update database error

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

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: beta 6, update database error

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.

spuky's picture
Offline
Joined: 01/31/2008
Juice: 80
Re: Re: beta 6, update database error

you are forgiven Smiling