Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Konoha Genious Blaze]

I got this when i went in.


SELECT sum(module_userprefs.value) AS pks, count(accounts.clanid) AS memcount, clans.clanname,accounts.clanid FROM accounts
         INNER JOIN clans
         ON accounts.clanid=clans.clanid
         INNER JOIN module_userprefs
         ON accounts.acctid=module_userprefs.userid
         WHERE accounts.clanid != 0
         AND module_userprefs.modulename='pktrack'
         AND module_userprefs.settting='count'
         GROUP BY accounts.clanid
         ORDER BY pks DESC,
         memcount ASC LIMIT 0,50
Unknown column 'module_userprefs.settting' in 'where clause'
Call Stack:
1: db_query("SELECT sum(module_userpre...") called from /var/www/html/naruto/modules/hofclanpk.php on line 73
2: hofclanpk_run() called from /var/www/html/naruto/runmodule.php on line 35

[Neji]

fixed.