Hi, with this new version 1.11 that i love i have an issue.
Some email address are banned from the system ticket because should be not managed as ticket but as email.
In the previous version this email was not flagged as read by the ticket system, with the version 1.11 after some minutes (so maybe when Osticket checks for email) ticket for banned email are not opened (correct) but email are flagged as read on my email client so is difficult see new email as new email to read.
This issue should be reported on GitHub? Any solution?
Thanks.
EDIT: the issue is more complex. My ban list is empty and a message are showed on top: list ban disabled with a link that forward to filters page. It's really not clear to me. Where are my banned email list? All banned emails seems missed... also i have this issue about email marked as read also if ticket is not created. I must look into this better.
EDIT: There are issue with ban list. Seems bug...
IF i create a filter now i see the banned email in the ban list but a banner on top continue to say the system ban list is disabled and a link forward me to the filter list. Now if i click on the banned email an error occurs:
[SELECT A1.* FROM `LVti_filter_rule` A1 WHERE A1.`id` = '31' AND A1.`` IS NULL]
Unknown column 'A1.' in 'where clause'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT A1.* FR...')<br />
#1 (root)/include/class.orm.php(3454): db_query('SELECT A1.* FRO...', true, true)<br />
#2 (root)/include/class.orm.php(3501): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(1991): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2035): ModelInstanceManager->{closure}()<br />
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1328): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1351): QuerySet->all()<br />
#11 (root)/include/class.orm.php(606): QuerySet->one()<br />
#12 (root)/include/class.filter.php(203): VerySimpleModel::lookup(Array, NULL)<br />
#13 (root)/include/class.filter.php(199): Filter->getRuleById('31')<br />
#14 (root)/scp/banlist.php(28): Filter->getRule('31')<br />
#15 {main}
Seems after the update to 1.11 the ban list are not working anymore well. Mail is banned, no ticket opened but... email are flagged as read. This should not happen also if i click or try to manage ban list on the backpanel i see issue mentioned.
At the moment i need resume Osticket 1.0.4
I opened a bug.
https://github.com/osTicket/osTicket/issues/4705