Version 2.2.8 Template: 'forumhome_forumbit_level2_post'

[wdforums]

Whenever I try editing this template or just plain opening it and saving it I get the following error message:

There seems to have been a slight problem with the cpradio's Hacking Forum database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[textarea]Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,'1','forumhome_forumbit_level2_post','<tr align=\"center\">
<td bgcolor=\"{secondaltcolor}\" valign=\"top\"><img src=\"{imagesfolder}/$forum[onoff].gif\" border=\"0\" alt=\"\"></td>
<td bgcolor=\"{firstaltcolor}\" align=\"left\"><a href=\"forumdisplay.php?s=$session[sessionhash]&forumid=$forum[forumid]\"><normalfont><b>$forum[title]</b></normalfont></a>
<br><smallfont>$forum[description]</smallfont></td>
<td bgcolor=\"{secondaltcolor}\"><normalfont>$forum[replycount]</normalfont></td>
<td bgcolor=\"{firstaltcolor}\"><normalfont>$forum[threadcount]</normalfont></td>
<td bgcolor=\"{secondaltcolor}\"><smallfont>$forum[lastpostinfo]</smallfont></td>
<td bgcolor=\"{firstaltcolor}\"><smallfont>$forum[moderators]</smallfont></td>
</tr>
')
mysql error: Duplicate entry '487' for key 1

mysql error number: 1062

Date: Friday 08th of November 2002 07:01:37 PM
Script: http://localhost/PHP/develop/vbulletin
Referer: http://localhost/PHP/develop/vbullet...roup=forumhome[/textarea]

Am I the first to notice this? I did a search on
'forumhome_forumbit_level2_post' but nothing matched.

-Matt

[wdforums]

please note this is the test forum I use to test my addons on and to design new templates on so when I upload them to the real forum it will not cause errors.

[Steve Machol]

I have no problem editing that template. It appears you have a duplicate templateid in the database. You could try running repair.php to see if that fixes it. Otherwise you may need to remove the duplicate row by hand. (Backup your database first)

[wdforums]

my database is empty so I can careless if I lose stuff, but I will run the repair.php (in the extra folder?) and see if it fixes the problem and will report my findings here.

-Matt

[wdforums]

After running the repair.php everything worked fine. Thanks for the advice.