No access after uptade

[BullyBlue]

Sadly my customer decided to update the version without any assistance - and here we are having fatal errors. 😞

With PHP on 7.4 i get 4 errors when trying to log in :

(4/4) DBALException

An exception occured while establishing a connection to figure out your platform version.
You can circumvent this by setting a 'server_version' configuration value

For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673

(3/4) DriverException

An exception occurred in driver: SQLSTATE[HY000] [2026] SSL connection error: SSL_CTX_set_default_verify_paths failed

(2/4) PDOException

SQLSTATE[HY000] [2026] SSL connection error: SSL_CTX_set_default_verify_paths failed

(1/4) PDOException

SQLSTATE[HY000] [2026] SSL connection error: SSL_CTX_set_default_verify_paths failed

 

Funny thing - when i update the PHP to 8.0 I do just get one error:

(1/1) FatalErrorException

Compile Error: Declaration of Doctrine\DBAL\Driver\PDOConnection::query() must be compatible with PDO::query(string $query, ?int $fetchMode = null, mixed ...$fetchModeArgs)

 

Can anyone help me out on this one?
I am really not sure what to do... but it seems like 1 error would be easier to solve than 4?

 

Thanks in advance!

[ps8modules]

 

[musicmaster]

This is a rather common one. 

See here: https://github.com/PrestaShop/PrestaShop/issues/33524

Change app/config/doctrine.yml:

The line
1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

should be changed into
1016: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

Edited July 15 by musicmaster (see edit history)

[BullyBlue]

On 9/29/2023 at 5:05 AM, ps8moduly.cz said:

 

As i said - i do understand that error.
But switching to a lower version does produce even more errors - see initial post.

 

On 9/29/2023 at 11:55 AM, musicmaster said:

This is a rather common one. 

See here: https://github.com/PrestaShop/PrestaShop/issues/33524

Try the solution offered there in the last post and report your experience.

If that doesn't solve read the whole thread and try the other options.

I dont really get what to do.. sorry if i am an idiot.

[musicmaster]

On 10/2/2023 at 1:21 PM, BullyBlue said:

I dont really get what to do.. sorry if i am an idiot.

That post says that the guy solved the problem by changing the number 1013 into 1016 in some file. Not really rocket science.

Change app/config/doctrine.yml:

The line
1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

should be changed into
1016: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

Edited July 15 by musicmaster (see edit history)

[ps8modules]

\app\config\doctrine.yml

before:

1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

after:

1016: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%'

 

[BullyBlue]

Thank you very much!

It might not be rocket science for you - but it was for me.

 

Thanks and closed