MyBB Central

Full Version: MyBB MyAwards Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am posting this thread because I am getting an SQL error when trying to grant an award to a user. If anyone knows how I could fix this please message me.

This is the error that is given each time I try to grant an award:
Code:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'awards' in 'field list'
Query:
    UPDATE grandf_users SET awards=awards+1 WHERE uid='3'

Please contact the MyBB Group for support.
go to the Database and do exactly what it says and it'll work.
(Oct 30, 2014, 06:02 PM)Nasyr Wrote: [ -> ]go to the Database and do exactly what it says and it'll work.

Okay so does that mean I will continue to get the error when I try to grant an award to a different member. For instance, its saying uid 3 but will I need to do the same for uid 4 whenever I try to grant that member an award?

Also, when I try to update my database I get another error in the phpMyAdmin this time:
Code:
SQL query:

UPDATE grandf_users SET awards=awards+1 WHERE uid='3'

MySQL said: Documentation
#1054 - Unknown column 'awards' in 'field list'
(Oct 30, 2014, 07:21 PM)Red™ Wrote: [ -> ]
(Oct 30, 2014, 06:02 PM)Nasyr Wrote: [ -> ]go to the Database and do exactly what it says and it'll work.

Okay so does that mean I will continue to get the error when I try to grant an award to a different member. For instance, its saying uid 3 but will I need to do the same for uid 4 whenever I try to grant that member an award?

Also, when I try to update my database I get another error in the phpMyAdmin this time:
Code:
SQL query:

UPDATE grandf_users SET awards=awards+1 WHERE uid='3'

MySQL said: Documentation
#1054 - Unknown column 'awards' in 'field list'

Add an awards column to the field list.
You can always delete all the myawards files and then re-add them all and see if it has an effect.
If you've granted a load of awards, it's not advised.