HiI have been having performance issues with tickets taking too long to load or timing out completely. The same goes for adding comments to a ticket. I upgraded from v1.9.2 to v1.9.5.1 in the hope it might help, but it hasn't. In fact the performance issue remains and I've increased the memory limit in php.ini to memory_limit=1024M, but it also hasn't helped.The other issue is that after upgrading I'm getting an error: "DB Error #1062" with example detail as follows... Duplicate entry '20520-25' for key 'PRIMARY'<br />

<br />---- Backtrace ----<br />#0 C:\xampp\htdocs\CRM\include\mysqli.php(177):

osTicket->logDBError('DB Error #1062', '[INSERT INTO os...')<br />#1 C:\xampp\htdocs\CRM\include\class.orm.php(221):

db_query('INSERT INTO ost...')<br />#2 C:\xampp\htdocs\CRM\include\class.dynamic_forms.php(910):

VerySimpleModel->save()<br />#3 C:\xampp\htdocs\CRM\scp\tickets.php(460):

DynamicFormEntry->addMissingFields()<br />#4 {main}

I've re-copied the files to my server and done the upgrade again and it hasn't helped.Any ideas would be appreciated.

Can you provide some more info about your setup, so we can better assist you:http://forum.osticket.com/d/discussion//please-read-before-requesting-assistance#latestBeside, when you are experienced enough and have a backup made, what happens when you remove the duplicate database entry from the ost_form_entry_values table?(If you are unsure whether you're experienced enough or not, then better do not try it)

>> Duplicate entry '20520-25' for key 'PRIMARY'The database is saying that you have two of the same PRIMARY key.I'd try removing one.

osTicket Version v1.9.5.1 (1faad22)Web Server Software Apache/2.4.4 (Win32) OpenSSL/1.0.1e PHP/5.5.3MySQL Version 5.6.11PHP Version 5.5.3

There were no duplicate primary keys listed in the indexes of ost_search or ost_ticket_cdata. I deleted the primary key indexes in both tables and recreated them. This seems to have stopped the Error #1062. However, the system is still so slow that it is pretty much unusable.If I rollback my version and DB, will I be able to import the ticket data that's been entered between now and the the time of upgrade? (ie. restore the old DB data and structure, but then import the most recent data only while retaining the old Db sturcture?)

I have been getting random DB Error #1062 as well for some time as well in 1.9.4, also with no duplicate keys listed (mine always says its in ost__search, not in ost_form_entry_values). I had assumed they were caused by a bug, or possibly by users double clicking the post reply button when posting their internal notes, because the information made it onto the ticket thread, so I just didn't worry too much since it was a very infrequent issue.I was hoping when I updated to 1.9.5.1 this Friday night that it would solve itself, but sounds like it is still occurring for some that have already updated. 

I spoke too soon. Still getting the error with ost_search, which seems like pretty much every time a ticket is updated.Duplicate entry 'H-71672' for key 'PRIMARY'<br /> <br />---- Backtrace ----<br />#0 C:\xampp\htdocs\CRM\include\mysqli.php(177): osTicket->logDBError('DB Error #1062', '[INSERT INTO `o...')<br />#1 C:\xampp\htdocs\CRM\include\class.search.php(611): db_query('INSERT INTO `os...')<br />#2 C:\xampp\htdocs\CRM\include\class.search.php(591): MysqlSearchBackend->__index(NULL, true)<br />#3 : MysqlSearchBackend->IndexOldStuff(Array, NULL)<br />#4 C:\xampp\htdocs\CRM\include\class.signal.php(98): call_user_func_array(Array, Array)<br />#5 C:\xampp\htdocs\CRM\scp\autocron.php(58): Signal:('cron', Array)<br />#6 {main}I'm not sure if the above detail helps, but any ides would be welcome.

a month later
10 days later

You m ay want to take a look at some of the github issue reports.https://github.com/osTicket/osTicket-1.8/issues/1138https://github.com/osTicket/osTicket-1.8/pull/1439https://github.com/osTicket/osTicket-1.8/issues/1696Also the 1.9.6 release notes list:Turn off search indexing when complete, disable incorrectly implemented work breaking, squelch error 1062 email from search backend (afa9692)

Write a Reply...