[email protected] Posted July 31, 2009 Share Posted July 31, 2009 Dear All,Just upgraded my prestashop to v1.2.0.8 (final) and i was very exited and happy to this final version.But unfortunately,in the back office after i click reindex my databases, error occurs as below :Array( [0] => 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 [1] => Array ( ))END Please kindly share if somebody also got the samething, and how to resolve it? thks Link to comment Share on other sites More sharing options...
Damien Metzger Posted July 31, 2009 Share Posted July 31, 2009 I can't reproduce it, but I think I know what it is.You can try again after replacing the file "/classes/Search.php" of your shop by the one on the SVN. Link to comment Share on other sites More sharing options...
[email protected] Posted July 31, 2009 Author Share Posted July 31, 2009 I finally found the solution.. i reduce the minimum word length to 3, that solved my problem..I know what the problem caused.. In my product name, there are several items consist less than 5 character..Mostly only 4 character.This is caused the problem..Thks to Mr.Antony helping me to solve this problem..Bravo Prestashop.. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts