PHP Fatal error: Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: Invalid platform version "5.5.5-10.1.25-MariaDB

[stfast]

Reporting also here:

nextcloud/server#6193

After upgrade from NextCloud 11 to NextCloud 12 I got this messages and NextCloud Stops working:

error_log-owncloud:[Mon Aug 21 01:15:59.802107 2017] [:error] [pid 47351] [client 172.16.101.54:63176] PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: Invalid platform version "5.5.5-10.1.25-MariaDB" specified. The platform version has to be specified in the format: "<major_version>.<minor_version>.<patch_version>". in .../nextcloud-12.0.2/lib/private/DB/Connection.php:61\nStack trace:\n#0 :q
(429): OC\DB\Connection->connect()\n#1 .../nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\DBAL\Connection->getDatabasePlatformVersion()\n#2 .../nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\DBAL\Connection->detectDatabasePlatform()\n#3 .../nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\DBAL\Connection->getDatabasePlatform()\n#4 .../n in .../nextcloud-12.0.2/lib/private/DB/Connection.php on line 61
nextcloud/server#6193

Server configuration

Operating system:
Fedora 26

Web server:

Apache httpd 2.4.20

Database:

10.1.25-MariaDB MariaDB Server

PHP version:

PHP 7.0.7

Nextcloud version: (see Nextcloud admin page)

12.+

**Updated from an older Nextcloud/ownCloud or fresh install:

Update from OwnCloud 9.1.0 to NextCloud 10, NextCloud 11 and still working

[MorrisJobke]

@doctrine maintainers:

Nextcloud 11: Doctrine 2.5.5 (https://github.com/nextcloud/3rdparty/blob/stable11/composer.json#L11)
Nextcloud 12+: Doctrine 2.5.9 (https://github.com/nextcloud/3rdparty/blob/stable12/composer.json#L11)

Is this a problem how the version number is reported by mariaDB here?

Update from OwnCloud 9.1.0 to NextCloud 10, NextCloud 11 and still working

This one looks weird, because we didn't changed that much in version numbers in Doctrine.

@stfast Did you recently updated the mariaDB server?

[morozov]

Could you try reproducing the issue in isolation? The example below works fine for me on v2.5.9:

<?php

$driver = new \Doctrine\DBAL\Driver\Mysqli\Driver();
$platform = $driver->createDatabasePlatformForVersion('5.5.5-10.1.25-MariaDB');
var_dump($platform);

/*
class Doctrine\DBAL\Platforms\MySqlPlatform#2 (4) {
  protected $doctrineTypeMapping =>
  NULL
  protected $doctrineTypeComments =>
  NULL
  protected $_eventManager =>
  NULL
  protected $_keywords =>
  NULL
}
*/

[mikeSimonson]

If you could make a test so that we could reproduce the bug that would be helpfull.

[stfast]

Will do that ASAP with our developer. I can reproduce it with fresh install of OwnCloud 9.x on any Fedora 2+ and I get same error during installation. Last year I think I had the same issue and I am sure I overcame this error with adding a version "5.5.5-10.1.23-MariaDB" in one of "versions" file, which I could not find it any more. Is there a file where DBAL is checking supported "versisons".

[stfast]

I get same results:

[root@vx1 dbal]# php test.php
object(Doctrine\DBAL\Platforms\MySqlPlatform)#3 (4) {
["doctrineTypeMapping":protected]=>
NULL
["doctrineTypeComments":protected]=>
NULL
["_eventManager":protected]=>
NULL
["_keywords":protected]=>
NULL
}

[mikeSimonson]

@stfast That's the correct result (aka the connection is working fine and you could thus not reproduce the error).

[belgattitude]

See #2825 , I've implemented a fix for that too.

[stfast]

I've cloned latest dbal version and now I am getting new type of error:

[Tue Aug 29 15:38:54.393757 2017] [:error] [pid 30288] [client 172.16.103.21:42650] PHP Fatal error: Uncaught TypeError: Return value of Doctrine\DBAL\DriverManager::_checkParams() must be an instance of Doctrine\DBAL\void, none returned in /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php:213\nStack trace:\n#0 /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(153): Doctrine\DBAL\DriverManager::_checkParams(Array)\n#1 /owncloud/nextcloud-12.0.2/lib/private/DB/ConnectionFactory.php(149): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))\n#2 /owncloud/nextcloud-12.0.2/lib/private/Server.php(579): OC\DB\ConnectionFactory->getConnection('mysql', Array)\n#3 /owncloud/nextcloud-12.0.2/3rdparty/pimple/pimple/src/Pimple/Container.php(113): OC\Server->OC\{closure}(Object(OC\Server))\n#4 /owncloud/nextcloud-12.0.2/lib/private/AppFramework in /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php on line 213

[Ocramius]

@stfast if you run a composer install it will tell you that your PHP version is not supported.

You need PHP 7.1.

[stfast]

Upgraded to PHP 7.1.7. Installed fresh dbal: [root@owncloud doctrine]# git clone https://github.com/doctrine/dbal.git Error: [Tue Aug 29 16:43:45.249115 2017] [php7:error] [pid 49522] [client 172.16.103.21:57080] PHP Fatal error: Uncaught Doctrine\\DBAL\\DBALException: Invalid platform version "5.5.5-10.1.26-MariaDB" specified. The platform version has to be specified in the format: "<major_version>.<minor_version>.<patch_version>". in /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:80\nStack trace:\n#0 /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php(132): Doctrine\\DBAL\\DBALException::invalidPlatformVersionSpecified('5.5.5-10.1.26-M...', '<major_version>...')\n#1 /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(401): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->createDatabasePlatformForVersion('5.5.5-10.1.26-M...')\n#2 /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(340): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /owncloud/nextcloud-12.0.2/3rdparty/doctrine/d in /owncloud/nextcloud-12.0.2/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 80 .si

…

On Aug 29, 2017, at 3:45 PM, Marco Pivetta ***@***.***> wrote: @stfast <https://github.com/stfast> if you run a composer install it will tell you that your PHP version is not supported. You need PHP 7.1. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2819 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABEZsUrvmPyOmqGPzPKEMmxyEsOvioLqks5sdBYAgaJpZM4O9Zuh>.

[belgattitude]

@stfast, #2825, has not been merged yet. pull the pr or use the composer trick explained in the comment. Let me know.