[SQLObject] SQLObject and mysql 4.0+ problem...

[Oisin M. <oi...@en...>]

Hi,

Does anyone have problems using SQLObject with MySQL 4.0+ ?
I recently installed MySQL 4 on two of my systems (suse and osx). Now I
can't get any of my programs to run as they used to under mysql 3.23.+

I've created a python script model of the problem and attached it.

When I run this on my Redhat system with mysql 3.23, the program works:

    1 - Using MySQLdb:
    1 - results: (('mysql',), ('test',))
    2 - Using SQLObject:
    QueryOne: SELECT COUNT(*) FROM func WHERE name;
    COUNT results: 0
    no results!
    2 - results <SQLObject.SQLObject.SelectResults object at 0x91921ec>

When I run this on osx and suse using mysql 4+ I get:

    1 - Using MySQLdb:
    1 - results: (('mysql',), ('test',))
    2 - Using SQLObject:
    Traceback (most recent call last):
      File "db.py", line 55, in ?
        main()
      File "db.py", line 47, in main
        if len(results) > 0:
    TypeError: len() of unsized object

I've tried using different versions of SQLObject from 0.3 up to 0.5 with
no effect. It appears that mysql 4 is the the problem.

Can anyone shed any light on this problem?


Redhat Severn:
    SQLObject 0.5.1
    MySQL-python-0.9.2
    mysql  Ver 11.18 Distrib 3.23.57, for redhat-linux-gnu (i386)

Suse 9:
    SQLObject 0.5.1
    MySQL-python-0.9.2
    mysql  Ver 12.21 Distrib 4.0.15, for suse-linux (i686)

OSX 10.3:
    SQLObject 0.5.1
    MySQL-python-0.9.2
    mysql  Ver 12.22 Distrib 4.0.16, for apple-darwin6.6 (powerpc)

Can anyone shed any light on this problem?


om

-- 
Oisin Mulvihill
Engines Of Creation

Email: oi...@en...
Work: +353 1 6791602
Mobile: +353 868191540