Tagged Questions
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
2k views
Using MySQL in Pydev Eclipse
I am trying to access a MySQL database with python through Pydev Eclipse. I have installed the necessary files to access MysQL from python and I can access the database only when I write code in ...
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
34 views
No LOAD DATA support in stored procedures in MySQL?
Actually I am trying to LOAD DATA in MySQL stored procedure but I am getting
MySQL Database Error: LOAD DATA is not allowed in stored procedures.
My Syntax is:-
DELIMITER //
CREATE PROCEDURE ...
0
votes
0answers
35 views
Simplifying Large SQL Prepared Statements in Python
I've made a Python script to insert some values from Excel Spreadsheets onto a mySQL database. I'm using mySQLdb and prepared statements. I am reading from multiple files with iterators, and each of ...
0
votes
0answers
21 views
Python MySQLdb returns a list of empty strings on a large query
The MySQL query I'm running returns 2,903,781 items in its result set.
When I do the query using MySQLdb in Python, and attempt to get back a list with fetchall(), I get a list that is the correct ...
0
votes
0answers
34 views
Cannot create cursor with MySQLdb
I am connecting to a database with the following code:
#generate connection to database
def connection():
return MySQLdb.connect(host = __HOST__,
user = __USER__,
...
0
votes
0answers
23 views
Update rank in MySQL with WHERE clause
I'm trying to rank a MySQL table where ties share the same rank, I found the below code from question 2727138, does this, however I need a WHERE clause on playerID
I've added it in a few places but ...
0
votes
0answers
38 views
MySQLdb undefined - import MySQLdb
So I have this application called Openfreezer.
I have followed the instructions perfectly to make their web application work... and it does.
But now when I play around with it and it starts calling ...
0
votes
0answers
38 views
weakly-referenced object no longer exists error on creating a function
I am working with MySQL connector and Python 3.3. I am creating a script that consists of functions that frequently access database server. So for all the functions I have created, I am trying to ...
0
votes
0answers
44 views
MySQLdb return average of results
Its possible to return the average of selected data using MySQL, however I can't seem to do this using MySQLdb, my code is as follows
cursor = database.cursor()
cursor.execute ("SELECT AVG(points) ...
0
votes
0answers
29 views
Influence of forking on existing mysql-connection
I have a server which is/should be able to handle a lot of connections at the same time.
Now sometimes I have an error: “Lost connection to MySQL server during query”. At the time I am fixing this ...
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
28 views
Optimizing queries in Djano
I am creating a site using django. For testing I have created a database with 1 million rows each containing information(uploaders, orientation, description, and a handful of others) about images on ...
0
votes
0answers
107 views
SSH Tunneling and MySQLdb
This seems like a very typical use case, but I just can't get it to work correctly. I have set up an ssh tunnel with:
ssh user@mySQLserver -NfL 3306:127.0.0.1:3306
I have no instance of mysqld on ...
