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


Messages In This Thread
mySQL error: 1054 - by Jag100 - 08-10-2006, 12:07 PM
RE: mySQL error: 1054 - by Jon - 08-10-2006, 01:19 PM
RE: mySQL error: 1054 - by Jag100 - 08-11-2006, 09:58 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)