Issue: Database Error Saving Preferences

Issue Tools
- View Changes

January 15, 2017 7:03 AM

samh004

New Member

Database Error Saving Preferences

When in vBulletin User Settings and trying to edit the VaultWiki Preferences, I am not able to "Save Changes" when changing Moderated Content, Subscriptions or Message Parsing options. The website returns an error.

In addition, I do not appear to be getting "Moderated Content" notifications, despite these setting being turned on (both on-site and email), and I am trying to disable on-site to see if that will fix the problem. Selecting any other setting results in an error too though.

Code:

Database error in vBulletin 4.2.3:

Invalid SQL:
UPDATE  `vw_moderator` SET `options` = 2 WHERE userid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
Error Number  : 1064
Request Date  : Sunday, January 15th 2017 @ 06:58:42 AM
Error Date    : Sunday, January 15th 2017 @ 06:58:42 AM
Script        : [url]http://www.australianfrequentflyer.com.au/community/[/url]
Referrer      : [url]http://www.australianfrequentflyer.com.au/community/[/url]
IP Address    :
Username      : support
Classname     : vB_Database
MySQL Version : 5.5.53-MariaDB

Issue Details

Issue Number 4875

Issue Type Bug

Project VaultWiki 4.x Series

Category Moderator Tools

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 4.0.16

Fixed Version 4.0.16

Milestone (none)

Software DependencyvBulletin 4.x w/ ckEditor

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

January 15, 2017 9:48 AM

pegasus

VaultWiki Team

In vault/core/controller/ui/watch/vw.php, find:

Code:

$autolinks = $input->clean_gpc('p', $fieldprefix . 'autolinks', 'BOOL');

After it, add:

Code:

$userid = vw_Hard_Core::model('User')->get('userid');

January 15, 2017 6:52 PM

samh004

New Member

Thank you, that fixed it!

That said, I am no longer getting "Moderated Content" emails, and am having troubles comparing versions when a user has edited the wiki and I have to check the changes to approve/unapprove. I am not sure if this is related?

Reply

+ Reply

All times are GMT -4. The time now is 4:28 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: Database Error Saving Preferences

Issue Tools