Hello,
What version of MySQL are you using? Is it MariaDB 5.x.x or MariaDB 10.x.x? MariaDB 5.x.x uses ROW_FORMAT= 'COMPACT' , or 'REDUNDANT'. MariaDB 10.x.x uses ROW_FORMAT= 'COMPACT' , 'REDUNDANT' , 'DYNAMIC' , or 'COMPRESSED'. The ROW_FORMAT can be easily changed with a simple MySQL Statement. I'll show you how.
1) First, make a backup of your Database, i.e.: use phpMyAdmin, go to your database and use the OPERATIONS tab and use the "Copy Database To" section to create an exact copy, name what it whatever you'd like. Then run the following query on your copied database (Change the "DATABASE_NAME_HERE" to your copied database name) :
This code will print out everything that has a table engine of "InnoDB".
SELECT CONCAT('ALTER TABLE ', table_schema, '.', table_name, ' ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables AS tb
WHERE table_schema = 'DATABASE_NAME_HERE'
AND `ENGINE` = 'InnoDB'
AND `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name ASC;
It will print out something similar to this:
ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_advertisements ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_hits ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_advertise_paypal ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_autowelcome_members ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_axenserverlist_servers ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_bbcode_mediatag ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_blog_blogs ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_blog_categories ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_blog_comments ENGINE=InnoDB;
ALTER TABLE DATABASE_NAME_HERE.ibf_blog_entries ENGINE=InnoDB;
In the below picture, you will get this: (As stated above)
Click the +OPTIONS link, you will now see this:
Make sure you click the "Full texts" radio button, leaving everything else alone, then click on 'GO'.
You will now see this appear:
It will show only 25 rows per page by default, but you can change that by doing this:
After you have all your rows appear, copy all the text to a text editor, and do a FIND & REPLACE option for:
Find:
Engine=InnoDB
Replace with: (If MariaDB 5.x.x)
ROW_FORMAT=REDUNDANT
Replace with: (If MariaDB 10.x.x)
ROW_FORMAT=DYNAMIC
Example:
ALTER TABLE tibtech.ibf_advertise_advertisements ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_advertise_hits ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_advertise_paypal ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_autowelcome_members ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_axenserverlist_servers ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_bbcode_mediatag ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_blog_blogs ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_blog_categories ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_blog_comments ROW_FORMAT=DYNAMIC;
ALTER TABLE tibtech.ibf_blog_entries ROW_FORMAT=DYNAMIC;
Once the FIND & REPLACE has been done, copy all your edits and go to your database SQL tab in phpMyAdmin, and paste it in there and run SQL Statements. Your tables with now have the proper ROW_FORMAT that will satisfy Invision Community Suite and the error will go away.
I hope this helps you and others with this annoying issue.
Best of luck,
-Donald