Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Database problem (error)

I am getting this error a lot. It's sent to my email address:


[INSERT INTO `ost_session` SET `session_id` = 'xxxxxx', `session_data` = 'xxxxxx:2:{s:5:\"token\";s:40:\"xxxxxxxxxxxxxxxxxxxxx\";s:4:\"time\";i:1508958164;}', `session_expire` = NOW() + INTERVAL 86400 SECOND, `user_ip` = 'xxx.xxx.xxx.xxx', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.75.14 (KHTML, like Gecko) Version/7.0.3 Safari/7046A194A']

Duplicate entry 'xxxxxxxxxxxxxxxxx' for key 'PRIMARY'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1062', '[INSERT INTO `o...')<br />
#1 (root)/include/class.orm.php(3133): db_query('INSERT INTO `os...', true, true)<br />
#2 (root)/include/class.orm.php(597): MySqlExecutor->execute()<br />
#3 (root)/include/class.ostsession.php(216): VerySimpleModel->save()<br />
#4 (root)/include/class.ostsession.php(158): DbSessionBackend->update('xxxxxxxxxx...', 'xxxxxxxx|a:2:{s:5:"...')<br />
#5 [internal function]: SessionBackend->write('xxxxxxxxxxxx...', 'csrf|a:2:{s:5:"...')<br />
#6 [internal function]: session_write_close()<br />
#7 {main}


What's causing this error?

Comments

  • Your database has a duplicate key in the ost_session table... hence the error "Duplicate entry 'xxxxxxxxxxxxxxxxx' for key 'PRIMARY'"
  • How do I solve this problem?
  • delete the duplicate.

    Or just drop the entire contents of the ost_session table and make everyone log back in...
Sign In or Register to comment.