Start a conversation

Error while converting Scriptcase with MySQL database (MariaDB)

If your Scriptcase is installed under the database MySQL (MariaDB) and during the conversion process it presents the error below, please follow the steps hereinafter.

ERROR:

error insert SC_TBAPL = Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT = DYNAMIC or ROW_FORMAT = COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.


This error is a lack of configuration in the my.cnf. You must change setting before the conversion process on Scriptcase.

1 - Perform a full backup of your databases, and then shut down (stop) the Database service.

2 - Open the configuration file my.cnf ,  in the session [mysqld], and perform the following changes:

innodb_file_per_table = On
innodb_file_format = Barracuda
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M


       3 - Start the database service again.


After that you can restart the conversion process.

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Jefferson Albuquerque

  2. Posted
  3. Updated

Comments