Tagged Questions

0
votes
4answers
1k views

python manage.py syncdb not working correctly

I played around with Django, python and MySQL; and have installed and made them work when do import django, import MySQLdb through python command line. But when I try to execute python manage.py ...
1
vote
3answers
716 views

Django Rest Framework / Django performance issue

I am currently deploying Django w/ Django-Rest-Framework on my EC2 small instance server to provide a set of APIs for a couple of Android apps. The problem is that i am facing a serious performance ...
0
votes
3answers
945 views

Problem with Django syncdb on Amazon EC2

I'm trying to deploy my project on my EC2 instance. When I run python manage.py validate I get this error Error: No module named mysql.base . I have already installed MySQL-python using yum install ...
5
votes
2answers
4k views

Django on CentOS

I'm looking to use Django on a shared host that's running an unknown version of CentOS. My main problem is trying to interface with a database. The server has MySQL installed, but not MySQL-python. I ...
3
votes
2answers
1k views

Django + OsX Lion + Mysql with XAMPP

I have the following on my MacBook with Osx Lion: Mysql running with xampp (http://www.apachefriends.org/it/xampp.html) Django 1.3 running in a virtualenv I installed Mysql-python with pip install ...
0
votes
2answers
26 views

warning :data truncated for column 'username' at row 1 when using database mysql with django

I am getting the above mentioned warning data truncated for column 'username' at row 1 I am getting this for my model "suserprofile" with "username" as my first listed field ...
0
votes
2answers
221 views

Pycharm Django Syncdb MySQLdb not found

I've started using Pycharms for my django development and have come to this error. I know that my MySQLdb is working as I can import it when I go into the python shell and I can run syncdb commands on ...
2
votes
1answer
325 views

Mysql + django exception: “Commands out of sync; you can't run this command now”

Running django via gunicorn to RDS (AWS mysql), I'm seeing this error in my gunicorn logs: Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now") ...
2
votes
1answer
110 views

How can I detect total MySQL server death from Python?

I've been doing some HA testing of our database and in my simulation of server death I've found an issue. My test uses Django and does this: Connect to the database Do a query Pull out the network ...
1
vote
1answer
72 views

Unicode charactered filename SELECT SQL parameter issue

I have a webapp/webservice method created in django, which stores unicode character filenames on a DB-table. I am doing it by this method on the views.py script: SubmissionContents(id=subid, ...
1
vote
1answer
237 views

clang error when installing MYSQL-python on Lion-mountain (Mac OS X 10.8)

When I try installing mysql-python using below command, macbook-user$ sudo pip install MYSQL-python I get these messages: ...
1
vote
1answer
223 views

locate libmysqlclient_r.so.16 issue

Like to start off by advising that i am a novice and my webdesigner is out of the country. I have the issue below and looking for some advice. I have already re-installed mysqldb and upgraded the ...
1
vote
1answer
508 views

Django Dev Environment Broken Following Mac OS 10.7 Reinstall

I recently experienced trouble with my hard drive and used Disk Utilities to reinstall Mac OS 10.7 Lion. When I went to run my Django app, I got the following errors: ################ BEGIN ERRORS ...
0
votes
1answer
38 views

How do I remove a python egg?

This post (How to install MySQLdb (Python data access library to MySQL) on Mac OS X?) recommends cleaning up a MySQLdb installation by removing a python egg: "Step 3c: Remove the egg under ...
0
votes
1answer
58 views

Generate SQL Insert statements for SQLite with Django

I want to generate a complete SQL file with Django that can be downloaded and executed to create a SQLite DB. The problem is escaping the strings to insert them into the file to download. This is ...
0
votes
1answer
165 views

how can I specify multiple “init_command”s in Django's setup file

I have the following setup for my connections to a MySQL database in Django. 'default': { 'NAME' : MYSQL_DB_NAME, #'ENGINE' : 'mysql', 'ENGINE' : 'django.db.backends.mysql', 'USER' : ...
0
votes
1answer
216 views

Django DB transactions and deadlocks

When running Django with Gunicorn with multiple processes/workers I'm getting a deadlock issue with some of my manual MySQL database transactions. DatabaseError(1205, 'Lock wait timeout exceeded; try ...
0
votes
1answer
427 views

Installing MySQLdb 1.2.3 with Python For Django on Mac OSX?

I am a beginner Java developer and newbie to Python and I want to install Django and from what i understood that i need to install MySQLdb 1.2.3 with Python and I have MySQL already installed so I am ...
-1
votes
1answer
212 views

Django on Mac OS X requires install of MySQLdb

I tried setting up Django to use a MySQL database and it choked because the backend was not available. Reading around the net I see that MySQLdb needs to be installed, and perhaps _mysql needs to be ...
1
vote
0answers
46 views

Django Unknown system variable 'TRANSACTION' on syncdb

My local Django is blowing up running the manage.py syncdb script that runs on our servers. This is the error message I'm seeing when running python manage.py syncdb, OperationalError: (1193, ...
1
vote
0answers
615 views

WSGI: _mysql.so Image not found

Environment: MacBook Pro, OSX 10.6, Python 2.6.1 64 bit, MySQL 5.X 64 bit I am having problems installing MySQLdb for use with Django. After installing everything I am able to open the python ...
0
votes
0answers
16 views

Hook available for automatic retry after deadlock in django and mysql setup

I am using innoDB table in Django with mysql database. During investigation of error OperationalError: (1213, 'Deadlock found when trying to get lock; try restarting transaction') I came across ...
0
votes
0answers
21 views

connections leak in django

Sometimes MySql throws exception _mysql_exceptions.OperationalError: (1203, "User senderma_user already has more than 'max_user_connections' active connections"). Could you help me to ...
0
votes
0answers
56 views

Django support for Mysql with Python version 3.0 in windows

While using Django with "Python 3.3.0" it throws the exception raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e) django.core.exceptions.ImproperlyConfigured: Error loading ...
0
votes
0answers
610 views

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module:

I am following the django tutorial, Many have asked the question but I think my situation is bit unique because after installing python-mysql I still get this error when I try to do python manage.py ...
0
votes
0answers
146 views

Django mysql cursor callproc with temporary table

I have multiple databases configured in my django projects settings.py I need to use raw sql to call a stored procedure. I am using the following code snippet from django.http import HttpResponse ...
0
votes
0answers
335 views

MySQLdb not running on Mac 10.7

I am trying to install MySQL-Python (MySQLdb) locally on my Mac and I am having trouble. I have been working on this for HOURS and I continue to get this error: >>> import MySQLdb ...
-3
votes
0answers
34 views

Installing Mysql-python for Django on windows, error : command 'gcc' failed with exit status 1

I'm getting this error when trying to install Mysql-python for Django on windows. I'm using virtualenv for powershell and wamp for Mysql _mysql.c:42:24: error: config-win.h: No such file or directory ...