Quote:
Originally Posted by darksoulz
getting a sql error on this. anyone have an idea how to fix?
Code:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135705843 AND userid IN ()
GROUP BY userid;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY userid' at line 3
Error Number : 1064
Date : Thursday, January 26th 2006 @ 11:50:43 AM
Script : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer :
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161
a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168
and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181
|
I see you are using MySQLi, I didn't do any test on it. I will look at the code tonight to see what I can come up with.