Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved SQL Error: 1054 with Private Messages
#1
Not Solved
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.
#2
Not Solved
*bump*
#3
Not Solved
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.
#4
Not Solved
any help?
#5
Not Solved
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)
#6
Not Solved
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.
No longer involved in the MyBB project.
#7
Not Solved
(03-24-2014, 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!


Forum Jump:


Users browsing this thread: 1 Guest(s)