MyBB Community Forums

Admincp problem.

SQL Error:
1064 - 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 ')' at line 3
Query:
SELECT COUNT(u.uid) AS num_results FROM mybb_users u WHERE 1=1 AND u.uid IN()

That isn't working anymore. I tested both upgrade package and full package files just in case.

I need a fix for this asap. It's very important I can search via PMs to prevent fraud on my sites.

more details? I don't even know which file your talking about.

In admin/modules/user/user.php find:

$ip_uids = array();

replace with

$ip_uids = array(0);

Ryan

That seemed to do it.

Thanks.

Seems ok to me..

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group