search

propublica / Capitol-Words

Scraping, parsing and indexing the daily Congressional Record to support phrase search over time, and by legislator and date
BSD 3-Clause "New" or "Revised" License
122 stars 34 forks source link

Problem using django_jsonfield #83

Open AlJohri opened 10 years ago

AlJohri commented 10 years ago

I updated the requirements.txt to use

-e hg+https://dandrinkard@bitbucket.org/schinckel/django-jsonfield@ab026e78869b9be8f2d961a3e9a1730ae46cbc6d#egg=django_jsonfield-0.9.0

instead of 

-e hg+https://dandrinkard@bitbucket.org/schinckel/django-jsonfield#egg=django_jsonfield-dev

because

https://bitbucket.org/schinckel/django-jsonfield/commits/ab026e78869b9be8f2d961a3e9a1730ae46cbc6d

updates django-jsonfield's version to 0.9.0 which seems to be last compatible version with Capitol-Words.

However, I get

django.db.utils.DatabaseError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json NOT NULL\n)' at line 12")

when I run python manage.py syncdb.

This is because of cwod_site/cwod/models.py has class Embed(models.Model) with:

    extra = jsonfield.JSONField(blank=True, default='{}')

Do you know how to get this working properly?