[sv1cec]

Originally Posted by Delphiprogrammi

sv1cec,

i'm having SQL errors when i try to view "view banned users" in my admincp also i noticed AWS is not showing the version number anymore it just shows 'advanced warning system version (this is empty)'

Database error in vBulletin 3.0.5:

Invalid SQL: select b.*, u.*, a.username AS warner, w.*, wt.*  from vb3_ban_dates as b
LEFT JOIN vb3_user AS u ON(u.userid = b.banned_user) 
LEFT JOIN vb3_user AS a ON(a.userid = b.banned_by) 
LEFT JOIN vb3_warnings AS w ON(w.wid = b.banned_warning)
LEFT JOIN vb3_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 near '' at line 6

mysql error number: 1064
script admin_warn.php?act=viewbans

now i'm totally stucked

regards

Delphi, did you enter a number of warnings per page, when viewing logs?

Your error is because the program cannot find how many lines per page to show.

Maybe you too have the same problem with the saving???

I am totally confused with this issue.

As for the Version number, did you run the query which updates that to the latest version number, when you upgraded?