upgrade to mariadb 10 and question marks

magj

• July 12, 2015 10:16

Hi I have a cpanel server which I tried to upgrade the mysql to mariadb 10, now everything works except many joomla 1.5 websites which were using unicode languages are now displaying question mark instead of every character: ??????????????? ????????? There are tens of this kind of website. I took a look, the data is ok on databases (via phpmyadmin). Any help would be greatly appreciated.

• 

  magj

  • July 17, 2015 11:36

  I asked in joomla and mariadb forum and no answers so I inspected and found the issue, I post here so if any site administrator needs to benefit the mariadb 10 for even older and non-supported versions of joomla can use this quick fix. hope it helps in
  libraries/joomla/database/database/mysql.php
  or (depending on your setting)
  libraries/joomla/database/database/mysqli.php
  comment the line 186
  return ($verParts[0] == 5 || ($verParts[0] == 4 && $verParts[1] == 1 && (int)$verParts[2] >= 2));
  and add this instead(assuming these days you'll have unicode supported database:
  return (1);
  the code looks like:
  function hasUTF() { $verParts = explode( '.', $this->getVersion() ); // return ($verParts[0] == 5 || ($verParts[0] == 4 && $verParts[1] == 1 && (int)$verParts[2] >= 2)); return (1); }
  Best

  0
• 

  cPanelMichael

  • August 06, 2015 15:26

  Hello :) I'm happy to see you were able to address the issue. Thank you for updating us with the outcome.

  0
• 

  magj

  • August 07, 2015 10:04

  Hello :) I'm also happy to overcome this (then-horrible) issue. I think there are hundreds of thousands of Joomla 1.5 websites there so the servers should not wait to see them upgraded to be able to use new versions of Database. Best

  0

Please sign in to leave a comment.