Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Incoming Mail: DB Error

Hello,

since upgrade from 1.9.12 to 1.10.1 I got sometimes following Mails:


[INSERT INTO `ost_attachment` SET `file_id` = 1051,
`type` = 'D', `object_id` = 16245]

Duplicate entry '16245-1051-D' for key 'file-type'<br
/> <br />

---- Ablaufverfolgung ----<br />

#0 D:\PATH\osticket\include\mysqli.php(204): osTicket->logDBError('DB Error
#1062', '[INSERT INTO `o...')<br />

#1 D:\
PATH\osticket\include\class.orm.php(3133): db_query('INSERT INTO `os...',
true, true)<br />

#2 D:\
PATH\osticket\include\class.orm.php(597): MySqlExecutor->execute()<br
/>

#3 D:\
PATH\osticket\include\class.attachment.php(161):
VerySimpleModel->save()<br />

#4 D:\
PATH\osticket\include\ajax.draft.php(101):
GenericAttachments->upload(Array)<br />

#5 D:\
PATH\osticket\include\ajax.draft.php(300):
DraftAjaxAPI->_uploadInlineImage(Object(Draft))<br />

#6 [internal function]: DraftAjaxAPI->uploadInlineImage('16245')<br
/>

#7 D:\
PATH\osticket\include\class.dispatcher.php(145): call_user_func_array(Array,
Array)<br />

#8 D:\
PATH\osticket\include\class.dispatcher.php(38): UrlMatcher->dispatch('16245/attach',
Array)<br />

#9 D:\
PATH\osticket\include\class.dispatcher.php(120):
Dispatcher->resolve('16245/attach', Array)<br />

#10
D:\
PATH\osticket\include\class.dispatcher.php(38):
UrlMatcher->dispatch('/draft/16245/at...', NULL)<br />

#11 D:\
PATH\osticket\scp\ajax.php(262):
Dispatcher->resolve('/draft/16245/at...')<br />

#12 {main}


Any ideas how to avoid this mail?

Comments

  • The error says:
    "INSERT INTO `ost_attachment` SET `file_id` = 1051,
    `type` = 'D', `object_id` = 16245]

    Duplicate entry '16245-1051-D' for key 'file-type'"
     

    It's telling you that there is a duplicate attachment.
     
    Specifically: "Duplicate entry '16245-1051-D' for key 'file-type'"


    Does the email have attachments that might already exist? (same file twice, etc)
Sign In or Register to comment.