MyBB Community Forums
SQL Error: 1054 with Private Messages - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 Merge System Support (https://community.mybb.com/forum-141.html)
+------ Thread: SQL Error: 1054 with Private Messages (/thread-147266.html)



SQL Error: 1054 with Private Messages - oasis - 2013-10-28

Everything pretty much successful converting over from IPB v2.1.4.

Except I get this error in old PM and when I try to view sent folder.
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'Guest' in 'where clause'
Query:
SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (Guest)

I would like help to get this fix.

Thank you.


RE: SQL Error: 1054 with Private Messages - oasis - 2013-10-30

*bump*


RE: SQL Error: 1054 with Private Messages - oasis - 2013-11-18

MSQL Error:
1054 - Unknown column 'Guest' in 'where clause'
Query:
SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (51,Guest)

Please how to fix this.


RE: SQL Error: 1054 with Private Messages - oasis - 2013-12-01

any help?


RE: SQL Error: 1054 with Private Messages - oasis - 2014-03-24

updating I hope to have help still..

SQL Error:
1054 - Unknown column 'Guest' in 'where clause'
Query:
SELECT uid, username, usergroup, displaygroup FROM mybb_users WHERE uid IN (51,78,143,8,Guest)


RE: SQL Error: 1054 with Private Messages - Nathan Malcolm - 2014-03-24

Two solutions.

1) Edit private.php

Before:

$get_users = implode(',', array_unique($get_users));

add:

$get_users = array_map('intval', $get_users);

There should be two occurrences where this change is needed.

2) Run these queries on the database (make sure you backup first)

update mybb_privatemessages set to = replace(to, 'Guest', 0)
update mybb_privatemessages set bcc = replace(to, 'Guest', 0)

I haven't tested either of these but one of them should work for you.


RE: SQL Error: 1054 with Private Messages - oasis - 2014-04-25

(2014-03-24, 08:05 PM)Nathan Malcolm Wrote: Two solutions.

1) Edit private.php

Before:

$get_users = implode(',', array_unique($get_users));

add:

$get_users = array_map('intval', $get_users);

There should be two occurrences where this change is needed.

2) Run these queries on the database (make sure you backup first)

update mybb_privatemessages set to = replace(to, 'Guest', 0)
update mybb_privatemessages set bcc = replace(to, 'Guest', 0)

I haven't tested either of these but one of them should work for you.
I had no success.

I really like help if possible. I know it's out of line if one the staff willing contact and help me, but it be highly appreciated and I need it.

I've been supportive of mybb since 2006. This is for my Nirvana forum that I brought back and converted the system from IPB v2.1.4. Only error is this error.

Thank You!