PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 '/ AUTO_INCREMENT = 1' at line 1: ALTER TABLE {commerce_product_revision}/ AUTO_INCREMENT = 1; Array ( ) in function commerce_reset_delete_products() (line 209 in file /sites/all/modules/contrib/commerce_reset/commerce_reset.module).

Comments

VVS’s picture

VVS CreditAttribution: VVS commented
Status: Active » Reviewed & tested by the community

I see line 209 have error code:
http://cgit.drupalcode.org/commerce_reset/tree/commerce_reset.module?h=7...

db_query('ALTER TABLE {commerce_product_revision}/ AUTO_INCREMENT = 1');

instead of:

db_query('ALTER TABLE {commerce_product_revision} AUTO_INCREMENT = 1');

I fix it, and the error was gone.

garethhallnz’s picture

garethhallnz CreditAttribution: garethhallnz commented
Status: Reviewed & tested by the community » Fixed

Thanks Dude

  • VVS authored e7213ba on 7.x-1.x 
    Issue #2521888 by VVS: Error on "Delete all products variations"...
VVS’s picture

VVS CreditAttribution: VVS commented
Status: Fixed » Reviewed & tested by the community
garethhallnz’s picture

garethhallnz CreditAttribution: garethhallnz commented

As you can see on #3 your fix has been committed and thus is fixed.

Why did you change the status back to Reviewed & tested by the community from Fixed?

garethhallnz’s picture

garethhallnz CreditAttribution: garethhallnz commented
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.