Here is the sql error log. I checked the ibf_posts table and the last indexed post id (pid) was 4393970. For some reason the sql was seeing the latest pid as 4393971 therefore any new posts that were suppose to fall in line were being refused and returning the IPS Driver Error. What i did was change the pid index to BIGINT(20) and then back to INT(10), this forced the sql to recount the actual post indexes. From there the sql started returning the correct pid and allowing the new posts again. Some of you may have noticed that the site went down for a few minutes, this is due to the sql counting +4.3 million posts 2 times over, sorry for that but it had to be done. Something caused this, I don't know what yet but I will do some more poking around and see if anything jacked up jumps out at me.
WELL I was about to quote Calypso and be like... "wow, that's cool, glad to see everything's good " And then I got an IPS Error...
Why didn't you just delete 4393970? In my tiny practice tables I just do that and SQL just kinda scans that one, then the next one, then it detects the end of the table and just continues there. I just tell my Database teacher that one entry is worth the sacrifice. And then when he says "What if that entry is of someone buying a private jet?" I remind him of backups. I get ----ty grades on tests.
I checked the ibf_posts table and the last indexed post id (pid) was 4393970. For some reason the sql was seeing the latest pid as 4393971 therefore any new posts that were suppose to fall in line were being refused and returning the IPS Driver Error. What i did was change the pid index to BIGINT(20) and then back to INT(10), this forced the sql to recount the actual post indexes. From there the sql started returning the correct pid and allowing the new posts again. Some of you may have noticed that the site went down for a few minutes, this is due to the sql counting +4.3 million posts 2 times over, sorry for that but it had to be done. Something caused this, I don't know what yet but I will do some more poking around and see if anything jacked up jumps out at me. [/b][/quote] I was so gonna say that