Jump to content

PHP Fatal error: Uncaught You have an error in your SQL syntax


Recommended Posts


log file from our server is full with this error. 
We couldn't find the solution related to this problem. 

We are using prestashop


[19-Apr-2017 13:03:22 Europe/Bucharest] PHP Fatal error:  Uncaught 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 'LIMIT 1' at line 4<br /><br /><pre>
            SELECT m.*
            FROM `ps_module` m
            JOIN `ps_module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1)
            WHERE m.`id_module` = LIMIT 1</pre>
  thrown in /****/classes/db/Db.php on line 791



The 791 line in Db.php is this: 
If someone have some information to fix this would be awesome.
Thank you  
Link to comment
Share on other sites

Thank you for your advice. 

I don't find any related module in our prestashop BUT I saw our logs on prestashop backoffice and when this error start to record on server logs we have this :


Message: Add RequestSql

Object type: RequestSql  

Object id: 1 


From what I remember, but I am not sure, on that date and hour I tried to put a new cron job in module "cronjob". 
That job is already removed from cron job. Was "active" for few days. 

Could be this related with cron job ? 

Thank you 

Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...