Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mySQL error: 1054
#1
Hello,

There is an mySQL error: 1054 on Admin Control Panel ---> Administrator Permissions

this is what comes up

Code:
mySQL error: 1054
Unknown column 'u.uid' in 'on clause'
Query: SELECT u.uid, u.username, u.lastactive, g.cancp, a.permsset FROM saproductions_users u, saproductions_usergroups g LEFT JOIN saproductions_adminoptions a ON (a.uid=u.uid) WHERE u.usergroup=g.gid AND g.cancp='yes' ORDER BY u.username ASC

Any help would be great thanks

The forums is: http://saproductions.createmybb.com/
Reply
#2
Fixed. I think that was a mybb bug with MySQL 5.

CreateMyBB
Please don't PM me for support. Try to post a topic allows other people to learn.
[Image: sig-jon.png]
Like CreateMyBB? Support me at https://www.patreon.com/vbgamer45/
Reply
#3
Thanks also on that forum im ment to be a co-admin but i can't seem to set admin permissions for myself not even the admin (shaunallsop) too it just has shaunallsop there but it should be shaunallsop & Jag100 on that list
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)