[Error Message] Column 'uid' in where clause is ambiguous

[Error Message] Column 'uid' in where clause is ambiguous - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [Error Message] Column 'uid' in where clause is ambiguous (/thread-226801.html)

Column 'uid' in where clause is ambiguous - nanana777 - 2020-03-07

Dear,

Please help and how can I fix this

[Image: Screenshot-2020-03-08-XNX-NETWORK-Internal-Error.png]

Actions:

- When I use modcp.php?action=ipsearch

- Select Search Posts

- Enter

[Image: Screenshot-2020-03-08-XNX-NETWORK-IP-Search.png]

----------------------------------------------------------------------------------------------------------------

MyBB has experienced an internal SQL error and cannot continue.

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'6ca2f634') AND uid NOT IN (1) AND p.visible >= -1
----------------------------------------------------------------------------------------------------------------

Quote:My Setting
MyBB Version: 1.8.22
PHP Version: 7.0.33
SQL Engine: MySQLi 10.2.24

RE: Column 'uid' in where clause is ambiguous - Devilshakerz - 2020-03-07

Does modcp.php have any custom modifications?

Try:

ACP's Tools & Maintenance → File Verification
Disable All Plugins in Configuration → Settings → General Configuration

RE: Column 'uid' in where clause is ambiguous - nanana777 - 2020-03-08

Dear,

My File Verification
inc/functions.php Changed
images/buttons_sprite.png Changed

RE: Column 'uid' in where clause is ambiguous - .m. - 2020-03-08

^ what about plugins ? see related reply here => [Link]