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

[Rachit Agarwal]

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?

[Guest]

WHERE m.`id_module` = ????

Where do you delete categories?
In administration?

Edited October 13, 2020 by Guest (see edit history)

[Rachit Agarwal]

 

1 minute ago, Guest said:

WHERE m.`id_module` = ????

This is for what I need help to find this query while deleting category.

I'm not getting the file in which it is called.

[Guest]

./classes/Category.php

function delete

[Guest]

Is there any overwriting of Category.php in the ./override folder?

[Rachit Agarwal]

Just now, Guest said:

Is there any overwriting of Category.php in the ./override folder?

Yes but delete function in the base class file only ./classes/Category.php

I don't see anything written for module query in this function as per attachment.

[Guest]

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

[Rachit Agarwal]

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:

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.

 

[Guest]

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/...

[Rachit Agarwal]

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.

[Guest]

So I upload the error log from the ./log folder to FTP.