I doubt IP changes would have an effect on this but it could be possible.
You can truncate by running TRUNCATE TABLE ost_session; in MySQL. More information can be found in MySQL documentation:
Cheers.
Valid CSRF Token Required
I raised the IP address issue, and this Go Daddy agent thinks this could be possible, and you said the same thing. The whole site seems to work fine, except the osTicket. Can you tell me where I should update the Go Daddy hosting and Security panel?
In the meantime, I read the article further.
Can you tell me where I should update the Go Daddy hosting and Security panel?
I don’t have the slightest idea. That would be a question for the Go Daddy agent.
Cheers.
KevinTheJedi
I asked the agent back with my first call, but he does not know where to update the new IP address.
Can you come up with some questions so I could ask Go Daddy agent specifically?
I’m not fully convinced the IP change is causing the issue just yet. I would first try truncating the session table as described above. Then I would clear all cache and cookies in the browser and force refresh the page. This is usually what works in these cases.
In some cases the session table needed repairing. You can run ‘REPAIR TABLE ost_session; in MySQL to repair the table.
Also quick question, what version of PHP is the site running?
Cheers.
- Edited
I am very concerned about the truncate directive. If I perform this directive, it will log everyone out. What about those data? Is it okay to lose? Some video suggested this cannot be rollback?
- Edited
KevinTheJedi
PHP version: 7.4
Thats just the easy way to clear the sessions from the database. You can try to delete just your sessions by going to the ost_staff table, finding your account and grab the id, go to the ost_session table, and delete all records that match user_id = id_you_copied.
Cheers.
a month later
- Edited
Hi Kevin, we fixed the session thing last time. Now, we received another problem:
OSticket still isn’t working properly. And I’m not sure why.
Today, I received a ticket. I tried to log in and it didn’t recognize my password. So I clicked ‘Forgot Password’. I rec’d a link to enter my new password. When I did, I get the following message.
``
Warning: "Continue" targeting switch is equivalent to "break" Did you mean to use 'continue2? in/home/water2099/public_html/flowpointsytem.com/support/include/class.osticket.php on line 442'"
Any idea what it means?
I don’t know anything about the DB Error you rec’d below.
Any ideas how we can get this working properly?
[INSERT INTOost_sessionSETsession_id= 'shbav3av3mcr3a16alnjqimd22',session_data= 'csrf|N;',session_expire= NOW() + INTERVAL 86400 SECOND,user_ip= '185.93.231.39',user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36']
Duplicate entry 'shbav3av3mcr3a16alnjqimd22' for key 'PRIMARY'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1062', '[INSERT INTO o...')<br />os...', true, true)<br />
#1 (root)/include/class.orm.php(3133): db_query('INSERT INTO
#2 (root)/include/class.orm.php(597): MySqlExecutor->execute()<br />
#3 (root)/include/class.ostsession.php(217): VerySimpleModel->save()<br />
#4 (root)/include/class.ostsession.php(158): DbSessionBackend->update('shbav3av3mcr3a1...', 'csrf|N;')<br />
#5 [internal function]: SessionBackend->write('shbav3av3mcr3a1...', 'csrf|N;')<br />
#6 [internal function]: session_write_close()<br />
#7 {main}
`
What version of PHP are you running?
- Edited
ntozier
I solved the problem by manually installing the latest version, and the osticket is running, but there was a glitch when my coworker first signed in; he saw my profile. Is this common?
In this installation, I started fresh, and I used a new database with php 7.4 this time.
(Updated)
My coworker assigned roles and the people never got any emails from osticket.
My other coworker cannot create a ticket.