MyBB Community Forums
[F] [BROKEN] Show users who have posted with this IP - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: Archived Bug Reports (https://community.mybb.com/forum-74.html)
+------ Forum: MyBB 1.4.4 (https://community.mybb.com/forum-110.html)
+------ Thread: [F] [BROKEN] Show users who have posted with this IP (/thread-48529.html)



[F] [BROKEN] Show users who have posted with this IP - labrocca - 04-19-2009

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.


RE: [BROKEN] Show users who have posted with this IP - Ryan Gordon - 04-19-2009

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


RE: [BROKEN] Show users who have posted with this IP - Ryan Gordon - 04-19-2009

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

$ip_uids = array();

replace with

$ip_uids = array(0);

Ryan


RE: [BROKEN] Show users who have posted with this IP - labrocca - 04-19-2009

That seemed to do it.

Thanks.


RE: [BROKEN] Show users who have posted with this IP - gamemaster - 04-19-2009

Seems ok to me.. Big Grin


[F] [BROKEN] Show users who have posted with this IP - Ryan Gordon - 04-19-2009

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