BD error 1054

vidfe

Good morning.

Today I am presenting a problem with the database, in which it has suddenly jumped on me. I needed to modify a parameter in the ticket forms, but as soon as I entered the forms and without making any modification the following error occurred:

[SELECT A1.number AS number, A1.ticket_id AS ticket_id, A1.source AS source, A1.lastupdate AS lastupdate, B4.subject AS cdata__subject, A1.isoverdue AS isoverdue, B6.name AS user__name, B4.priority AS cdata__priority, B7.firstname AS staff__firstname, B7.lastname AS staff__lastname, B8.name AS team__name, A1.team_id AS team_id, A1.dept_id AS dept_id, C0.name AS dept__name, A1.isanswered = '0' AS 2GkBZxz, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id AND NOT R0.flags & 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_entry R0 ON (Q7.id = R0.thread_id) LEFT JOIN ost_attachment R1 ON (R1.type = 'H' AND R0.id = R1.object_id) WHERE Q8.ticket_id = A1.ticket_id AND R1.inline = 0) AS _att_count, C1.expire > NOW() AND NOT C1.staff_id = 7 AS _locked, (SELECT COUNT(R0.id) AS count FROM ost_thread Q7 JOIN ost_ticket Q8 ON (Q7.object_type = 'T' AND Q7.object_id = Q8.ticket_id) LEFT JOIN ost_thread_collaborator R0 ON (Q7.id = R0.thread_id) WHERE Q8.ticket_id = A1.ticket_id) AS _collabs, COALESCE(B7.firstname, B7.lastname, B8.name, 'zzz') AS assignee FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_team B0 ON (A4.object_type = 'E' AND A4.object_id = B0.team_id) LEFT JOIN ost_team B1 ON (A7.object_type = 'E' AND A7.object_id = B1.team_id) LEFT JOIN ost_department B2 ON (A4.object_type = 'D' AND A4.object_id = B2.id) LEFT JOIN ost_department B3 ON (A7.object_type = 'D' AND A7.object_id = B3.id) LEFT JOIN ost_ticket__cdata B4 ON (A1.ticket_id = B4.ticket_id) LEFT JOIN ost_ticket_priority B5 ON (B4.priority = B5.priority_id) LEFT JOIN ost_user B6 ON (A1.user_id = B6.id) LEFT JOIN ost_staff B7 ON (A1.staff_id = B7.staff_id) LEFT JOIN ost_team B8 ON (A1.team_id = B8.team_id) LEFT JOIN ost_department C0 ON (A1.dept_id = C0.id) LEFT JOIN ost_lock C1 ON (A1.lock_id = C1.lock_id) WHERE A2.state = 'open' AND ((A2.state = 'open' AND (A1.staff_id = 7 OR A5.staff_id = 7 OR A6.object_type = 'C' AND A8.staff_id = 7 OR A1.team_id IN (1, 2, 3) OR B0.team_id IN (1, 2, 3) OR A6.object_type = 'C' AND B1.team_id IN (1, 2, 3))) OR A1.dept_id IN (1, 3, 4) OR B2.id IN (1, 3, 4) OR A6.object_type = 'C' AND B3.id IN (1, 3, 4)) AND (A1.ticket_pid IS NULL OR A1.flags & 8 != 0) GROUP BY A1.ticket_id ORDER BY B5.priority_urgency ASC, A1.lastupdate DESC LIMIT 50] Unknown column 'B4.subject' in 'field list' ---- Recular ---- #0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(211): osTicket->logDBError() #1 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3482): db_query() #2 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3529): MySqlExecutor->execute() #3 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2104): MySqlExecutor->getArray() #4 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2054): HashArrayIterator->{closure}() #5 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2033): CallbackSimpleIterator->next() #6 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2042): CallbackSimpleIterator->rewind() #7 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1713): CallbackSimpleIterator->valid() #8 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1723): CachedResultSet->fillTo() #9 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1739): CachedResultSet->asArray() #10 C:\inetpub\wwwroot\osTicket\include\staff\templates\queue-tickets.tmpl.php(258): CachedResultSet->getIterator() #11 C:\inetpub\wwwroot\osTicket\scp\tickets.php(569): require_once('...') #12 {main}

I have looked in the forum, but I have not found any solution.

My server data is:

Microsoft IIS
Ver. OsTicket: 1.18
PHP Ver. 8.2
MySQL ver. 10.11

KevinTheJedi

vidfe

Upgrade to v1.18.1, drop your _ticket__cdata table, run cron manually a bunch of times until the table is recreated and fully repopulated with data, and then you should be good.

Cron rebuilds the table automatically and repopulates the data in batches. So it will take multiple cron runs for the data to fully repopulate.

Cheers.