magenx / Magento-2-server-installation

Magento 2 Server Installation - MagenX e-commerce stack on Ubuntu 20/22.04 | Debian 11/12
https://magenx.sh
186 stars 83 forks source link

Current version of RDBMS is not supported. #232

Closed jorgb90 closed 5 months ago

jorgb90 commented 7 months ago

Just installed a new server with MagenX but when running setup:upgrade I am getting the following error:

Current version of RDBMS is not supported. Used Version: 10.11.7-MariaDB-1:10.11.7+maria~ubu2204. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.6)

I changed app/etc/di/xml into 10.11 but then I am getting the following error:

Warning: preg_match(): Compilation failed: range out of order in character class at offset 25 in /home/xxx/public_html/vendor/magento/framework/DB/Adapter/SqlVersionProvider.php on line 101

You also change this file to make it compatible with MariaDB 10.11?

makproductions commented 7 months ago

Hey @jorgb90

Its advised to install MariaDB version which is supported by magento. However there is a workaround for this. Which is to modify the di.xml file and change the MARIADB requirements. You can do this by editing file app/etc/di.xml

Search for this line and change it: FROM <item name="MariaDB-(10.2-10.6)" xsi:type="string">^10\.[2-6]\.</item> TO <item name="MariaDB-(10.2-10.6)" xsi:type="string">^10</item>

Again, a temporary work around. Ive been using magento with the latest version of mariadb and have not had issues. Hope it helps

jorgb90 commented 7 months ago

@makproductions Thanks, but I did this as you can read in my post and that worked perfectly before but MagenX script is now installing MariaDB v10.11

As you can see here https://github.com/magenx/Magento-2-server-installation/blob/2f8822d1eb20396db7df4eece39b14d5d603f90f/magenx.install.latest.sh#L27C1-L27C24

and thats giving the following error when di.xml is changed accordingly

Warning: preg_match(): Compilation failed: range out of order in character class at offset 25 in /home/xxx/public_html/vendor/magento/framework/DB/Adapter/SqlVersionProvider.php on line 101

@magenx

artmouse commented 7 months ago

@jorgb90 https://github.com/Sental/db-override

jorgb90 commented 7 months ago

@artmouse

Thanks! Module also only alters the di.xml but I think I must have done something wrong myself, cause through the module its working and not complaining further.

musabatas commented 7 months ago

<item name="MariaDB-10.x" xsi:type="string">^10.\d{1,2}.</item>

themew commented 5 months ago

Just updated to 2.4.6-p5 and this has never let me down. We use it when installing any Magento version with 10.11

<item name="MariaDB-(10.2-10.11)" xsi:type="string">^10\.([2-9]|10|11)\.</item>