REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MyBB MyAwards Error
#1
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.
Reply
#2
go to the Database and do exactly what it says and it'll work.
I offer MyBB Support to all members of MyBBCentral.
Reply
#3
(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'
Reply
#4
(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.
I offer MyBB Support to all members of MyBBCentral.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Image Verfication Error. Arya 3 1,889 Dec 21, 2016, 06:13 AM
Last Post: walter
  MySubscription error.. AJRiley 3 1,802 Jun 19, 2016, 11:54 PM
Last Post: Jiant
  MyAwards SQL error when clicking "Activate" in Plugins Gh0st 1 1,227 Feb 11, 2016, 03:26 PM
Last Post: Gh0st
  forum/myawards.php not showing? pompano 4 2,694 Feb 24, 2015, 10:02 AM
Last Post: Genesis
  MyBB Tabbed Menu Error Kiggoz 2 2,361 Jan 07, 2015, 11:13 AM
Last Post: Kiggoz

Forum Jump:


Users browsing this thread: 1 Guest(s)