Hello, We upgraded from 1.9.2 to 1.9.5 to fix an issue - and it did, thanks.But now we're getting these DB Error 1062 emails.An example:

Duplicate entry 'H-75625' for key 'PRIMARY'<br />

<br />

---- Backtrace ----<br />

#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1062', '[INSERT INTO `o...')<br />

#1 (root)/include/class.search.php(611): db_query('INSERT INTO `os...')<br />

#2 (root)/include/class.search.php(591): MysqlSearchBackend->__index(NULL, true)<br />

#3 : MysqlSearchBackend->IndexOldStuff(Array, NULL)<br />

#4 (root)/include/class.signal.php(98): call_user_func_array(Array, Array)<br />

#5 (root)/scp/autocron.php(58): Signal:('cron', Array)<br />

#6 {main}-----------------------We always notice it seems there to be a message such as: Duplicate entry 'H-75625' for key 'PRIMARY'<br />Any thoughts? It does not affect every ticket. Regards,-BrianHere is the server information:Server Information

osTicket Version

v1.9.5 (ecb4f89)

Web Server Software

Apache/2.4.9 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4

MySQL Version

5.5.40

PHP Version

5.3.27

PHP Extensions

gdlib

Used for image manipulation and PDF printing

imap

Used for email fetching

xml

XML API

xml-dom

Used for HTML email processing

json

Improves performance creating and processing JSON

mbstring

Highly recommended for non western european language content

phar

Highly recommended for plugins and language packs

fileinfo

Used to detect file types for uploads

PHP Settings

cgi.fix_pathinfo

"1" is recommended if AJAX is not working

date.timezone

UTC

Database Information and Usage

Schema

embrilli_bb3 (localhost)

Schema Signature

b26f29a6bb5dbb3510b057632182d138

Space Used

1185.31 MiB

Space for Attachments

835.04 MiB

Take a look in your ost__search table and search for the entry with key H-75625When found, remove it.It happened to me when i upgraded, downgraded to my backup and wanted to upgrade again.Removing all duplicates generated resolved the problem  for me

The 1062 errors are harmless. Hopefully we'll get it taken care of in an upcoming release

We've also been getting 1062 errors.  One in particular when it was inserting a record into ostick_ticket, which ended up created two tickets from the same email. I am not sure if we should consider it harmless. I went ahead and deleted one of the duplicate entries in the db.  If it would help, I can save duplicates and send it along to the dev team.

a month later

The 1062 errors are harmless. Hopefully we'll get it taken care of in an upcoming release

Good to know - I was worried something bad was happening!  I can deal with non-harmful errors!

Write a Reply...