I did what you said and I got this error

MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2
Quote:
Originally Posted by Swedie
oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.
Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.
PHP Code:
DROP TABLE `user_guestbook`;
DROP TABLE `user_webpage`;
ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;
DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';
DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';
DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage';
|