Issue: Prefix Manager MySQL error on Save Prefix

Issue Tools
- View Changes

April 5, 2014 2:58 AM

Ptah

Junior Member

Prefix Manager MySQL error on Save Prefix

When attempting to save a Prefix in PrefixManager a MySQL error is thrown

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)?

Issue Details

Issue Number 3656

Issue Type Bug

Project VaultWiki 4.x Series

Category Prefixes

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 4.0.0 Gamma 4

Fixed Version 4.0.0 Gamma 5

Milestone VaultWiki 4 Gamma X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 5, 2014 10:21 AM
pegasus

VaultWiki Team
This happens if you make a prefix and set a BB-Code tag for it. If you leave the BB-Code field blank for now, you can bypass this issue.

This can be fixed by modifying vault/core/controller/dm/prefix/vw.php. Find:

Code:

$bbcode_update['values']['vw_options'] = $bit;

Replace with:

Code:

$bbcode_update['values']['vw_options'] += $bits["$bit"];
Reply
April 5, 2014 1:08 PM

Ptah

Junior Member

Thanks! With that code tweak, I can successfully save Prefixes w/o error.

Reply
April 5, 2014 1:42 PM

Ptah

Junior Member

Guessing it may be related, but just wanted to point out that this resolved the issues I was having with Prefixed wiki links, as I posted in that to-be-moderated "Questions" thread.

Previously, I couldn't seem to get prefixed wiki links to work whatsoever. Not with a custom bbocode, not with the standard wiki link, etc.

Now, everything seems to work as expected.

Thanks, again.

Reply

+ Reply

All times are GMT -4. The time now is 6:34 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Prefix Manager MySQL error on Save Prefix

Issue Tools