MyBB Community Forums

Full Version: Column 'uid' in where clause is ambiguous
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Please help and how can I fix this

[Image: Screenshot-2020-03-08-XNX-NETWORK-Internal-Error.png]
- 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

SELECT COUNT( 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
Does modcp.php have any custom modifications?

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

My File Verification
inc/functions.php Changed
images/buttons_sprite.png Changed
^ what about plugins ? see related reply here => [Link]