[BlueOnyx:20601] Re: how to downgrade mariadb 10 to 5.5 or MYSQL?

[Michael Stauber]

Hi Mon Chan.

> 1. Opencert : how to change mPDO driver?

You mean OpenCart? In the directory where OpenCart is installed there is
a config.php. In it change this line ...

define('DB_DRIVER', 'mysqli');

... to this:

define('DB_DRIVER', 'mpdo');

You need to do the same with admin/config.php, too.

> 2. Can you test OrangeHRM with installer setup?

I just tried. With the usual php-mysql I get this:

You need at least MySQL 4.1.x, Detected MySQL ver

When I replace php-mysql with php-mysqlnd it works and reports this (in
green color):

MySQL Client 	OK (ver mysqlnd 5.0.10 - 20111026 - $Id:
e707c415db32080b3752b232487a435ee0372157 $)
MySQL Server 	OK (ver 5.5.5-10.1.18-MariaDB)

> 3. For the joomla 1.5 with chinese text (Migrate from 5108R), i need add
> UTF8 support in my.cnf( I forget what set before.)

I just checked and found this article related and interesting:

https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/

Yes, you can set the character set for databases either on a global
(server) level. Or on a per database level.

The URL above give some tips on how to do this.

-- 
With best regards

Michael Stauber