Trouble in Backoffice after moving to a new VPS

[Petter Enge]

Hello

I really need your help guys.

I am moving my webshops to a new VPS and have used the import from another site function.  I have several webshops and have used this feature for all my shops and it works very well  Except for one of them.  On this trouble webshop the front is working well.  When I go to the Backoffice I get to the login page and are able to log in but the backoffice shows that he page is not working.  I turn on development mode to see if I get an error message,  What i get is:

(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

I have tried the hints I get on the url without any sucsess.

The Prestashop version I am using is (not sure)

The VPS is running Debian

The php version is 7.3.33

All this is the same as the other webshops I have imported and the php.ini has the same values as the other shops and also from the source server.

I am really stucked here.

Can someone help ?

THANKS

Petter

 

[musicmaster]

Join the club. This is a known error in some installations. But what causes it is still unknown. It is discussed n Github at https://github.com/PrestaShop/PrestaShop/issues/33524

A provisional solution is to apply a server_version variable yourself. See https://stackoverflow.com/questions/67934455/an-exception-occured-while-establishing-a-connection-to-figure-out-your-platform

You should change the file app/config/doctrine.yml. The top should look like this:

# Doctrine Configuration
doctrine:
  dbal:
    default_connection: default

    connections:
      default:
        server_version: 8.0
        driver: pdo_mysql

This server_version line is added. Note that it must be on top under "default:".

Edited July 15 by musicmaster (see edit history)