Unknown column 'username' in 'where clause'


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.


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

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




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