Hi, suddenly I am receiving this error every time I create a ticket. Why and how do I resolve this? Shall dropping the ost_ticket__cdata will resolve this issue?
DB Error $1504
Table cdata is a temporary table that gets regenerated and is used to speed up performance of things like search. You can drop the table. Database backup is a matter of course.
But dropping the cdata table has caused Missing CDATA table.
To rebuild and repopulate any missing CDATA table you must run cron.
Look at the description from @KevinTheJedi.
I truly have no idea what the description is talking about. I am afraid my system cannot recover.
Surely you have a backup of the database as I wrote, so there is nothing to worry about.
Unfortunately, I don't know the structure of your system, so in general:
Run a command prompt and change to the PHP directory. Then run the command php /path/to/osticket/api/cron.php. Set the path according to your system.