Hi,
Ive searched and cant seem to find the answer.
Server Information
osTicket Version v1.14.2 (cba6035) — Up to date
Web Server Software Apache
MySQL Version 5.7.28
PHP Version 7.3.17
I have updated the setting to IMAP from outlook. I can send emails from the saved address. When I login directly tp the office account I can see it has even added the folder. It is not pulling emails through though.
I have noticed this error repeating:
Mailer Error
Unable to email via SMTP:smtp.office365.com:587 [info@shirejam.org.uk] Failed to send data [SMTP: Invalid response code received from server (code: 554, response: 5.2.0 STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message.
and...
also DBERROR #1146 and #1786
[CREATE TABLE IF NOT EXISTS ost_ticket__cdata (PRIMARY KEY
(ticket_id)) DEFAULT CHARSET=utf8 AS SELECT entry.object_id as ticket_id, MAX(IF(field.id='20',coalesce(ans.value_id, ans.value),NULL)) as subject,MAX(CASE WHEN field.id='22' THEN REPLACE(REPLACE(REPLACE(REPLACE(coalesce(ans.value_id, ans.value), '{', ''), '}', ''), '"', ''), ':', ',') ELSE NULL END) as priority FROM ost_form_entry entry
JOIN ost_form_entry_values ans ON ans.entry_id = entry.id
JOIN ost_form_field field ON field.id=ans.field_id
WHERE entry.object_type='T' GROUP BY entry.object_id]
Statement violates GTID consistency: CREATE TABLE ... SELECT.<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1786', '[CREATE TABLE I...')<br />
#1 (root)/include/class.dynamic_forms.php(299): db_query('CREATE TABLE IF...')<br />
#2 (root)/include/class.dynamic_forms.php(292): DynamicForm::buildDynamicDataView(Array)<br />
#3 (root)/include/staff/templates/queue-tickets.tmpl.php(22): DynamicForm::ensureDynamicDataView()<br />
#4 (root)/scp/tickets.php(541): require_once('/homepages/42/d...')<br />
#5 (root)/scp/index.php(17): require('/homepages/42/d...')<br />
#6 {main}
Any ideas or help?
