MyBB-Plugins Forums

Full Version: MySQL error when newpoints is activated.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i keep getting sql errors whenever i post if newpoints is activated. what could be the problem?

MyBB SQL Error

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`+1 WHERE `uid`='1'

how can i fix this?
It doesn't look like it's been installed correctly because the newpoints field does not exist in your setup.
i copied it to the server twice. i still get the same error.
Copying the files won't install anything. You must click the Install link.
maybe i'll just have to leave it without a points system because it won't let me uninstall it or anything :/
(09-09-2011, 03:49 AM)Hunter Wrote: [ -> ]maybe i'll just have to leave it without a points system because it won't let me uninstall it or anything :/

Hunter;
We're really interested in helping you, but for doing so, please include the following information when posting your problems:

Detailed description of your problem, including steps to reproduce if necessary
URL to your forum/URL to specific problematic page
New installation or upgrade (from which version of MyBB)?
Test user account (if a posting/UserCP issue) (admin permission one if for installing plugins)
Screenshot or error text, verbatim
i also have this error now. shall i copy the files again then?

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'newpoints' in 'field list'
Query:
SELECT uid,username,newpoints FROM mybb_users ORDER BY newpoints DESC LIMIT 10

i have mybb 1.6.4
try copying your files again, and give me an screenshot if error appears again
It's impossible to help someone when that person does not give any information about the problem and doesn't respond to what we ask/tell them to do
it might just be the server it's running on, because i installed it on byethost and it worked. sorry for wasting your time.