Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL syntax error problem


Recommended Posts



Can you help me get rid of this error message when i try to create my first product?







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 'MAX_ROW_LISTS_OPTIONS' at line 1


select * from products_options where language_id = '1' order by products_options_id LIMIT 0, MAX_ROW_LISTS_OPTIONS

Link to comment
Share on other sites

it seems like the parameter MAX_ROW_LISTS_OPTIONS was never defined. It it possible you added a contrib without adding its sql file?




addicted to writing code ... can't get enough of databases either, LOL!


my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum


Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...