DB Error $1504

mulyana

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?

PavelH

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.

mulyana

But dropping the cdata table has caused Missing CDATA table.

PavelH

To rebuild and repopulate any missing CDATA table you must run cron.
Look at the description from @KevinTheJedi.

mulyana

I truly have no idea what the description is talking about. I am afraid my system cannot recover.

PavelH

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.