satels/django-ipgeobase — Issue #3: Got 'Invalid syntax' error on MySQL when doing ipgeobase_update
Author: yeputons
Created: 2012-01-01 11:00:54+00:00
State: open

I use Django (python 2.7) with MySQL on linux, and when I try to run ./manage.py ipgeobase_update I get 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 \'"start_ip", "end_ip", ip_block, country, city, region, district, latitude, longi\' at line 2'.
Removing of quotes around 'start_ip' and 'end_ip' fixes the problem. Because there're no quotes around other fields' names, I think that this won't break compatibility with other servers.