osTicket: 1.16.3
php: 8.0
os: debian 11
db: mariadb 10.5.15
After a bit of an issue yesterday, I've done a clean build of the helpdesk overnight and opened it up this morning.
I am getting constant DB Error #1048's (hundreds so far) along the lines of
[INSERT INTO ost_form_entry_values(entry_id, field_id, value)
values (
(SELECT id FROM ost_form_entry WHERE object_id = (SELECT user_id FROM ost_user_account WHERE user_id = '37') AND form_id = 1),
(SELECT id FROM ost_form_field WHERE name = 'usertitle' AND form_id = 1), "WMS Consultant")
ON DUPLICATE KEY UPDATE value = "WMS Consultant";]

Column 'field_id' cannot be null<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError()<br />
#1 (root)/scp/sync_mldap.php(332): db_query()<br />
#2 (root)/scp/sync_mldap.php(561): SyncLDAPMultiClass->update_users()<br />
#3 (root)/include/plugins/multi-ldap/auth.php(134): SyncLDAPMultiClass->check_users()<br />
#4 (root)/include/class.signal.php(98): LdapMultiAuthPlugin->onCronProcessed()<br />
#5 (root)/scp/autocron.php(66): Signal::send()<br />
#6 {main}

form_id = 1 relates to the customer info form
Can someone give me a clue on this before my mailbox implodes with the notifications?

    siilit

    Apparently it can't find the ost_form_field.id with the following query:

    SELECT id FROM ost_form_field WHERE name = 'usertitle' AND form_id = 1

    Cheers.

      Thanks for the reply Kevin, the problem is I'm getting 1000's of these errors, constantly!
      I've fixed the issue on the old helpdesk so will roll back to that for now and try a fresh attempt at the new version!

        siilit

        Maybe someone changed the variable name of one of the form fields from "usertitle" to something else or it was deleted entirely?

        Cheers.

          Write a Reply...