MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > Column 'uid' in where clause is ambiguous
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.

nanana777

2020-03-07, 07:31 PM
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

Devilshakerz

2020-03-07, 08:02 PM
Does modcp.php have any custom modifications?

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

nanana777

2020-03-08, 01:17 AM
Dear,

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

.m.

2020-03-08, 02:29 AM
^ what about plugins ? see related reply here => [Link]
MyBB Community Forums > 1.8 Support > General Support > Column 'uid' in where clause is ambiguous