I also made a "Questions" thread concerning this, fwiw (although as I write this, it remains to be moderated). I'd link it here for context but I can't see it anymore.
Below are the details of a SQL error message I got when trying to add a Prefix (in this case, "User") through the Prefix Manager.
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
REPLACE INTO `bbcode` (`title`, `bbcodetag`, `bbcodeexample`, `bbcodereplacement`, `bbcodeexplanation`, `twoparams`, `options`, `vw_options`) VALUES ('User','User','[User=Example]Click here to view this page![/User]','[User=%2$s]%1$s[/User]','Create a link to an article with the User Prefix.',0,1,wiki_faq);
MySQL Error : Unknown column 'wiki_faq' in 'field list'
Error Number : 1054
Request Date : Saturday, April 5th 2014 @ 01:06:36 AM
Error Date : Saturday, April 5th 2014 @ 01:06:36 AM
Script : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=prefix&do=save[/url]
Referrer : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=prefix[/url]
IP Address : ...
Username : Ptah
Classname : vB_Database
MySQL Version : 5.5.36-cll
... and, another, for a different attempted Prefix save...
Code:
Invalid SQL:
REPLACE INTO `bbcode` (`title`, `bbcodetag`, `bbcodeexample`, `bbcodereplacement`, `bbcodeexplanation`, `twoparams`, `options`, `vw_options`) VALUES ('Meta','Meta','[Meta=Example]Click here to view this page![/Meta]','[Meta=%2$s]%1$s[/Meta]','Create a link to an article with the Meta Prefix.',0,1,wiki_faq);
MySQL Error : Unknown column 'wiki_faq' in 'field list'
Error Number : 1054
Request Date : Saturday, April 5th 2014 @ 01:08:34 AM
Error Date : Saturday, April 5th 2014 @ 01:08:34 AM
Script : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=prefix&do=save[/url]
Referrer : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=prefix[/url]
IP Address : ...
Username : Ptah
Classname : vB_Database
MySQL Version : 5.5.36-cll
This may explain why, from the front-end, when you click "Save" it just sits there and does nothing (again, as I detailed in that question thread I mentioned above)?