Not Solved [Error Message] Column 'uid' in where clause is ambiguous
#1
Not Solved
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
Reply
#2
Not Solved
Does modcp.php have any custom modifications?

Try:
  • ACP's Tools & Maintenance → File Verification
  • Disable All Plugins in Configuration → Settings → General Configuration
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#3
Not Solved
Dear,

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


Forum Jump:


Users browsing this thread: 2 Guest(s)