Skip to main content

Upgrading MariaDB and old sites

panit
My server is currently using Maria 5.6 and I am wanting to upgrade to V 10. But there are quite a few sites on the server that can only run php 5.3. Will upgrading Maria cause problems with those sites? I'm getting different answers and no one seems to know for sure. I've checked the Maria site but their doc's don't cover this, at least that I can find.

Comments

5 comments

Date Votes
  • cPanelMichael
    Hello @panit, Can you confirm that the system currently uses MySQL 5.6? If so, MariaDB 10.0 is a drop-in replacement for MySQL version 5.6, so you shouldn't have any problems with your scripts after that upgrade. Thank you.
    0
  • panit
    The server was using 5.6 so I scheduled this change in and it was just completed. There were, are, may failures. Almost all of them have to do with size and default values in the database, likeField 'some field' doesn't have a default value
    and Data too long for column 'some field'
    I understand these are legitimate failures but it is happening with many sites and they all worked before. Is there a setting, like php "strict" setting in Maria that will ignore these situations. A more important failure is one with a Greek based shop. None of the textarea's are being filled in. I have verified the data is being read from the database but it does not appear in the textarea. I can't think of anywhere to even begin with it. It worked before the upgrade so it has to be due to that. Does anyone have any suggestions?
    0
  • cPanelMichael
    Hello @panit, Can you verify if you have the sql-mode option configured to a specific value in your /etc/my.cnf file or /usr/my.cnf (if it exists)? You can check with the following commands: grep sql_mode /etc/my.cnf grep sql_mode /usr/my.cnf
    Thank you.
    0
  • panit
    The one in etc/ is set to "NO_ENGINE_SUBSTITUTION" and the one in usr/ is blank. I asked my host to make those changes but instead they said they "switched the mysql modules for PHP 5.3 from mysqli to mysqlnd.". I don't know that that was all they did since that php version is only used on one of the accounts on the server but whatever they changed worked. The only remaining issue now is with enlarging images. It is only for that one site that is running 5.3. The code uses the GD Library. The images enlarged prior to this change. Is there something in this upgrade that would affect the GD Libray? I thought that was just a php element.
    0
  • cPanelMichael
    The only remaining issue now is with enlarging images. It is only for that one site that is running 5.3. The code uses the GD Library. The images enlarged prior to this change. Is there something in this upgrade that would affect the GD Libray? I thought that was just a php element.

    Hello @panit, Keep in mind that PHP version 5.3 is at end-of-life status and is no longer supported. The best approach to solving this issue is to ensure the script is updated to work on a supported version of PHP. That said, the issue you described suggests a required PHP module is missing. You noted that GD is installed. Can you confirm if the script requires FreeType, and if so, if your PHPINFO file shows that FreeType is enabled? Your hosting provider may need to confirm this for you if you do not have root access to the server. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post