Re: MySQL InterfaceError

2007-06-07 Thread BartlebyScrivener
On Jun 7, 10:09 am, "Joe" <[EMAIL PROTECTED]> wrote: > > And, yes, printing the error message returns absolutely nothing. The tuple > following InterfaceError is both the error code and message. Unfortunately, > it will only give me (0, '') which isn't much help. > I'm on Google groups and can't

Re: MySQL InterfaceError

2007-06-07 Thread kaens
On 6/7/07, Joe <[EMAIL PROTECTED]> wrote: > > Huh the only thing I can find on InterfaceError is "Errors related to > > the database interface and not the database itself." You might be able > > to get some info from connection.info() . . . > > Yeah, I wish there was more documentation about this t

RE: MySQL InterfaceError

2007-06-07 Thread Joe
> Huh the only thing I can find on InterfaceError is "Errors related to > the database interface and not the database itself." You might be able > to get some info from connection.info() . . . Yeah, I wish there was more documentation about this type of error. The only thing info() tells me is th

RE: MySQL InterfaceError

2007-06-07 Thread Joe
> Try passing the cursor and not the connection - Unfortunately this provided the same InterfaceError. It was one of the first options we had tried in correcting the situation. Is there any way to check on the status of a database connection (like an isOpen() method)? It appeared as though the

Re: MySQL InterfaceError

2007-06-06 Thread kaens
On 6/5/07, Joe <[EMAIL PROTECTED]> wrote: > > > > > >File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line > 147, in execute > > >charset = db.character_set_name() > > > > > >InterfaceError: (0, '') > > > > We got it working. It was caused by passing a database connection to a > module: >

RE: MySQL InterfaceError

2007-06-06 Thread Joe
>File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 147, in execute >charset = db.character_set_name() > >InterfaceError: (0, '') We got it working. It was caused by passing a database connection to a module: import MySQLdb import module_name connection = MySQLdb.connect(

RE: MySQL InterfaceError

2007-06-04 Thread Joe
Sent: Monday, June 04, 2007 4:01 PM To: python-list@python.org Subject: MySQL InterfaceError I still consider myself a newbie, and being new to the list I request that you take it easy on me. ;) We're running a RHEL LAMP server with the mod_python publisher interpreter. The MySQLdb modul

MySQL InterfaceError

2007-06-04 Thread Joe
I still consider myself a newbie, and being new to the list I request that you take it easy on me. ;) We're running a RHEL LAMP server with the mod_python publisher interpreter. The MySQLdb module seems to be giving me more problems than I had hoped for. With a fresh restart of apache, all pro