Non-functioning Backoffice

[Costantini]

Good evening everyone,
For the past few days, this website has stopped working. When I try to enter my login credentials, the page loads for a few minutes and then returns a 500 error. I have tried enabling various debug options, but nothing has changed. I also checked the log files inside the var folder, but it seems like they are no longer being generated.

I really don’t know what to do. Could someone help me?

The website has been attacked recently. While checking the hosting logs, I found a forensic log file that contained the following message:

Quote

 

*"Below, you will find the results of our analysis.
In order for your web space to function correctly after performing the necessary cleanup operations, you will need to reset the permissions of the replaced files to 604.

The following files were most likely uploaded by third parties.
Please analyze these files and delete them if necessary."*

 

Quote

 

~/clickandbuilds/PrestaShop/EnotecaGadi/suspicious_d57c4136b852-2025-02-05.zip

~/clickandbuilds/PrestaShop/EnotecaGadi/suspicious_d57c4136b852.zip

 

I deleted those two suspicious files, but it still doesn't work.

[Costantini]

edit. i founded this log now. thanks

dev.log prod.log 20250211_exception.log prestashop_custom_error.log

[musicmaster]

Your exception log has the error "Unknown column 'psi.id_country' in 'on clause'<br /><br /><pre>SELECT psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dpup_product p INNER JOIN dpup_layered_price_index psi"

This is interesting as the column id_country was originally not part of this table. It has been added later on. That is years ago but as far as I can see Prestashop has never included the addition of this column in its upgrade module.

For the rest most errors relate to the cache. So I suggest you try emptying the cache.

[musicmaster]

Correction: the ps_layered_price_index is part of the blocklayered module. Maybe something has gone wrong when you updated that module.

[Costantini]

2 hours ago, musicmaster said:

Your exception log has the error "Unknown column 'psi.id_country' in 'on clause'<br /><br /><pre>SELECT psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM dpup_product p INNER JOIN dpup_layered_price_index psi"

This is interesting as the column id_country was originally not part of this table. It has been added later on. That is years ago but as far as I can see Prestashop has never included the addition of this column in its upgrade module.

For the rest most errors relate to the cache. So I suggest you try emptying the cache.

Cache already overwritten. I renamed the var/cache folder and regenerated it, but nothing changed. Where can I find the blocklayered module? Thanks for the help.

[musicmaster]

57 minutes ago, Costantini said:

Cache already overwritten. I renamed the var/cache folder and regenerated it, but nothing changed. Where can I find the blocklayered module? Thanks for the help.

In the module page in the backoffice.

[Costantini]

1 minute ago, musicmaster said:

In the module page in the backoffice.

I cannot log in. The website functions normally, but when I try to log in with my credentials, clicking the login button shows a loading animation, and after one minute, it returns a 500 error.

I found this in the log:

 

Quote

*ERROR*     v1.7.5.1    2025/02/12 - 21:12:48: Fatal error at line 1109 in file classes/Tools.php
 

 

[musicmaster]

You can remove the blocklayered directory under the modules directory. After that cleanse the cache again.

(Keep it ready to move back later when have succeeded in logging in)