/
MySQL 5.7 fails to load collection in Uploader

MySQL 5.7 fails to load collection in Uploader

If the LUNA Uploader and the Library will not load the Uploader batches and you are using MySQL 5.7 you will need to do the following.


  1. Edit mysql condiguration file

    1. sudo nano /etc/mysql/my.cnf
      or 
    2. sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

     

  2. Add this to the end of the file and in the section [mysqld] 

    [mysqld]
    sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


  3. sudo service mysql restart

 

Related content

MySQL 5.7 fails to load collection in Uploader
MySQL 5.7 fails to load collection in Uploader
More like this
MySQL 5.7 fails to load collection in Uploader
MySQL 5.7 fails to load collection in Uploader
More like this
MySQL 5.7 fails to load collection in Uploader
MySQL 5.7 fails to load collection in Uploader
More like this
LUNA 7.1.0.3 Release Notes
LUNA 7.1.0.3 Release Notes
More like this
LUNA 7.1.0.3 Release Notes
LUNA 7.1.0.3 Release Notes
More like this
Images fail to export or will not add to other collections on migrated collections in Library
Images fail to export or will not add to other collections on migrated collections in Library
More like this