PHP Fatal error: Uncaught InconsistentModelException

KevinTheJedi

You will need to see what’s causing that. You should have an Issue Summary field on the Ticket Details form with a Variable of “subject”. If you have that you should have no issues. The problem would only occur if someone removed the field, removed the variable, or something along those lines.

Cheers.

bsanjay

Thanks KevinTheJedi, I couldn't figure out what's causing this bug, but the workaround you mentioned of dropping the ost_ticket__cdata table and running cron worked perfectly when the error was for the subject column, i.e. the Unknown column 'B4.subject' error.

Now, again I've run into the same issue with no tickets displaying, but the error is Unknown column 'B7.field_44' or sometimes its B6.field_44, and the dropping table and running cron solution does not work. I would like to find the cause of it, and possibly fix it, the thing that I was experimenting with when this new error came was I was creating a custom queue to display tickets data in a certain way, it was working good, but soon this popped up, I have even deleted that custom queue and dropped cdata table and re-run the cron, but no luck, don't know how to get the tickets to show up now, any help would be good.

Sidenote, this is my configuration:

KevinTheJedi

bsanjay

Well for one you didn’t read the requirements and installed an unsupported PHP version. Downgrade to PHP 8.2, install all the suggested extensions listed in the dashboard page, restart the web server, and retest.

Cheers.

bsanjay

Thanks @KevinTheJedi
I downgraded to 8.2, installed all extensions listed, restarted web-server, dropped ost_ticket__cdata table, ran cron, but sadly still getting the same - can't see any tickets, can only see ticket counts.

KevinTheJedi

bsanjay

What’s it saying.

Cheers.

bdeguire

Hi,
I've recreated the same problem on version 1.18.1.
The problem happens when I modified the normal ticket form (ID = 2) and added 2 new fields at the same time.
At that point, the column "subject" in "ticket__cdata" is renamed to "field_20".
Hope this helps!

KevinTheJedi

bdeguire

You'll need to post a lot of information. A screenshot of Admin Panel > Dashboard > Information. A screenshot or paste of the error you are receiving. A screenshot of your Ticket Details Form. Any other information you feel would be helpful.

Cheers.

bdeguire

KevinTheJedi
Hi KevinTheJedi,
Yes, sorry about that. Here is the screenshot and the error.

40207 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: Unknown column 'B4.subject' in 'field list' SELECT A1.numberASnumber, A1.ticket_idASticket_id, A1.sourceASsource, A1.lastupdateASlastupdate, B4.subjectAScdatasubject, A1.isoverdueASisoverdue, B6.nameASusername, B4.priorityAScdatapriority, B7.firstnameASstafffirstname, B7.lastnameASstafflastname, B8.nameASteamname, A1.team_idASteam_id, A1.isanswered= '0' AS2GkBZxz, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_idAND NOT R0.flags& 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON" while reading upstream

The resulting behaviour is the same as @bsanjay dated Dec 13 2024: https://forum.osticket.com/d/103665-php-fatal-error-uncaught-inconsistentmodelexception/8

Let me know if you have any more questions.

KevinTheJedi

bdeguire

I still need:

A screenshot of your Ticket Details Form.

Cheers.

bdeguire

KevinTheJedi

Sure, here you go. As a reminder, the problem occurs right after I add 2 fields at the same time : no error occurs if they are added one at a time.

KevinTheJedi

bdeguire

That is very odd as you have the Issue Summary field with variable of subject. So, try dropping the table in the db manually then running cron a bunch of times until it’s fully recreated and repopulated with data. It will take multiple cron runs to fully repopulate. Just keep running until data stops being added to the _ticket__cdata table.

The only other thing I can think of is the fact you have a language pack installed. It could be something was incorrectly translated and is now causing issues. We have new language pack builds coming soon and I’ve already gone in and corrected all known issues with all languages. So if the issue is with the language pack it should be resolved with the next builds.

Cheers.

bdeguire

KevinTheJedi

Hi,

In this short video, you can see the bug happening: inserting 1 field is fine, but 2 causes the bug.

osticketbug2.mp4

758kB

Another note: I've dropped the table and ran the CRON, and it recreated the table correctly! So it seems to be related with the form posting in some way...

Hope this helps!