I think I have figured out the solution..
This is caused by the new mysql 5.7.6 having a sql_mode set by default to NO_ZERO_IN_DATE,NO_ZERO_DATE. This is what throws up the errors and prevents the creation of three tables.
The solution is to add the following in my.cnf under [mysqld]
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Then delete the old mya2billing database and re-run the two steps: mysql -u root -p < DataBase/mysql-5.x/a2billing-createdb-user.sql followed by ./install-db.sh
It runs smoothly without errors and generates 97 tables.
|