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

[nanana777]

Dear,

Please help and how can I fix this

Actions:

- When I use modcp.php?action=ipsearch

- Select Search Posts

- Enter

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

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
----------------------------------------------------------------------------------------------------------------

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

[Devilshakerz]

Does modcp.php have any custom modifications?

Try:

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

[nanana777]

Dear,

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

[.m.]

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