MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 Merge System Support > 1054 - Unknown column 'username' in 'where clause'
Full Version: 1054 - Unknown column 'username' in 'where clause'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

kadri007

2014-08-26, 08:10 AM
Hi Guys,

I am trying to migrate from PHPBB3 to MYBB from long time. At first had database connecting issue. Now once it has got connected I am getting the following error. Please help


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:

1054 - Unknown column 'username' in 'where clause'

Query:
SELECT COUNT(*) as count FROM phpbb_users WHERE user_id > 0 AND username != 'Anonymous' AND group_id != 6

Best regards
Kadri007

Jones H

2014-08-30, 07:51 AM
Odd, I never had that issue. Are you using the newest version or are you using any mods on phpbb?

Jovan J.

2014-08-31, 03:47 PM
I looked over phpBB database structure, and everything seems fine in our code. As Jones said, did you made any changes to your phpBB database?
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 Merge System Support > 1054 - Unknown column 'username' in 'where clause'