DARKF3D3 Posted July 3, 2023 Share Posted July 3, 2023 I can't find information anywhere about which versions of MariaDB are supported by Prestashop. How is it possible that prestashop team doesn't release a compatibility list like it does for example with php? This information is even more important than the version of php, because with php it only takes one click to revert to a different version. While downgrading mariadb can't be done, or at least it is not an easy and safe operation to do. I mean... what happen If I upgrade to last MariaDB version (10.11) when using PS1.7? We need something like what Wordpress do: Link to comment Share on other sites More sharing options...
cruftex Posted July 8, 2023 Share Posted July 8, 2023 I plan to use MariaDB since I thought it is basically compatible. However, I discovered an issue and would recommend using MySQL for normal users. See my bug report here: https://github.com/PrestaShop/PrestaShop/issues/33157 Link to comment Share on other sites More sharing options...
DARKF3D3 Posted July 8, 2023 Author Share Posted July 8, 2023 Which MariaDB version do you used? Link to comment Share on other sites More sharing options...
fmoreira86 Posted July 8, 2023 Share Posted July 8, 2023 Based on PS official demo: Database information MySQL version: 10.5.19-MariaDB-0+deb11u2 Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 Sorry to break in here. I am working on a fresh Prestashop 8***, but apparently I made a mistake somewhere when entering the Mariadb. Can I just create a new one or correct it via the web? Link to comment Share on other sites More sharing options...
Nickz Posted January 20 Share Posted January 20 (edited) Check your conecction data in your shop, if correct. To answer your question: Yes create a new DB. 1 hour ago, Generaal said: correct it via the web? Edited January 20 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 Thnx Nickz, where can I find the file to check the settings for the database? Link to comment Share on other sites More sharing options...
Nickz Posted January 20 Share Posted January 20 (edited) That depends on which shop you are running usually it's in /config/settings.inc.php or /app/config/ if newer Edited January 20 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 I Have just install PrestaShop 8.1.3. But in the config folder, are no settings.inc.php file. Link to comment Share on other sites More sharing options...
Nickz Posted January 20 Share Posted January 20 1 hour ago, Generaal said: But in the config folder, are no settings.inc.php file. neither in/app/config/ ??? Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 There are nothing pointing to the database.. Link to comment Share on other sites More sharing options...
Nickz Posted January 20 Share Posted January 20 (edited) set_parameters.php would be my guess . If you know that little about shops why don't you look for a team which works with you? How will you solve issues like updates, hacks, backups? Edited January 20 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 Nope. I have open it and inspect. Nothing thats point to the database. Link to comment Share on other sites More sharing options...
Generaal Posted January 20 Share Posted January 20 That is now, \app\config\parameters.php. I have to digging deeper. when I change there the DB settings to what I have configure in the VPS server, thats the way to go? what with the port number? Link to comment Share on other sites More sharing options...
Generaal Posted January 24 Share Posted January 24 Problem are solved. Up to the next! I created an SSL certificate via SSH on my VPS, this was supposedly granted, but my webshop no longer starts with any prefix: www, http or https. Do I need to change anything in a Prestashop file? Or have I made a mistake somewhere in creating the certificate? Link to comment Share on other sites More sharing options...
Nickz Posted January 24 Share Posted January 24 5 hours ago, Generaal said: I created an SSL certificate via SSH on my VPS Well that is pretty unprecise. What kind off SSL? Self signed? Letsincrypt? The www or not you do in htaccess usually. Link to comment Share on other sites More sharing options...
Generaal Posted January 24 Share Posted January 24 Self signed, via Certbot, let’s Encrypt. Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 I think, the ssl installation are okay. And the Virtual sever file are: <VirtualHost *:80> ServerName selectkoffie.be Redirect / https://selectkoffie.be/ DocumentRoot /var/www/html ServerAlias www.selectkoffie.be ErrorLog /var/www/error.log CustomLog /var/www/requests.log combined RewriteEngine on RewriteCond %{SERVER_NAME} =selectkoffie.be [OR] RewriteCond %{SERVER_NAME} =www.selectkoffie.be RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent] </VirtualHost> Link to comment Share on other sites More sharing options...
Nickz Posted January 25 Share Posted January 25 self signed ssl are not recognised by browser using the chrome engine so far I know. https://superuser.com/questions/1751696/chrome-107-marks-self-signed-certificate-not-secure-despite-cert-is-installed You could install a vestacp o hestia cp and you have the ssl install in a brezze. Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 I know this is a fact, but it shouldn't happen that prestashop doesn't open anymore after I installed them correctly. I'm not an IT guy, and my previous prestashop knowledge dates back years (1.5 version). Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 Thnx, but you have to install the panel on a blank sever to start. Link to comment Share on other sites More sharing options...
Nickz Posted January 25 Share Posted January 25 Just use --force after the install script. Well you need to redo the instalation or re-upload. Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 Hmm, I don't re-install on a fresh sever? Link to comment Share on other sites More sharing options...
Nickz Posted January 25 Share Posted January 25 Reinstall the distro, Debian, Ubuntu I use but hardly ever the newest. Then get teh install scrip from the vesta o hestia page. Download your data before you start. Files and database. It pays off to have a proper install in the long run. And you learn at it. Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 Thnx for you support! Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 Error: Failed to download metadata for repo 'vesta': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried Error: yum update failed [root@server ~]# sudo dnf update Vesta - cmmnt 3.3 kB/s | 1.4 kB 00:00 Errors during downloading metadata for repository 'vesta': - Status code: 404 for http://r.vestacp.com/cmmnt/9/x86_64/repodata/repomd.xml (IP: 104.236.66.100) Error: Failed to download metadata for repo 'vesta': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried [root@server ~]# Do I have to use my email as "userNAME"? There going nothing... Link to comment Share on other sites More sharing options...
Nickz Posted January 25 Share Posted January 25 (edited) In vesta and hestia they use admin as username. Don't you have a Control Panel for the VPS? Edited January 25 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 I run AlmaLinux9.2 and are not support. Link to comment Share on other sites More sharing options...
Generaal Posted January 25 Share Posted January 25 I use cockpit as panel. I can also choose for Virtualadmin, but It's have a heavy consumption on you RAM. Link to comment Share on other sites More sharing options...
Nickz Posted January 25 Share Posted January 25 (edited) Try this here https://community.letsencrypt.org/t/step-by-step-instructions-for-installing-and-using-certbot-manually/120369 you can install vesta o hestia in any distro I think, you need to be up to it though. Edited January 25 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
ArnasDEV Posted September 6 Share Posted September 6 Hey guys, what MariaDB version do you recommend for PS v8.1.7 ? Link to comment Share on other sites More sharing options...
wayan02 Posted September 6 Share Posted September 6 Ver 15.1 Distrib 10.11.9-MariaDB should be work and in case something not work, You can try to disable sql_mode by adding this line on You mysql cnf sql-mode="" Link to comment Share on other sites More sharing options...
ArnasDEV Posted September 6 Share Posted September 6 i am currently using [email protected] with v1.7 shops, I will try 10.11 for PS8.1. It's just strange that these settings are not officially documented in PS docs. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now