MyBB Community Forums

Full Version: [B] Warn User SQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Trying to warn a member results in an error.

Reproduction Steps:

1. Go to a members profile
2. Click the "Warn" link
3. Enter an administrative note and select a warning type
4. Click "Warn User"

The following error is returned:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query:
    SELECT * FROM mybb_forums WHERE fid = 

I tried following what is discussed here http://community.mybboard.net/thread-41607.html but I got this in my PHPAdmin

Error

SQL query:

ALTER TABLE mybb_warnings ALTER COLUMN revokereason SET DEFAULT '';

MySQL said: Documentation
#1101 - BLOB/TEXT column 'revokereason' can't have a default value 
What plugins do you have installed?
Marked as bogus because of the lack of response.