Installing and upgrading help

How to fix status 'unsupported_db_table_row_format' from check to ok?

 
Picture of Bernardus Ivan
How to fix status 'unsupported_db_table_row_format' from check to ok?
 

I get that status on my moodle installation
  1. how to fit it?
  2. is that an issue?

Spec :

  • PHP Version 5.5.9-1ubuntu4.9
  • Linux server1 2.6.32-042stab108.2 #1 SMP Tue May 12 18:07:50 MSK 2015 x86_64
  • Apache/2.4.7 (Ubuntu)
  • MYSQL 5.5.43
  • Moodle 2.9+ (Build: 20150528)
  • hertanto.com

hertanto.com/info.php


Thx Before


Ivan


 
Average of ratings: -
Picture of Ken Task
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
Particularly helpful Moodlers

Login using ssh to your site.

cd /pathtomoodlecode/admin/cli/

There is a CLI only script that will do what's needed:

called mysql_compressed_rows.php

Script for detection of row size problems in MySQL InnoDB tables.

By default InnoDB storage table is using legacy Antelope file format
which has major restriction on database row size.
Use this script to detect and fix database tables with potential data
overflow problems.

Options:
-i, --info            Show database information
-l, --list            List problematic tables
-f, --fix             Attempt to fix all tables (requires SUPER privilege)
-s, --showsql         Print SQL statements for fixing of tables
-h, --help            Print out this help

So to get info while in /pathto/moodlecode/admin/cli/ type:

php mysql_compressed_rows.php -i

To list tables with problems:

php mysql_compressed_rows.php -i

to fix tables that have problems:

php mysql_compressed_rows.php -f

I've had to use it recently when upgrading 2.6's to 2.7.8+ and it does work as advertised.   Matter of fact, I had attempted a git upgrade to a site which failed with a warning about the issue.   Without leaving the command line, executed the commands above to fix and then resumed the git upgrade without issue.

'spirit of sharing', Ken


 
Average of ratings: Useful (3)
Picture of Bernardus Ivan
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
 
php mysql_compressed_rows.php -i
Database version:      5.5.43-0ubuntu0.14.04.1
Database name: moodledb
Database engine: InnoDB
innodb_file_per_table: OFF
innodb_file_format: Antelope
php mysql_compressed_rows.php -f

Cannot enable GLOBAL innodb_file_per_table setting, use --showsql option and execute the statements manually.!!! Error writing to database !!!

how to fix that?

 
Average of ratings: Useful (1)
Picture of Ken Task
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
Particularly helpful Moodlers

Use:

php mysql_compressed_rows.php --showsql

Which will show the sql statements to fix.   Then, in something like Webmin's SQL tool or phpmyadmin, run the query.

Could be the DB user you have in config.php doesn't have priv to do what is needed.

'spirit of sharing', Ken

 
Average of ratings: Useful (2)
Picture of Bernardus Ivan
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
 

thx alot, i solve it smile

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
Particularly helpful Moodlers
I posted a detailed "screen-shot" here: https://moodle.org/mod/forum/discuss.php?d=312863#p1255850.

The problem could be that some of those SQL statements need super user privileges in the database.
 
Average of ratings: Useful (1)
Picture of Bernardus Ivan
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
 

thx alot, i solve it smile

 
Average of ratings: -
Picture of Loudy MD.
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
 

Hi, 

Can any one advise me what is going on sad

Every time I type php mysql_compressed_rows.php -i

I got this message:

Moodle 2.7 or later requires at least PHP 5.4.4 (currently using version 5.3.29).

Some servers may have multiple PHP versions installed, are you using the correct executable?

-----------

Also, is there is any easy to fix the: unsupported_db_table_row_format

and do I need to really fix this? as I see it look like complicated


Thanks, 

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
Particularly helpful Moodlers
Probably your command line PHP interpreter is older than the Apache module. Compare "php -v" on the CLI and phpinfo according to https://docs.moodle.org/en/PHP#Displaying_phpinfo_outside_of_Moodle.
 
Average of ratings: -
Picture of Loudy MD.
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
 

Hi, 

Please can you advise, as my hosting company says its not big deal about this warning?

I have reviewed your request carefully. We would be happy to assist you with patching the issues listed in your report, however, your account is located on a shared server and some of the global configurations cannot be changed. Patching the reported MySQL problem:

unsupported_db_table_row_format

requires executing a database queries which are related to the global MySQL configuration on the shared server:

Code:
SET GLOBAL innodb_file_per_table=1;
SET GLOBAL innodb_file_format=Barracuda;


and we cannot change such global settings for the whole server. I have noticed that your site is working as expected at the moment and this is rather a warning than a critical issue. I couldn't detect any issue caused by the current configuration, so you can safely ignore this warning.
 
Average of ratings: Useful (1)
Picture of Visvanath Ratnaweera
Re: How to fix status 'unsupported_db_table_row_format' from check to ok?
Particularly helpful Moodlers
Hi

What they say is true. Those two SQL commands are system-wide as such may affect other customers. You options are, either continue as it is, this is just a warning, or change the hosting provider.
 
Average of ratings: -