I just made the upgrade Osticket to version 1.9.7 copying the files of the "upload" folder in the upgrade package in the root dir of Osticket.Everything went fine, but I got this error message in the log:DB Error #1062 Duplicate entry 'mysqlsearch-reindex' for key 'namespace'---- Backtrace ----#0 C:\xampp\htdocs\helpdesk\include\mysqli.php(177): osTicket->logDBError('DB Error #1062', '[INSERT INTO os...')#1 C:\xampp\htdocs\helpdesk\include\class.config.php(98): db_query('INSERT INTO ost...')#2 C:\xampp\htdocs\helpdesk\include\class.config.php(109): Config->create('reindex', 0)#3 C:\xampp\htdocs\helpdesk\include\class.config.php(78): Config->update('reindex', 0)#4 C:\xampp\htdocs\helpdesk\include\class.search.php(611): Config->set('reindex', 0)#5 : MysqlSearchBackend->IndexOldStuff(Array, NULL)#6 C:\xampp\htdocs\helpdesk\include\class.signal.php(98): call_user_func_array(Array, Array)#7 C:\xampp\htdocs\helpdesk\scp\autocron.php(58): Signal:('cron', Array)#8 {main}

This is my current configuration:Server InformationosTicket Versionv1.9.7 (4be5782)Web Server SoftwareApache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3MySQL Version5.6.21PHP Version5.6.3

What version were you running before you upgraded?You appear to have: Duplicate entry 'mysqlsearch-reindex' for key 'namespace'.I'd look at the current record and then delete the duplicate.

I checked and there are no duplicates of that entry in the table. Maybe the "error" was just a warning for an entry which wasn't submitted because of a conflict with a duplicate.

reindex.jpg

4 days later

I am Having A similar issue 1.9.6 working on the VPS and identical working on localhost ( ubuntu 14 ) I upgrading by pasting the upload into its folder breaks the site and delivers a blank screen.A Complete fresh install runs very well complete with mods. However using phpmyadmin the databases are not inter-changeable, meaning, I cannot get my data into the 1.9.7 databasefor additional info by changing where the ost-config.php database  points the data bases are activated and 1.9.6 database hangs . even Swapping out the databases within phpmyadmin the 1.9.6 database fails and the 1.9.7 database under its new name runs (obviously also altering the sql to suit )Is there a Database upgrade that i have missing ?

@[deleted]There were no database changes between 1.9.6 and 1.9.7.  So... yes you can get your data into the database.I don't understand why you would think other wise.

Write a Reply...