[SQLObject] SQLObject and mysql 4.0+ problem...
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Oisin M. <oi...@en...> - 2003-12-02 15:15:35
|
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 |