Param
To rebuild and repopulate any missing CDATA table you must run cron. Typically if php --version (via command line) returns the appropriate PHP version you can run the following:
php /path/to/osticket/api/cron.php
Running once should rebuild the table and repopulate the first batch of data. To fully repopulate the table you must keep running it repeatedly until it completes.
Typically you’d already have a cron job/scheduled task configured for email fetching but if not you can follow the docs here to set one up:
Having one configured is highly recommended as it does much more than just mail polling. Cron performs system tasks like deleting orphaned files, cleaning up old sessions, etc.
Cheers.
