- Edited
[osTicket Version v1.15.4] [Web Server Software: Apache] [MySQL Version 10.5.12] [PHP Version 7.2.31]
I'm getting this error whenever I try to change settings, create new agents, or do anything to configure the platform really:
[INSERT INTO ost_config SET namespace = 'core', key = 'date_formats', updated = NOW()]
Field 'value' doesn't have a default value<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1364', '[INSERT INTO o...')<br />os...', true, true)<br />
#1 (root)/include/class.orm.php(3466): db_query('INSERT INTO
#2 (root)/include/class.orm.php(658): MySqlExecutor->execute()<br />
#3 (root)/include/class.config.php(173): VerySimpleModel->save(true)<br />
#4 (root)/include/class.config.php(106): ConfigItem->save()<br />
#5 (root)/include/class.config.php(116): Config->create('date_formats', '')<br />
#6 (root)/include/class.config.php(132): Config->update('date_formats', '')<br />
#7 (root)/include/class.config.php(1337): Config->updateAll(Array)<br />
#8 (root)/include/class.config.php(1222): OsticketConfig->updateSystemSettings(Array, Array)<br />
#9 (root)/scp/settings.php(42): OsticketConfig->updateSettings(Array, Array)<br />
#10 {main}
Example of error when creating a new help topic, the topic is created but my email is still spammed with the 1364 error:
[INSERT INTO ost_help_topic (topic_id,sort) VALUES (2,1),(1,2),(10,3),(11,4)
ON DUPLICATE KEY UPDATE sort=VALUES(sort)]
Field 'created' doesn't have a default value<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1364', '[INSERT INTO o...')<br />os...')<br />
#1 (root)/include/class.topic.php(632): db_query('INSERT INTO
#2 (root)/include/class.topic.php(544): Topic::updateSortOrder()<br />
#3 (root)/scp/helptopics.php(41): Topic->update(Array, Array)<br />
#4 {main}[INSERT INTO ost_help_topic (topic_id,sort) VALUES (2,1),(1,2),(10,3),(11,4)
ON DUPLICATE KEY UPDATE sort=VALUES(sort)]
Field 'created' doesn't have a default value<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1364', '[INSERT INTO o...')<br />os...')<br />
#1 (root)/include/class.topic.php(632): db_query('INSERT INTO
#2 (root)/include/class.topic.php(544): Topic::updateSortOrder()<br />
#3 (root)/scp/helptopics.php(41): Topic->update(Array, Array)<br />
#4 {main}
The platform is hosted on 000webhost, since this is for a school project and I needed a free host, could that be the cause of it? Before trying to host it online I was hosting it locally using wampserver to try the platform and this error did not happen.
Unable to change settings, in this case the language.
