[resolved] Ticket not showing after upgrading DB (Error 500 in ticket creation)

mechbaral

Hi,

I freshly installed the osTicket in a new machine. Then I copied everything except ost_config table from my old database which was working with 1.12 version of osticket. Now after installation everything looked fine in the first glance, but when I check the ticket column they are don't show up. When I try to open a new ticket under a user, then it gives an error 500.

Below is my current setting, please let me know if there is anything I am doing wrong

mechbaral

This is how it looks like when I go to agent pannel although there are many tickets under the logged in agent

ntozier

Does your account have access to the department that the tickets are in?

mechbaral

Hi, yes it has the access to all the departments. At the moment all the agents have access to all the departments.

mechbaral

Also this only happens after I copy the old tables to the new one, in the fresh installation there isn't any problem.

ntozier

Did you run the upgrade after you updated the database?

Clear your browser cache?

mechbaral

Hi,
Since I use the navicat, to directly copy the content of old database to the new database, osticket does not trigger the upgrade.

I know the upgrade is successful because after the data transfer, I can use the old system login credentials to login to the fresh installation. Also in the admin panel of osticket , I can also see all the agents information too which were registered in old system.

mechbaral

Is it possible for me to manually trigger the update ? I will do the upgrade after I copy or replace the database into my new connection

ntozier

You log into the system, and it will trigger the upgrade.

mechbaral

Thank you, did so and it prompt the upgrade option which got successfully completed. Thank you for your help, cheers

ntozier

Very welcome. I'll mark this as resolved and close the thread. Please feel free to start a new thread if you have another question.