Hi Team,
osTicket v1.18
I have enable the plugin for using filesystem to store attachments.
Getting the following error when posting an in-line screenshot in a reply to a ticket:
[INSERT INTO ost_attachment SET type = 'H', object_id = 13, file_id = 4, inline = 1]
Duplicate entry '4-13' for key 'ost_attachment.file_object'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(211): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(658): MySqlExecutor->execute()<br />
#3 (root)/include/class.thread.php(1260): VerySimpleModel->save()<br />
#4 (root)/include/class.thread.php(1268): ThreadEntry->createAttachment()<br />
#5 (root)/include/class.thread.php(1807): ThreadEntry->createAttachments()<br />
#6 (root)/include/class.thread.php(1819): ThreadEntry::create()<br />
#7 (root)/include/class.thread.php(3006): ThreadEntry::add()<br />
#8 (root)/include/class.thread.php(3189): ResponseThreadEntry::add()<br />
#9 (root)/include/class.ticket.php(3365): ObjectThread->addResponse()<br />
#10 (root)/scp/tickets.php(220): Ticket->postReply()<br />
#11 {main}
There are 2 others examples:
[INSERT INTO ost_attachment SET type = 'H', object_id = 14, file_id = 5, inline = 1]
Duplicate entry '5-14' for key 'ost_attachment.file_object'<br />
<br />
[INSERT INTO ost_attachment SET type = 'H', object_id = 15, file_id = 6, inline = 1]
Duplicate entry '6-15' for key 'ost_attachment.file_object'<br />
<br />
Not sure what to look for to fix this? osTicket emails the response to the client with the screenshot in-line, but back in osTicket admin looking at the post reply the screenshot image is broken.
Regards,
Sean.
