Error to report to ubercart: Under Administer » Store administration » Products » Manage classes.
When adding attributes to the class I get following error:
user warning: 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 '.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid =' at line 1 query: SELECT a.aid, a.name, a.ordering AS default_ordering, ca.default_option, ca.required ca.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid = ca.aid AND ca.pcid = 'handbag' WHERE a.aid = 1 ORDER BY ca.ordering in D:\TWPD\Apache\htdocs\includes\database.mysql.inc on line 172.
user warning: 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 '.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid =' at line 1 query: SELECT a.aid, a.name, a.ordering AS default_ordering, ca.default_option, ca.required ca.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid = ca.aid AND ca.pcid = 'handbag' WHERE a.aid = 2 ORDER BY ca.ordering in D:\TWPD\Apache\htdocs\includes\database.mysql.inc on line 172.
user warning: 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 '.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid =' at line 1 query: SELECT a.aid, a.name, a.ordering AS default_ordering, ca.default_option, ca.required ca.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid = ca.aid AND ca.pcid = 'handbag' WHERE a.aid = 3 ORDER BY ca.ordering in D:\TWPD\Apache\htdocs\includes\database.mysql.inc on line 172.
user warning: 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 '.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid =' at line 1 query: SELECT a.aid, a.name, a.ordering AS default_ordering, ca.default_option, ca.required ca.ordering FROM uc_attributes AS a LEFT JOIN uc_class_attributes AS ca ON a.aid = ca.aid AND ca.pcid = 'handbag' WHERE a.aid = 4 ORDER BY ca.ordering in D:\TWPD\Apache\htdocs\includes\database.mysql.inc on line 172.

Comments

Island Usurper’s picture

Island Usurper commented
Assigned: Unassigned » Island Usurper
Status: Active » Fixed

I know I've seen this issue before, but I can't find it again. Maybe it was at ubercart.org. *shrug*

There's a comma missing in that query between ca.required and ca.ordering.

merseysoft’s picture

merseysoft commented

Any joy with this? I've seen the post in the ubercart forum here:
http://www.ubercart.org/forum/bug_reports/3310/beta_5_product_classes_sq...

However being a noobie, i have no idea how to correct this syntax error, ive searched eery file in my site for related text but no joy... what file do i need to edit?

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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