Moodle in English: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Nick Kings - Saturday, March 18, 2017, 1:51 AM

Hi,

I'm trying to install a completely fresh instance of Moodle3.2; I've followed this instruction set:

git clone git://git.moodle.org/moodle.git htdocs
cd htdocs
git branch --track MOODLE_32_STABLE origin/MOODLE_32_STABLE
git checkout MOODLE_32_STABLE
I then go to the web interface, click to start the installation
I enter the correct Database credentials
And then the installation stops with this error: "this test must pass
Your database has tables using Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please convert the tables to the Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda."
I've tried the command " php admin/cli/mysql_compressed_rows.php --fix" but the command finishes with "No changes necessary
Thanks

Nick

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 841
Server version: 5.6.33-0ubuntu0.14.04.1 (Ubuntu)

php -v
PHP 5.6.23-1+deprecated+dontuse+deb.sury.org~trusty+1 (cli)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Vjekoslav Hlede - Saturday, March 18, 2017, 3:22 PM

Hi Nick,

I'm experiencing the same issue. I'm getting report as the image below illustrates.

History. On 3 March 2017 I attempted to instal the latest version. Got the same error. But then I attempted with Moodle 3.2.1 (Build: 20170109), and it worked. Now both available 3.2 versions (3.2.2 and 3.2.2+) can not be installed on my server because of the same error.

Fortunately, I have the 3.2.1 zip file, and I can install that one.

However, on the Choose database driver page I get this message:

Notice: Undefined property: stdClass::$curlsecurityallowedport in /home/cpdus17/public_html/moodle/lib/classes/files/curl_security_helper.php on line 238

Notice: Undefined property: stdClass::$curlsecurityblockedhosts in /home/cpdus17/public_html/moodle/lib/classes/files/curl_security_helper.php on line 250

But otherwise installation of 3.2.1 works.

Baracuda_test

My server runs on:

PHP Version 5.6.30
mysqlnd 5.0.11-dev

I will check if the issue persist after MySQL upgrade to 5.6.35.

Vjeko

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by clayton massey - Wednesday, April 19, 2017, 12:10 PM

I am having the exact same issue. I've tried v3.1.5 v3.15+ v3.2.2 v3.2+

I have tried running the command line fixes that are recommend, but my database is empty. So the "$ php admin/cli/mysql_compressed_rows.php --list" Shows no errors.

I am running a goddaddy CentOS 6 + cPanel.

Any help would be appreciated.

Clay

Attachment Screen Shot 2017-04-18 at 9.04.00 PM.png

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by sandeep baghel - Wednesday, April 19, 2017, 12:45 PM

Hello Clayton,

below is the solution for your query:-

For resolving the UTF-8 problem :- Please login into phpmyadmin using root credentials and then click on the database you want to use for Moodle. Once done, click on operations and then you will get collation section. In collation section, select "utf8_general_ci". Once done, you will get few errors removed.

For Barracuda issue, This document will work (please follow step by step process) :- https://docs.moodle.org/32/en/MySQL_full_unicode_support#File_format

You will just have to paste the codes written in above page to my.cnf file and then restart the mysql server.

Once above mentioned steps will be done, you shall be able to move ahead with the installation without any errors .

Kindly update me if you will get all your problems solved.

Regards,
Sandeep Baghel

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by clayton massey - Wednesday, April 19, 2017, 1:42 PM

Hey Sandeep, thanks for the quick reply. I have those settings already.

If you want I can email you my credentials.

Attachment Screen Shot 2017-04-18 at 10.34.00 PM.png

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by sandeep baghel - Wednesday, April 19, 2017, 2:14 PM

Hello Clayton,

I have resolved the issues in your server and Moodle is now installed.

I am sending you the credentials through message and you shall change the password immediately.

Hope you will have excellent experience using Moodle.

Regards,
Sandeep Baghel

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by clayton massey - Wednesday, April 19, 2017, 10:53 PM

Thank you Sandeep, what was the issue? I really appreciate your quick response.

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by sandeep baghel - Thursday, April 20, 2017, 12:46 PM

Hello Clayton,

There was a issue with additional codes in your config.php file.

I removed that as you have already done the settings perfectly in my.cnf. So, custom codes of config.php file were creating conflict.

Regards,
Sandeep Baghel

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Fred Cole - Wednesday, April 26, 2017, 10:29 PM

Hi,

Can this be done on shared hosting?

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Rahul Rai - Wednesday, July 19, 2017, 6:32 PM

I am also face same problem.

but i resolve problem after some changes.

copy below code and paste in your my.cnf

[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4

Restart your MySQL server.

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Howard Miller - Wednesday, July 19, 2017, 6:41 PM

Just noting that the OP is no longer a member of these forums.

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Michael Schmid - Friday, July 14, 2017, 9:20 AM

I was seeing this error and what solved it for me was changing this line in config.php

'dbcollation' => 'utf8_unicode_ci', // MySQL has partial and full UTF-8

// support. If you wish to use partial UTF-8

// (three bytes) then set this option to

// 'utf8_unicode_ci', otherwise this option

// can be removed for MySQL (by default it will

// use 'utf8mb4_unicode_ci'. This option should

// be removed for all other databases.

Initially it read : utf8mb4_unicode_ci ...

Average of ratings:Useful (1)

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by aswathy p - Saturday, December 9, 2017, 2:56 AM

hi michael ,

thanks for this, that reALLY worked for me

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Reham Esmat - Saturday, September 15, 2018, 9:28 PM

I have the same problem here

i'm installing moodle 3.5.2+

can any one help me with this, I can't make the steps that mention above

Average of ratings: -

Re: Unable to install 3.2 - Please convert the tables to the Barracuda file format.

by Sandie Kappes - Tuesday, September 25, 2018, 12:17 AM

Reham,

Try the fix suggested above - https://moodle.org/mod/forum/discuss.php?d=349351#p1433791 - about changing the dbcollation value in config.php. I had almost given up on running Moodle 3.5 on a shared server since most suggestions required changing global settings that cannot be done. This simple fix was all it took.

It would be great if the Moodle install/upgrade documentation included information about this fix. I'm sure there are a lot of Moodle installations running on shared servers by those who do not have the option to move to a more expensive dedicated server environment. I hope the Moodle developers don't forget about this group of users.

Average of ratings: -

Installing and upgrading help

Unable to install 3.2 - Please convert the tables to the Barracuda file format.