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

Â