OK I had a server upgrade this weekend and my board is now down. When making a post I get this error.

Code
We encountered a problem. The reason reported was 
Script: /services/webpages/util/c/a/capitalstang.site.aplus.net/public/boards/scripts/addpost.inc.php
Line#: 480
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO cts_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,POST_POSTER_NAME,POST_MD5) VALUES ( 96028 , 11505 , 0 , 1254095642 , '72.177.81.28' , 'Re: Mom and Pop Slick' , 'lol' , 'lol' , 1 , 'book.gif' , 0 , 0 , 'markup' , 2 , 11 , 1 , 0 , 'DougMM' , '' )
I did a quick google search on the 1062 error and found this info.
http://www.theadminzone.com/forums/showthread.php?t=32498
When you restored it probably didn't pick the auto_increment attribute on the fields that should have it. They are:

phpbb_groups.group_id
phpbb_banlist.ban_id
phpbb_categories.cat_id
phpbb_disallow.disallow_id
phpbb_forum_prune.prune_id
phpbb_posts.post_id **
phpbb_privmsgs.privmsgs_id
phpbb_ranks.rank_id
phpbb_search_wordlist.word_id
phpbb_smilies.smilies_id
phpbb_themes.themes_id
phpbb_topics.topic_id
phpbb_vote_desc.vote_id
phpbb_words.word_id

**This would be the one causing the error you posted. Check using phpMyAdmin or whatever database tool you prefer, and make sure these fields are set to auto_increment.

What would fields in UBB should I look into for this error?

Thanks for all of your help..

Last edited by Gizmo; 09/27/2009 7:40 PM. Reason: [code] tags