[oldfan]

I did run that command...

ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
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';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).

I got the error when I tried the install the sql in the new zip

Originally Posted by Loki12

Then it probably means you have not ran this command Swedie gave:




Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.

ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
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';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).