SQL Error: 1054 with Private Messages

[oasis]

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.

[oasis]

*bump*

[oasis]

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.

[oasis]

any help?

[oasis]

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)

[Nathan Malcolm]

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.

[oasis]

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!