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.
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.
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)
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.
(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!