Problem with error 500 on stores PS 1.7.8

[Andrejkov]

Hi,

I have a strange problem on all my all Prestashop 1.7.8 stores, the problem appeared today.

Error 500 appears on the front and back office from time to time, just refresh the page and everything will be back to normal. Unfortunately I don't have any logs. What is the problem if the same error appeared on all stores at the same time?

Regards

 

[TiaNex Shopping]

hello,turn on debug,there is more detailed error information

[Obsidrian Drama]

My educated guess is that your PS stores were automatically upgraded to v8.1.1 at least... and that is causing havoc.
I posted this some days ago: 

 
Still unsolved though.

Why is it working for you sometimes when you refresh the page and some others it doesn't? I'd say: browser local cache.

Please, let us all know if you find a solution.

TIA!

 

Edited October 24, 2023 by Obsidrian Drama (see edit history)

[Zohaib-fk]

Hi,

You can check your website link in below online testing tools to see how it looks and works for visitors or not.

[1]. https://gtmetrix.com/

[2]. https://tools.pingdom.com/

 

[Andrejkov]

Hi,

@TiaNex Shopping, Unfortunately, turning on debug mode will not help me because the error does not appear every time, only from time to time.

@Obsidrian Drama, no shop are still 1.7.8. 

@Zohaib-fk, already tested and shop work good for visitors

This error appears from time to time and is not dependent on a specific activity in the store. I tried deleting the cache manually but it didn't help

 

Edited October 25, 2023 by Andrejkov (see edit history)

[musicmaster]

Did you look in the /var/logs directory?

[Obsidrian Drama]

2 hours ago, musicmaster said:

Did you look in the /var/logs directory?

This line repeats itself all the time in prod-2023-10-25.log:
 

Quote

[2023-10-25 16:18:40] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT t0.id_feature_flag AS id_feature_flag_1, t0.name AS name_2, t0.state AS state_3, t0.label_wording AS label_wording_4, t0.label_domain AS label_domain_5, t0.description_wording AS description_wording_6, t0.description_domain AS description_domain_7, t0.stability AS stability_8 FROM luol_feature_flag t0 WHERE t0.name = ? LIMIT 1' with params ["catalog_price_rule"]:  SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.stability' in 'field list'" at /home/foobaruser/domains/foobardomain.tld/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t0.id_feature_flag AS id_feature_flag_1, t0.name AS name_2, t0.state AS state_3, t0.label_wording AS label_wording_4, t0.label_domain AS label_domain_5, t0.description_wording AS description_wording_6, t0.description_domain AS description_domain_7, t0.stability AS stability_8 FROM luol_feature_flag t0 WHERE t0.name = ? LIMIT 1' with params [\"catalog_price
_rule\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.stability' in 'field list' at /home/foobaruser/domains/foobardomain.tld/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.stability' in 'field list' at /home/foobaruser/domains/foobardomain.tld/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.stability' in 'field list' at  /home/foobaruser/domains/foobardomain.tld/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []

And this is in 20231021_exception.log:

Quote

*ERROR*         v8.1.1  2023/10/21 - 10:21:51: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cl.additional_description' in 'field list' at line 151 in file classes/db/DbPDO.php
*ERROR*         v8.1.1  2023/10/21 - 10:22:02: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cl.additional_description' in 'field list' at line 151 in file classes/db/DbPDO.php
*ERROR*         v8.1.1  2023/10/21 - 10:23:26: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cl.additional_description' in 'field list' at line 151 in file classes/db/DbPDO.php

Thanks! 

 

[QuickUpdate.net]

If you have multiple stores on different servers and a load balancer might explain your issue as the error might appear only when a specific server is hit.

[JBW]

You are missing column 'stability' in table luol_feature_flag. Might be caused by an incomplete upgrade. It should look as follows:

[musicmaster]

12 minutes ago, JBW said:

You are missing column 'stability' in table luol_feature_flag. Might be caused by an incomplete upgrade. It should look as follows:

Stability is a new field in PS 8.0. Andrejkov is still running 1.7.8. But there must be some explanation how it comes that he has code that asks for a PS 8.0 field.

Either he has made some failed upgrade attempt or Prestashop has pushed some module upgrade that assumes PS 8.0. In the latter case he should enable profiling to see the source of this query. The error message tells us only where it is processed in the Doctrine swamp.

[Obsidrian Drama]

1 hour ago, JBW said:

You are missing column 'stability' in table luol_feature_flag. Might be caused by an incomplete upgrade. It should look as follows:

Is there any way to relaunch the upgrade to v8.1.1 from the command line?

Danke! / Thanks! 

 

[musicmaster]

10 hours ago, Obsidrian Drama said:

Is there any way to relaunch the upgrade to v8.1.1 from the command line?

Danke! / Thanks! 

 

8.1.2 is now the latest version.

See here for a description of the manual upgrade: https://devdocs.prestashop-project.org/8/basics/keeping-up-to-date/upgrade/