General developer forum

Issues upgrading Moodle 3.4.2+ (Build: 20180322)

 
Picture of Ezequiel Villanueva
Issues upgrading Moodle 3.4.2+ (Build: 20180322)
 

I have 3 Issues upgrading Moodle 3.4.2+ (Build: 20180322)

1) 

databasemysql (5.5.5-10.1.32-MariaDB)

2)

mysql_full_unicode_support#File_format

Your database uses Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please switch to the Barracuda file format. See the documentation MySQL full unicode support for details.


3)

mysql_full_unicode_support#Large_prefix

For full support of UTF-8 both MySQL and MariaDB require you to change your MySQL setting 'innodb_large_prefix' to 'ON'. See the documentation for further details.


 
Average of ratings: -
Picture of Richard Jones
Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)
Particularly helpful MoodlersPlugin developersTesters

I have 3 solutions:

1) Upgrade your database version

2) Run these commands (or set these variables):

  mysql> SET GLOBAL innodb_file_format = barracuda;

  mysql> SET GLOBAL innodb_file_format_max = barracuda;

3) mysql> SET GLOBAL innodb_large_prefix = on;

There's also this thread which I googled for you:

https://moodle.org/mod/forum/discuss.php?d=350838

Hope this helps.



 
Average of ratings: Useful (1)
Picture of Ezequiel Villanueva
Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)
 

Hello Richard,

I have now the following error: 
databasemysql (5.5.5-10.2.14-MariaDB)
I contacted the CPANEL SUPPORT AND THEY TOLD ME THE FOLLOWING:
Thank you for contacting cPanel. This looks to be an issue with Moodle, as your server is running MariaDB 10.2.14:

[09:35:52 server root@9402217 ~]cPs# mysql --version
mysql Ver 15.1 Distrib 10.2.14-MariaDB, for Linux (x86_64) using readline 5.1

[09:36:20 server root@9402217 ~]cPs# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 88
Server version: 10.2.14-MariaDB MariaDB Server

I'm not sure how Moodle is detecting the MySQL version, but you'd need to contact them for further assistance given that your server is running a version of MySQL higher than required. I apologize for the inconvenience.

Thanks,
Ezequiel

 
Average of ratings: -
Picture of Ezequiel Villanueva
Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)
 

Hello Richard Moodle thanks for helping and Anujna I got it fix.

Ezequiel 

 
Average of ratings: -
Picture of Richard Jones
Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)
Particularly helpful MoodlersPlugin developersTesters

Hi Ezequiel

See this stack overflow thread:

https://stackoverflow.com/questions/49592857/mysql-5-5-5-10-2-14-mariadb

Apparently someone with the same name as you has fixed this.

Richard

 
Average of ratings: -
Picture of Richard Jones
Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)
Particularly helpful MoodlersPlugin developersTesters

big grin

 
Average of ratings: -