Jump to content

Category is not deleting but when enabled the debug mode then got MySQL query issue


Rachit Agarwal
 Share

Recommended Posts

Hi,

I want to delete some categories from my Prestashop 1.6 backoffice. Nothing is happening on deletion. When I enable the debug mode from defines.inc.php, then I got below error:

PHP Fatal error:  Uncaught You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 C:\xampp\htdocs\abcxyz\classes\db\Db.php on line 791

Can someone help me to resolve this?

Share this post


Link to post
Share on other sites

Just now, Guest said:

You must write a procedure that you do when you get this error.

I'm just going to delete a category from backoffice using delete option for each category. After selecting "Delete" option from dropdown (on the right side of each category), there will be 3 option in front of me:

image.thumb.png.45e74563beed398f0f95e6db6051da0b.png

And after clicking on Delete button, nothing happens. I've tried with all 3 options but nothing happend.

When I've enabled the debug mode and try to delete it and I got above error in the PHP error log file.

 

Share this post


Link to post
Share on other sites

This is a sql query to any third party module.
This is not a standard Prestashop sql query.

Check the folders on FTP.

./override/controllers/....

./override/classes/...

Share this post


Link to post
Share on other sites

18 minutes ago, Guest said:

This is a sql query to any third party module.
This is not a standard Prestashop sql query.

Check the folders on FTP.

./override/controllers/....

./override/classes/...

This didn't help.... :(

I just want to know from which file this query is executing, I'm not able to find this query in any file.

Share this post


Link to post
Share on other sites

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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More