I just upgraded to 2.2.8, how do i reinstall this?

I have ran the uninstall and it runs without a single problem, but if i run the install i get a database error:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO settinggroup VALUES (40, 'Warnings System', 40)
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Saturday 26th of October 2002 10:55:29 AM
Script: http://www.rcnitrotalk.com/forum/for...ing.php?step=2
Referer: http://www.rcnitrotalk.com/forum/adm...ll_warning.php


How do i fix this?


-WoodiE

Change all occurences of '40' in the install file to '99'.

Do this at your own peril, but it should work :)

Then why does it still state in the installation instructions for v2.1:

?!

The hack isn't working any more after I upgraded my forums to v2.2.8 I no longer see the warn link in postbit, even though the correct code is in the template. Also, clicking the Modify Warning link (indeed any of the warnings hack links) in my site's admin take me to a blank page.

Any help is appreciated, as this is an invaluable hack!

X-fan, when you upgraded you must have accidentally removed some code from your functions.php and members.php - you need to reinstall the hack carefully.

Okay, I sussed it out. For some reason, the rows had gone from the settinggroup and settings tables in my site's database. I went to add them back in manually, but the vBPad hack had id 40 so I set the warnings hack to id 50.

However, clicking "Modify Warnings" in my Admin CP still brings up a blank page, even after I've set all the configurations via vBulletin Options.

A blank page usually means a missing template - make sure when the required templates are in all your templateset, not just default.

Erwin, I'd added all the code back into the files and templates, but for some reason there were fields missing from my site's DB as I explained above.

I worked out the problem with Modify Warnings giving me a blank screen too - I was still using the old version of admin_warnings.php! LOL ;)

There you go! All fixed, all by yourself. ;) Well done! Your site is looking good - 25 queries on your home page, and 27 on forumhome! I'm sure that's only 25% of what it was with vBPortal. :)

Thanks Erwin! I appreciate the kind words. As well as being my full-time job, my site is a labor of love for me :) It's almost like my third child! ;)

Thanks Link14716 that fixed the problem, but now when I log in the admin control panel under:

vBulletin Options -> I have two [Warnings System] links listed. How do i remove the old one?

-WoodiE