I currently have problems copying and pasting screenshot in the body of the text editor.
There is a way to solve this problem.
osTicket v1.12 // osTicket-1.12-Awesome-104
PHP 7.3.7 // MySQL 5.5.60 // Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.7 web server
=====
DB Error #1062
[INSERT INTO ost_attachment SET file_id = 3, type = 'D', object_id = 1] Duplicate entry '1-3-D' for key 'file-type'
---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1062', '[INSERT INTO `o...')
#1 (root)/include/class.orm.php(3455): db_query('INSERT INTO `os...', true, true)
#2 (root)/include/class.orm.php(658): MySqlExecutor->execute()
#3 (root)/include/class.attachment.php(172): VerySimpleModel->save()
#4 (root)/include/ajax.draft.php(101): GenericAttachments->upload(Array)
#5 (root)/include/ajax.draft.php(301): DraftAjaxAPI->_uploadInlineImage(Object(Draft))
#6 (root)/include/class.dispatcher.php(145): DraftAjaxAPI->uploadInlineImage('1')
#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('1/attach', Array)
#8 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('1/attach', Array)
#9 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/draft/1/attach', NULL)
#10 (root)/scp/ajax.php(291): Dispatcher->resolve('/draft/1/attach')
#11 {main}
=====
Hi AdvisorIT,
I overlooked your post, I apologize for the delayed response.
I want to make sure that I understand you correctly. Are you receiving the database error as a result of attempting to copy and paste an image into a ticket?
As far as I know, it isn't possible to copy and paste an image into the text editor. BUT attempting to do so shouldn't produce a database error either. So I'm confused.
- What happens when you use the Insert Image button?
- PHP 7.3.7 is a little cutting edge. You may want to consider dropping down to a version is the 7.0 range.
- Are you using any plugins?
More to @stevland's points.
PHP 7.3 is not officially supported by osTicket yet. Check it out here - https://github.com/osTicket/osTicket/issues/4800#issuecomment-473354828 even though @Jedikev does mention later that they are using it on 7.3 themselves.
Thank you for the detailed report, @it-support@lindner-esskultur.de. I didn't realize that one could copy and paste from the Windows Snipping Tool into osTicket... very useful (when it works)!
In any event, I did run into the same issue while testing in my demo for vanilla osTicket v1.12.2:
Therefore, this is an osTicket core issue—not an osTicket Awesome issue. Please report it in the osTicket Forum or, better yet, open an issue on GitHub.
Dude, my answer is gone... can you bring it back so I can copy & paste it to osTicket Forum / GitHub?