MyBB Community Forums
Update Broke - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Support (https://community.mybb.com/forum-72.html)
+---- Thread: Update Broke (/thread-189775.html)



Update Broke - Predatorz - 2016-03-12

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?


RE: Update Broke - Destroy666 - 2016-03-12

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.