Got an error while trying to use MySql as DB

[satyaakam goswami]

Hi,

     anyone tried using MySql as db i am getting the following error , 

http://dpaste.de/Ch5yh/

in the production system we will be using MySql, Gunicorn and  Nginx 

-Satya

fossevents.in

[satyaakam goswami]

On Sun, Dec 30, 2012 at 8:18 PM, satyaakam goswami <saty...@gmail.com> wrote:

Hi,

     anyone tried using MySql as db i am getting the following error , 

http://dpaste.de/Ch5yh/

in the production system we will be using MySql, Gunicorn and  Nginx 

trying to set the following line in the settings.py

'OPTIONS': {'init_command': 'SET storage_engine=InnoDB' 'SET foreign_key_checks = 0'},

still getting the following error 

_mysql_exceptions.ProgrammingError: (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 'foreign_key_checks = 0' at line 1")

-Satya

fossevents.in

[satyaakam goswami]

looks like a bug in Django  1.3.1 https://code.djangoproject.com/ticket/3615 and http://stackoverflow.com/questions/8045530/how-can-i-load-fixtures-with-circular-foreign-keys-in-django

-Satya
fossevents.in

 

[satyaakam goswami]

We have to use this patched version pip install -e git+git://github.com/kipanshi/djang...@1.3.1.1#egg=django-1.3.1.1 of Django in order to overcome this Bug

i tested it worked fine for me .

-Satya

fossevents.in