How to error MySQL Error : Unknown column '0Array' in 'where clause' Error Number : 1054

  • Thread starter Thread starter AdminAdmin is verified member.
  • Start date Start date
Admin

AdminAdmin is verified member.

Well-Known Member
Staff member
Administrator
Today tuoitreit.vn will teach you how to fix error MySQL Error : Unknown column '0Array' in 'where clause' Error Number : 1054

Code:
Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054

Please do so
Open includes/functions_post_thanks.php
Find
PHP:
$post_ids = "0$postids";
Change to
PHP:
$post_ids = is_array($postids) ? implode(',',$postids) : "0$postids";

Good luck!
 

Facebook Comments

Similar threads

Admin
Replies
0
Views
1K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
2K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
1K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
4K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
7K
AdminAdmin is verified member.
Admin
Admin
Replies
0
Views
1K
AdminAdmin is verified member.
Admin
Back
Top