forum.opsi.org

Hi

I have fixed the error.

Edit the following files
/usr/lib/python2.7/site-packages/OPSI/Backend/SQL.py
/usr/lib/python2.7/site-packages/OPSI/Backend/MySQL.py


Search for
table = u'''CREATE TABLE `HOST` (
and
table = u'''CREATE TABLE `SOFTWARE_CONFIG` (
Replace:
TIMESTAMP DEFAULT ...

Hi All

Still getting the same error, any one got any ideas?

Hi

Thanks, yes it is running "NO_ENGINE_SUBSTITUTION",

MariaDB [(none)]> SHOW VARIABLES LIKE 'sql_mode';
+---------------+------------------------+
| Variable_name | Value |
+---------------+------------------------+
| sql_mode | NO_ENGINE_SUBSTITUTION ...

Hi

Very sorry to post here, but it is the only post that comes up with the error I am getting.

Is there any you could let me know exactly what I need to change in the files, sorry I can not figure out what needs to be changed
in the SQL.py and MySQL.py scripts, this is the error I am getting which ...