Issues upgrading Moodle 3.4.2+ (Build: 20180322)

Issues upgrading Moodle 3.4.2+ (Build: 20180322)

by Ezequiel Villanueva -
Number of replies: 5

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: -
In reply to Ezequiel Villanueva

Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)

by Richard Jones -
Picture of Plugin developers Picture of Testers

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)
In reply to Richard Jones

Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)

by Ezequiel Villanueva -

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: -
In reply to Ezequiel Villanueva

Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)

by Ezequiel Villanueva -

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

Ezequiel 

Average of ratings: -
In reply to Ezequiel Villanueva

Re: Issues upgrading Moodle 3.4.2+ (Build: 20180322)

by Richard Jones -
Picture of Plugin developers Picture of Testers

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: -