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
|