Mysql Error

[captainron19]

Today the VPS has gone down numerous times. When it went back up one of my forums produced an error every time someone tried to post a new message in the forum. I run several forums but it is only happening to one.

The error reads...

MySQL Error : Duplicate entry '67198' for key 1
Error Number : 1062

Someone told me it has to do with Making sure the autoincrement value is higher than the highest used postid. but that is alll greek to me

Any ideas?

[seoguru]

Check 'Announcements' section.
P.S. You'll find the answer.

[captainron19]

That was at 10:30 this morning. The server was back up running since then

[lnxcode]

Originally Posted by captainron19

Today the VPS has gone down numerous times. When it went back up one of my forums produced an error every time someone tried to post a new message in the forum. I run several forums but it is only happening to one.

The error reads...

MySQL Error : Duplicate entry '67198' for key 1
Error Number : 1062

Someone told me it has to do with Making sure the autoincrement value is higher than the highest used postid. but that is alll greek to me

Any ideas?

I've spoken with support, they mentioned that you got this resolved. Want to enlighten us on what / how you fixed this?

[captainron19]

I had to go into cpanel - myphpAdmin and into the databse for that forum and go into th epost table. Form there I had to find the highest post id being used (in this case 67198) - same as in error code.

I then had to go into the operations tab of the post table and set the auto incriment to 1 digit higher than the highest post id so I set the auto incriment at 67199 but it didnt resolve the problem. On a guess I went one higher 67200 and then everything went back to working.