cannot install Joomla 3.5.1 script

Submitted by realitybytes on Tue, 05/03/2016 - 11:23 Pro Licensee

Getting this script installation error after the latest round of Virtualmin upgrades. Server is fully up to date via webmin. All existing websites are fully ufnctional, just cannot install the joomla script anymore. (wordpress script works fine still)

Found https://github.com:443/joomla/joomla-cms/releases/download/3.5.1/Joomla_... in cache ..

Configuring webserver PHP settings .. .. already done. Applying web server configuration .. .. done

Now installing Joomla version 3.5.1 .. Failed to run database setup script : ERROR 1115 (42000) at line 14: Unknown character set: 'utf8mb4' . More information on using this script can be found at http://joomlacode.org/.

.. installation was only partially complete. Re-loading Webmin .. .. done

Applying web server configuration .. .. done

Status: 
Active

Comments

Submitted by andreychek on Tue, 05/03/2016 - 12:01

Howdy -- Hmm, I just wanted to clarify -- are you seeing that issue for new Joomla installs?

Or is it for upgrades to existing Joomla installs?

I see a number of references to similar problems in Joomla when I search for that issue on Google. I'm trying to work out what can be done to resolve that.

Submitted by realitybytes on Fri, 05/13/2016 - 11:47 Pro Licensee

Basically I am trying to create a brand new virtualmin site, and install joomla via the script and this is the error I get.

Submitted by JamieCameron on Sat, 05/14/2016 - 15:30

Which Linux distribution and version are you running there? I'd like to try to re-produce this in the same environment, as I suspect the problem is triggered by the MySQL version.

Submitted by andreychek on Sat, 05/14/2016 - 15:39

Also, could you share the output of this command:

rpm -qa | grep -i mysql

Submitted by DonPeek on Thu, 07/21/2016 - 12:17 Pro Licensee

I am needing to install Joomla 3.6.0 ( I know higher than your install scripts, but I hacked that.. )

But here is the error..... Failed to run database setup script : ERROR 1115 (42000) at line 14: Unknown character set: 'utf8mb4' .

Just did a yum update... and here is the RPM grep...

What can I do... Please help ..

Thanks...

Don

mysql-devel-5.1.73-7.el6.x86_64

perl-DBD-MySQL-4.013-3.el6.x86_64

mysql-libs-5.1.73-7.el6.x86_64

mysql-5.1.73-7.el6.x86_64

php54-php-mysqlnd-5.4.40-3.el6.x86_64

mysql-server-5.1.73-7.el6.x86_64

php-mysql-5.3.3-47.el6.x86_64

Submitted by andreychek on Thu, 07/21/2016 - 12:48

It looks like Joomla is trying to use "utf8mb4" for the database characterset, which isn't supported on the MySQL database version available in CentOS 6.

Now, I see that Joomla 3.x is supposed to be supported all the way back to MySQL 5.1, so in theory it should work.

Assuming that's still correct as of Joomla 3.6, I'll talk to Jamie about how best to resolve that. It may unfortunately take some time though, we're going to have to figure out where in the installation process that's getting set, and if it's possible to change it.

Submitted by DonPeek on Thu, 07/21/2016 - 20:08 Pro Licensee

Yes, this is going to be big if I can not find a fix for it.. that would mean upgrading Centos .. OMG ... panic... LOL ..

I would think that the SQL database could have the character set added. But I know it sounds easy. lol ..