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.
Edit mysql condiguration file
sudo nano /etc/mysql/my.cnf
orÂ
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Â
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"sudo service mysql restart
Â