# Unknown column 'username' in 'where clause'

**URL:** <https://community.dreamfactory.com/t/unknown-column-username-in-where-clause/4616>\
**Category:** uncategorized\
**Created:** [September 10, 2018, 8:18pm UTC](https://community.dreamfactory.com/t/unknown-column-username-in-where-clause/4616 "2018-09-10T20:18:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erik](https://avatars.discourse-cdn.com/v4/letter/e/b5ac83/32.png) [@Erik](https://community.dreamfactory.com/u/Erik)\
**Post date:** [September 10, 2018, 8:18pm UTC](https://community.dreamfactory.com/t/unknown-column-username-in-where-clause/4616/1 "2018-09-10T20:18:33Z")

</div>

I’ve just installed DreamFactory on a server. When trying tro create the first system admin user, I get an error:

# Whoops, looks like something went wrong.

### QueryException

_SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘username’ in ‘where clause’ (SQL: select count(\*) as aggregate from `user` where `username` = [algemeen@mydomain.com](mailto:algemeen@mydomain.com))_

When I look at the table ‘user’ (phpmyadmin), it - indeed - does not have a column ‘username’. What could be wrong here?

Regards,

Erik

---

<div class="post-metadata">

**Author:** ![Erik\_Jacobsen](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/erik_jacobsen/32/1132_2.png) [@Erik\_Jacobsen](https://community.dreamfactory.com/u/Erik_Jacobsen)\
**Post date:** [October 17, 2018, 8:34pm UTC](https://community.dreamfactory.com/t/unknown-column-username-in-where-clause/4616/2 "2018-10-17T20:34:02Z")

</div>

> [@Erik](#):
>
> SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘username’ in ‘where clause’

Which install method did you use? Most likely the `php artisan migrate --seed` process did not complete correctly.

Please see this post: [SQL database connection error - #12 by mrjohny](https://community.dreamfactory.com/t/sql-database-connection-error/1878/12)