OSTicket Version 1.17.5
When creating a new ticket I receive two emails. One is a "New Ticket Alert" and looks fine. The other one states "DB Error #1054" and contains the following:
[INSERT INTO `ost_ticket__cdata` SET `field_38`='0', `ticket_id`= 104 ON DUPLICATE KEY UPDATE `field_38`='0']
Unknown column 'field_38' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(224): osTicket->logDBError()<br />
#1 (root)/include/class.dynamic_forms.php(389): db_query()<br />
#2 (root)/include/class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView()<br />
#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()<br />
#4 (root)/include/class.orm.php(680): Signal::send()<br />
#5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save()<br />
#6 (root)/include/class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save()<br />
#7 (root)/include/class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers()<br />
#8 (root)/include/class.ticket.php(4392): DynamicFormEntry->save()<br />
#9 (root)/include/class.ticket.php(4642): Ticket::create()<br />
#10 (root)/scp/tickets.php(426): Ticket::open()<br />
#11 {main}
https://help.xyz.com
In the OSTicket system logs it's always paired with "Mailer Error Unable to email via Sendmail Unable to send mail: Unknown error".
About this osTicket Installation
Server Information
osTicket Version - v1.17.5 (7c20036) — Up to date
Web Server Software - Apache/2.4.41 (Ubuntu)
MySQL Version - 8.0.35
PHP Version - 8.0.18
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone America/New_York
Database Information and Usage
Schema osticket (localhost)
Schema Signature REDACTED
Space Used 25.09 MiB
Space for Attachments 8.52 MiB
Timezone EST (Interpreted as America/New_York)
