Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#81 table names with spaces in don't work on remote connection

MySQLdb-0.9.2
closed
Andy Dustman
MySQLdb (285)
5
2012-09-19
2004-03-17
Anonymous
No

A quick description by example

When I run the query "SELECT * FROM Some Table LIMIT 1" on a
database I have connected to on localhost, the query runs without a
problem

When I run the same query on a remote machine I get an error
(included below) with database.Some Table in it. The ` chacaters have moved form around theSome Tableto thedatabase.Some
Table`

When I run the query "SELECT * FROM NoSpaceInName LIMIT 1" on
the remote machine, the query runs as it should.

traceback;

Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.1/site-packages/MySQLdb/cursors.py", line 95, in
execute
return self._execute(query, args)
File "/usr/lib/python2.1/site-packages/MySQLdb/cursors.py", line 114,
in _execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.1/site-packages/MySQLdb/connections.py", line
33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'database.Some
Table' doesn't exist")

p.s. I didn't name the tables (appart form the test obviously), I just get to
work with them.

Discussion

  • Andy Dustman
    Andy Dustman
    2004-05-15

    Logged In: YES
    user_id=71372

    I need version numbers (Python, MySQLdb, MySQL) and a code
    example to follow-up on this. I have good guesses at the
    Python and MySQLdb versions.