Not Solved Update Broke
#1
Not Solved Exclamation 
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?
Reply
#2
Not Solved
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)