Hi,
I made my first installation of PT and managed to easily import a data feed with some thousand objects. However, when I try to search them or access a product page (browsing a merchants list works), I get a SQL syntax error:
Invalid query: 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 ')' at line 1
Any ideas?
Thx,
Simon
Hi David
Thank you for your quick reply and the help. Script works like a charm now. Also, the forum is really helpful as there seems to be a solution for almost every problem. Great work!
Simon
Hi Simon,
This sounds like you have enabled description search in config.advanced.php but have not yet re-run setup.php to create the new index. If this is the case, and line 10 of your config.advanced.php is
$config_searchDescription = TRUE;...browse again to http://www.yoursite.com/setup.php where you will see a new link to create the full text name+description index. The reason you see the error when searching and on the product page is because the same setting is used by the normal search as well as the selection of related products on the product page.
That should be all it is!
However, if that doesn't seem to be the problem, you can enable databaseDebugMode in config.php. That will show what actual database error is occurring. You can enable this on line 6 of config.advanced.php as follows:
$config_databaseDebugMode = TRUE;If you could enable that setting, and then email me a link to your installation i'll take a look for you; although apologies for any delay getting back to you at this time...
All the best,
Cheers,
David.