[Zope] Odd SQL errors- HELP

[Andrew Kenneth Milton]

+-------[ Jon Franz ]----------------------
|
| +-------+--------------+------+-----+---------+----------------+
| | Field | Type         | Null | Key | Default | Extra          |
| +-------+--------------+------+-----+---------+----------------+
| | id    | mediumint(8) |      | PRI | 0       | auto_increment |
| | value | varchar(32)  |      |     |         |                |
| +-------+--------------+------+-----+---------+----------------+
| 
| Now, at first i thought it was the field name of 'id' causing 
| the problem, but now I've tried renaming the field and its still a no-go.
| I can do queries such as 'select value from reason' fine, but if i select
| * or the id field, it chokes... Looking through the mailinglist archives,
| I think its a 'mapping error' where the ZmySQLDA doesn't properly map
| this type of field for some reason... can someone help me solve this
| problem?

The problem is likely to be your mediumint field, which is probably not
mapped to a python type.

You should let us know what version of MySQL DA you have.
Also be aware that the DA is not a part of Zope, and has been contributed
by a 3rd party.

Anyway if you want to have a crack at fixing it, look in the
ZMySQLDA directory in a file called db.py. You could add an entry with

"medium int":"i" 

or permutations of the above. (You can test it I can't, so little point in 
me doing it when its this simple).

-- 
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   | 
ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|