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 CURRENT_TIMESTAMP w...

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 s...