Hello, I've just installed AWS "by the book", version 3.1.2
I get the following errors in admincp:
When clicking Statistics - Bans per User:
/admincp/admin_warn.php
Database error in vBulletin 3.0.6:
Invalid SQL: select b.*, u.*, a.username AS warner, w.*, wt.* from ban_dates as b
LEFT JOIN user AS u ON(u.userid = b.banned_user)
LEFT JOIN user AS a ON(a.userid = b.banned_by)
LEFT JOIN warnings AS w ON(w.wid = b.banned_warning)
LEFT JOIN warning_types AS wt ON(wt.tid = w.warned_warning_id)
ORDER BY b.banned_user, b.banned_ban LIMIT 0,
mysql error: You have an error in your SQL syntax.
When clicking Statistics - Warnings per User
/admincp/admin_warn.php
Invalid SQL: select * from
user u where warnings>0 ORDER BY userid ASC LIMIT 0,
mysql error: You have an error in your SQL syntax.
Looks like the $perpage variable isn't set for some reason, see LIMIT 0,
A bug?
What should I check for?
Thanks for any info