My VPS was recreated today (moved to FC5 with php5 and mysql5) and now I'm having issues with the forum - each post is written with id of '0' and then the forum can't find it. I can go in and manually change the post id to the correct number and it seems to be fine, but new topics and replies are writing post id's as '0' - any idea what gives?

I'd think a corrupted forum file would corrupt the posts table, not just write the post id to '0'. I'd also think a corrupted posts table wouldn't work if I edited the topic (works fine).

Is there a setting somewhere that says what the last post id is? Maybe that's the setting that's corrupt...

I'm getting this as the error with addpost.inc.php

- Duplicate entry '0' for key 1

Looks like it affects pm's as well.

Are my indexes screwed? I've repaired all the tables more than once from phpmyadmin.

It sounds like the auto_increment field is messed up. That field is supposed to automatically be populated with the next available number, always getting bigger, since it keeps trying to put it in as zero it sounds like that's the problem. I'm not sure how that can be fixed, but I'll see if I can find any info.

thank you Rick - I can give you access if you need to check it out.

Where would I check the auto_increment field setting? I don't see it in relation to the POST_ID column.

ugh, every table looks like it should be auto_increment in the id column's extra field (naturally), except that it's now gone. I have to go back and fix every table now. Any shortcut command?

well, maybe not every table, but 22 of 55 :smash:

Wow, thats quite a dandy issue allen lol

yes, it is for the threads forum, now I have to figure out the photopost tables :smash:

I'm rather curious what the hell happened lol... I don't see how the FC upgrade would have affected the MySQL schema...