[resolved] Cannot update the settings. Correct any errors and try again.

jaazz36

Hello together
I migrated our osticket from a win2012r2 to a win2019 server this weekend, files per copy paste and the db via dump and import.
Now there is this problem left - I cannot make any changes in the admin panel, always that same error Cannot update the settings. Correct any errors and try again. or in German: Kann die Einstellungen nicht aktualisieren. Korrigieren Sie alle Fehler und versuchen Sie es erneut.

I've tried to set the file permissions, but not working. I also get a lot of error messages, everytime I try to make a change:

Always with DB error #1142:

[UPDATE ost_ticket SET isoverdue = 1, updated = NOW() WHERE ost_ticket.ticket_id = 17016 LIMIT 1]
[DELETE ost_lock.* FROM ost_lock WHERE ost_lock.expire < NOW()]
[UPDATE ost_config SET value = 0, updated = NOW() WHERE ost_config.id = 97 LIMIT 1]

osTicket Version: (v1.10.4)
php: 5.6.24
mariadb version: 11.0.0.5919

Does anyone know about this error?

Thanks a lot & greetings
Jaazz

ntozier

1.10 is no longer supported.
You did not give us the full error message(s).

jaazz36

Yes I know. I would have made the update last weekend, but unfortunately it is not possible because of the error.
Here are all the DB errors:

[UPDATE ost_config SET value = 0, updated = NOW() WHERE ost_config.id = 97 LIMIT 1]

UPDATE command denied to user 'osticket'@'localhost' for table 'ost_config' 
---- Ablaufverfolgung ---- 
#0 D:\wwwroot\osTicket\include\mysqli.php(204): osTicket->logDBError('DB Error #1142', '[UPDATE ost_co...') #1 D:\wwwroot\osTicket\include\class.orm.php(3136): db_query('UPDATEost_con...', true, true) 
#2 D:\wwwroot\osTicket\include\class.orm.php(597): MySqlExecutor->execute() 
#3 D:\wwwroot\osTicket\include\class.config.php(177): VerySimpleModel->save(true) 
#4 D:\wwwroot\osTicket\include\class.config.php(124): ConfigItem->save() 
#5 D:\wwwroot\osTicket\include\class.config.php(129): Config->update('client_logo_id', false) 
#6 D:\wwwroot\osTicket\include\class.config.php(1481): Config->updateAll(Array) 
#7 D:\wwwroot\osTicket\include\class.config.php(1085): OsticketConfig->updatePagesSettings(Array, Array) 
#8 D:\wwwroot\osTicket\scp\settings.php(42): OsticketConfig->updateSettings(Array, Array) 
#9 {main}

[DELETE ost_lock.* FROM ost_lock WHERE ost_lock.expire < NOW()]

DELETE command denied to user 'osticket'@'localhost' for table 'ost_lock' 
---- Ablaufverfolgung ---- 
#0 D:\wwwroot\osTicket\include\mysqli.php(204): osTicket->logDBError('DB Error #1142', '[DELETE ost_lo...') #1 D:\wwwroot\osTicket\include\class.orm.php(3136): db_query('DELETEost_loc...', true, true) 
#2 D:\wwwroot\osTicket\include\class.orm.php(1296): MySqlExecutor->execute() 
#3 D:\wwwroot\osTicket\include\class.lock.php(147): QuerySet->delete() 
#4 D:\wwwroot\osTicket\include\class.cron.php(33): Lock::cleanup() 
#5 D:\wwwroot\osTicket\scp\autocron.php(57): Cron::TicketMonitor() 
#6 {main}

[UPDATE ost_ticket SET isoverdue = 1, updated = NOW() WHERE ost_ticket.ticket_id = 17016 LIMIT 1]

UPDATE command denied to user 'osticket'@'localhost' for table 'ost_ticket' 
---- Ablaufverfolgung ---- 
#0 D:\wwwroot\osTicket\include\mysqli.php(204): osTicket->logDBError('DB Error #1142', '[UPDATE ost_ti...') #1 D:\wwwroot\osTicket\include\class.orm.php(3136): db_query('UPDATEost_tic...', true, true) 
#2 D:\wwwroot\osTicket\include\class.orm.php(597): MySqlExecutor->execute() 
#3 D:\wwwroot\osTicket\include\class.ticket.php(2740): VerySimpleModel->save(true) 
#4 D:\wwwroot\osTicket\include\class.ticket.php(1973): Ticket->save() 
#5 D:\wwwroot\osTicket\include\class.ticket.php(3663): Ticket->markOverdue() 
#6 D:\wwwroot\osTicket\include\class.cron.php(30): Ticket::checkOverdue() 
#7 D:\wwwroot\osTicket\scp\autocron.php(57): Cron::TicketMonitor() 
#8 {main}

jaazz36

nevermind... My osticket user did not have enough rights on the database 😅

ntozier

I was going to say the same thing.
Your DB user has to have the UPDATE and DELETE access.