I have run into problems trying to reinstall whmcs…once again more errors.
My understanding is, the automated script is supposed to sort all of this, however, clearly that is not the case.
I am running debian 9 with php 7.2 and whmcs 7.6.
I have use the Virtualmin script installer to install whmcs, however, it fails to install the database.
I assumed that perhaps strict mode is enabled in mysql, so i ran the query in phpmyadmin SELECT @@mysqsl_mode
It returns… NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
So my understanding from this thread… https://www.virtualmin.com/node/52204 the way to disable strict mode is to add the following to /etc/mysql/mariadb.cnf
sql-mode="" or sql-mode=
i also tried
sql_mode="" and sql_mode=
Any of the above return the following error in webmin…
The MySQL client program /usr/bin/mysql does not appear to be the correct version. Webmin only supports MySQL versions 3 and above.
The command /usr/bin/mysql -V returned :
/usr/bin/mysql: unknown variable ‘sql-mode=’