500 error after updating to 1.7.8.8, backup site + DB did not help

[AquaPlanning]

Dear all,

I updated my 1.7.8.7 site to 1.7.8.8. Got a 500 error. 
Reinstalled website from backup + reinstalled backup DB.
Still 500 error.
Deleted cache
Still 500 error
Am now at limit of my limited kowledge...

Site URL: www.aquaplanning.org/boekingssysteem/

Switched on error reporting:
Warning: Use of undefined constant _PS_ALLOW_MULTI_STATEMENTS_QUERIES_ - assumed '_PS_ALLOW_MULTI_STATEMENTS_QUERIES_' (this will throw an Error in a future version of PHP) in /mnt/web217/a0/39/511333139/htdocs/boekingssysteem/classes/db/DbPDO.php on line 92 Warning: session_set_cookie_params(): Cannot change session cookie parameters when headers already sent in /mnt/web217/a0/39/511333139/htdocs/boekingssysteem/src/Core/Session/SessionHandler.php on line 116

 

(1/1) EnvNotFoundException

Environment variable not found: "runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_".

in RuntimeConstEnvVarProcessor.php line 39

at RuntimeConstEnvVarProcessor->getEnv()in Container.php line 491

at Container->getEnv()in FrontContainer.php line 1267

at FrontContainer->getDoctrine_Dbal_DefaultConnectionService()in FrontContainer.php line 1641

at FrontContainer->getProductCommentRepositoryService()in Container.php line 306

at Container->get()in productcomments.php line 937

at ProductComments->hookFilterProductContent()in Hook.php line 1007

at HookCore::coreCallHook()in Hook.php line 431

at HookCore::callHookOn()in Hook.php line 944

at HookCore::exec()in ProductController.php line 384

at ProductControllerCore->initContent()in Controller.php line 306

at ControllerCore->run()in Dispatcher.php line 525

at DispatcherCore->dispatch()in index.php line 28

[AquaPlanning]

- files saved as UTF8
- could this be a query limit from my provider STRATO? Not the best provider for Prestashop, I know, but I finally had everything working well...
If it is a query limit, would I see the errors above?

[AquaPlanning]

"solved" by installing Prestashop 1.8 

[Willy15]

Hi @AquaPlanning,

I had exactly the same problem.

Fixed it adding this into /classes/db/DbPDO.php, in the getPDO function.

define ('_PS_ALLOW_MULTI_STATEMENTS_QUERIES_', null);

Don't forget to backup your file!

Not sure what might have caused it, the backoffice was working fine after updating to 1.7.8.8.

Hope it helps!

On 12/24/2022 at 7:01 PM, AquaPlanning said:

"solved" by installing Prestashop 1.8 

????

[AquaPlanning]

Hi @Willy15, thanks! Will try that tomorrow.

About the 1.8: the busy season for my company is coming, and I had to find a solution immediately. So I installed 1.8 but unfortunately lost all my orders. So I will try your solution.

 

[Yulia Vitun]

On 12/27/2022 at 12:33 AM, Willy15 said:

Hi @AquaPlanning,

I had exactly the same problem.

Fixed it adding this into /classes/db/DbPDO.php, in the getPDO function.

define ('_PS_ALLOW_MULTI_STATEMENTS_QUERIES_', null);

 

in which line exactly of /classes/db/DbPDO.php to add this code?

[Basix101]

On 3/23/2023 at 2:54 PM, Yulia Vitun said:

in which line exactly of /classes/db/DbPDO.php to add this code?

I had same problem. I had replaced src and vendor folders from the wrong PS source version for my installation. Downloaded the correct PS source version of (1.7.8.8 for me) then replaced the src and vendor folders and it worked.