search

code4lib / shortimer

a webapp for code4lib jobs
http://jobs.code4lib.org
40 stars 15 forks source link

Syncdb error #28

Closed bibliotechy closed 10 years ago

bibliotechy commented 11 years ago

Tried to run syncdb with appropriate flags on an empty db, but I get this error:

DatabaseError: (1054, "Unknown column 'jobs_employer.description' in 'field list'")

Ideas?

edsu commented 11 years ago

You get that when you run syncdb? Have you tried running the migrations?

./manage.py migrate shortimer.jobs

I think this currently has a migration to create the column, and another to load employer descriptions from Freebase. So if you have a bunch of jobs in there this could take a while. But if your database is empty it should be quick. If you'd like a more recent database snapshot let me know, and I can hook you up.

bibliotechy commented 11 years ago

I ran ./manage.py syncdb --migrate --noinput on a pristine mysql db, and this is the output https://gist.github.com/bibliotechy/5781505

edsu commented 10 years ago

I'm not sure if this is a problem still. If it is we can re-open.