MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Support > Newpoints error. Mysql.
Full Version: Newpoints error. Mysql.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

AURA

2012-07-31, 04:39 PM
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'newpoints' in 'field list'
Query:
UPDATE mybb_users SET newpoints = newpoints+0 WHERE uid='1'
Please contact the MyBB Group for support.

Why is this coming up? I go onto the shop, and its all fine - BUT, it's just at the bottom of the whole site? Thanks c:

EDIT: In-fact whenever I post it comes up with errors but will still post. I also cannot earn any money or buy a $1 item :/

EthanD

2012-07-31, 04:47 PM
It's because in your users table, the plugin never set a field for newpoints, or he called it something else. I'm not entirely sure what that query does, but it doesn't look constructed properly.

You might have to manually insert a column for newpoints in the users table, but that should automatically be done by the plugin. Did you try contacting the author?

AURA

2012-07-31, 05:01 PM
No, I did not. How would i go about doing the field?
MyBB Community Forums > Extensions > Plugins > Plugin Support > Newpoints error. Mysql.