0
votes
0answers
11 views
Python script ( w/mod_python ) works okay via cli but not okay via web. here's the full code
The script works but shows error if the database password
for example is wrong.
but when the code is correct, apache shows a "NOT FOUND"
error on the browser.
while via command line it works just ...
0
votes
1answer
22 views
How to establish a connection from a wxpython desktop app to a remote msyql database?
I'm writing a desktop app in wxpython. For simplicity sake let's say it's a just a frame with a button in it. When someone clicks that button a record inserted into a remote mysql table with the ...
0
votes
1answer
9 views
How to get column names of a schema in sqlsoup in python?
How do you get column names and types in a dictionary from a schema/table using SQLSOUP in python? With MySQLDB I can create a cursor and use cursor.description. is there some equivalent for sqlsoup?
0
votes
1answer
22 views
foreign key constraint fails
I'm doing a django project using mysql as the database, I have to get some data from another database to fill some fields of my django database tables
my django model for student is like this:
class ...
1
vote
2answers
20 views
sqlalchemy OperationalError: (OperationalError) (1045, "Access denied for user
I am trying to create a remote database using mysql on an Ubuntu machine running 12.04.
It has a root user with remote login enabled.I have started the server.
output of
sudo netstat -tap | grep ...
2
votes
1answer
41 views
Using python for an INSERT with MySQL
I am trying to insert into a MYSQL database with the following commands:
add_contact = "INSERT INTO contacts (id, name, industry, phone, fax, url, pobox, emirate,ranking) VALUES (?, ?, ?, ?, ?, ?, ?, ...
0
votes
0answers
24 views
keyError in python when using networkx package to visualize data
I'm trying to download twitter account and followers information trying to visualize the data by creating a relationship graph with Networkx python package and Gaphi.
import networkx as nx
...
0
votes
1answer
21 views
difference in mysql editor select query and python program select query result
I am executing a select query from python program to MySQL 5.2.39 database. But the result from mysql editor select query and python program select query is slightly different. Database name is world, ...
0
votes
0answers
16 views
Python / MySQL / Can't create TCP/IP socket (24)
After some hours of operation my python script is spitting the following message.
ERROR protocol # [Failure instance: Traceback: <class '_mysql_exceptions.OperationalError'>: (2004, "Can't ...
3
votes
4answers
37 views
Database table names with Django
I already have a database named "mydb", where I have a table called "AERODROME".
My models.py looks like this:
from django.db import models
class Aerodrome(models.Model):
Name = ...
0
votes
0answers
40 views
Python connecting to MySQL database name error
I got the following code from this site to connect to a mysql database through python (which is much appreciated by the way). I have used it once already to connect to a database on the server, but in ...
0
votes
0answers
17 views
MySQLdb for python behaves differently for queries than the mysql workbench browser
I am executing update in mysqldb which is changing the values of part of a key and field. When I execute the query in python it triggers something in the database to cause it to add extra rows. When ...
0
votes
1answer
31 views
create a daemon python script to control when a MySQL data has changed
I would like to create a daemon python script to control when a MySQL data has changed.
I have a table with two columns: one column named valore and an other call id. Whenever the valore column gets ...
-1
votes
1answer
73 views
Extracting with Python [closed]
I am currently working on a python program that extracts information from a stock website
http://markets.usatoday.com/custom/usatoday-com/html-mktscreener.asp
I need to extract all the columns ...
1
vote
2answers
42 views
UnicodeEncodeError and inserting a data into db
I have a Python scraper which scraper a web site and inserts a data into MySql db. All of a sudden I got an error of
UnicodeEncodeError: 'latin-1' codec can't encode character u'\u20ac' in position ...
