I am getting duplicate key error when I try to add a new post. Any idea where the Key gets generated so I can change the value?

Copy of the error.

Script: /usr/local/www/vhosts/ncdeer.com/htdocs/ncdeerfourm/scripts/addpost.inc.php
Line#: 470
SQL Error: Duplicate entry '193310' for key 1
SQL Error #: 1062
Query: INSERT INTO ubbt_POSTS (POST_PARENT_ID,TOPIC_ID,POST_IS_TOPIC,POST_POSTED_TIME,POST_POSTER_IP,POST_SUBJECT,POST_BODY,POST_DEFAULT_BODY,POST_IS_APPROVED,POST_ICON,POST_HAS_POLL,POST_HAS_FILE,POST_MARKUP_TYPE,USER_ID,POST_PARENT_USER_ID,POST_ADD_SIGNATURE,POST_LAST_EDITED_TIME) VALUES ( 0 , 17627 , 1 , 1182525335 , '199.82.243.71' , 'Test Post' , 'I am attempting to create a new entry after the restart.' , 'I am attempting to create a new entry after the restart.' , 1 , 'book.gif' , 0 , 0 , 'markup' , 3 , 0 , 1 , 0 )

Please use your back button to return to the previous page.

I've seen this before but don't recall the exact fix. Basically that post already exists. As I recall it was something to do with our import from an upgrade. You can manually go into the database and remove that entry but that might not be the real fix.

What version of PHP, MySQL, and UBBT are you running?

yeh i just done a search no luck

Sounds like your auto_increment field is a bit out of sync. Try running this MySQL query:

repair table ubbt_POSTS

ubbt 7.0.2 php version 4.3.10 and version 4.1 of mysql

When I do a query of the table the max POST_ID on the table I
get 193309 so it looks as if the auto increment is working. Not sure what the problem could be.

running the repair now

That seem to fix the problem. Thanks, I probably should run it on all the tables to insure they are ok

the "analyze" command will be much faster than "repair" and will actually tell you if there is problems.