I recently migrated my website from another CMS to WordPress. In the process, I imported comments from the previous system. For various reasons, I was unable to use any importer system, so I had to actually reformat the comments table to match WordPress's and then import it directly to the database from phpMyAdmin.
That appears to have worked, but now I'm noticing a peculiar problem: If new comments are created from WordPress, their comment_ID is set to NULL. Possibly as a result, I can't delete, edit, or mark those comments as spam from within WordPress; I have to go to the table and edit that row directly.
The only thing I can think is that there might be an issue with the imported comment_ID numbers not being sequential (there are some IDs that are skipped because they were for spam or deleted comments that I didn't bother to import).
How can I fix this problem? I suppose I could renumber the list of imported comments sequentially, not skipping any numbers, but that would be a lot of work because I'd also have to make sure the parent IDs were updated concurrently, and in any case I'm not sure it would help. I would obviously rather not have to keep going into the table every time I need to approve or delete a comment!