MyBB Community Forums

After updating to 1.8.7 I keep getting errors when looking up IPs and stuff...

Type: 20
File:  (Line no. 0)
Message
SQL Error: 1052 - Column 'uid' in where clause is ambiguous
Query:
                                        SELECT COUNT(p.pid) AS count
                                        FROM mybb_posts p
                                        LEFT JOIN mybb_threads t ON (t.tid = p.tid)
                                        WHERE uid NOT IN (7) AND p.fid NOT IN (126,127,128) AND ((t.fid IN(104) AND t.uid='121345216') OR t.fid NOT IN(104)) AND (p.visible = 1 AND t.visible = 1) OR (p.visible = 0 AND p.fid IN(152)) OR (t.visible = 0 AND t.fid IN(152))

and

Type: 20
File:  (Line no. 0)
Message
SQL Error: 1052 - Column 'uid' in where clause is ambiguous
Query:
                                        SELECT COUNT(p.pid) AS count
                                        FROM mybb_posts p
                                        LEFT JOIN mybb_threads t ON (t.tid = p.tid)
                                        WHERE (p.ipaddress=X'25bb81a6') AND uid NOT IN (7) AND p.visible >= -1

I have no idea what is causing this so is there anyone out there with any answers on how to fix this?

One of your plugins is causing that (IIRC there was something that excluded users from IP searches), you need to either contact the author to correct it or manually change uid to p.uid in the queries.