MyBB Community Forums

Full Version: MySQL Error: 1054 on mass PM.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Ok, when I try to mass PM people, heres the error I get.
Unknown column 'pmnotice' in 'field list'
Query: UPDATE mybb2_users SET pmnotice='new' WHERE uid='4'

But when I log in to Webmin to check if the field list has the same name for that field as the DB Query code, it doesn't, instead, the field is named "pmnotify".
Is this a bug or a miscoded query?

(If this is a bug, move it to the Bug Reports forum.)
This was a bug report but I thought it was fixed with the most recent upgrade???
http://community.mybboard.net/showthread.php?tid=26275
It was fixed with the most recent upgrade...

Looking at a fresh download off of the MyBB website's admin/users.php:

if($user['pmnotify'] == "yes")
				{
					$updated_user = array(
						"pmnotify" => "new"
					);
					$db->update_query(TABLE_PREFIX."users", $updated_user, "uid='{$user['uid']}'");

Which is correct.