Ennovy.org

Earlier today I looked at my EE database tables in phpMyAdmin, and I noticed the strangest thing. The number of records in the “exp_weblog_data” and the “exp_weblog_titles” were not the same – one had 2 more records than the other. From my understanding of EE, every time you make an entry, there is one record stored in both of the tables, so the numbers should be the same.

After poking around for a long time, I figured out what happened:

• There was an extra record in the exp_weblog_data, that had an entry id of 0. The entry id is supposed to start at 1. All other fields in that record were empty.
• There was a missing record in the exp_weblog_titles table. I found this out when looking at the exp_trackbacks table. There was this spam trackback in there, and when I tried to look up the corresponding entry id that the trackback was sent to, I couldn’t. That entry id was in the exp_weblog_data table but not the exp_weblog_titles table. Luckily I had a backup and was able to restore the missing record.

I have no idea how that happened, I just glad I was able to figure it out and fix it.