RE: [Zope] ZMysqlDA error, and a workaround
doh, I was the one running the odd version - 1.1.3 as opposed to the newer 1.2 - I guess I never updated this when I updated the full zope install. The new version looks like it would of been much easier to fix, if it had the problem in the first place! -Original Message- From: Jon Franz Sent: Monday, October 09, 2000 7:07 PM To: '[EMAIL PROTECTED]'; Jon Franz Cc: [EMAIL PROTECTED] Subject: RE: [Zope] ZMysqlDA error, and a workaround Wow, that looks very diffrent from my ZMySQLDA, what version are you running? I just got mine to work, I had to mod the def section in the db.py and some of the code in the MySQLmodule.c file - I want to make it available for download and whatnot, but I need to look through the setup script (since it generated the .c file, I think, or at least moded it) and make sure what I did it integrated into the source at that stage... -Original Message- From: Steve Spicklemire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 7:00 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [Zope] ZMysqlDA error, and a workaround I'm guessing it's in db.py in ZMySQLDA, I had to do the same thing with DECMIAL as shown here, I didn't post that since I'm not sure most folks would want this behavior but you should be able to do the same with MEDIUMINT: class DB: defs={ FIELD_TYPE.CHAR: "i", FIELD_TYPE.DATE: "d", FIELD_TYPE.DATETIME: "d", FIELD_TYPE.DECIMAL: "n", FIELD_TYPE.DOUBLE: "n", FIELD_TYPE.FLOAT: "n", FIELD_TYPE.INT24: "i", FIELD_TYPE.LONG: "i", FIELD_TYPE.LONGLONG: "l", FIELD_TYPE.SHORT: "i", FIELD_TYPE.TIMESTAMP: "d", FIELD_TYPE.TINY: "i", FIELD_TYPE.YEAR: "i", } conv={ FIELD_TYPE.TINY: int, FIELD_TYPE.SHORT: int, FIELD_TYPE.LONG: int, FIELD_TYPE.FLOAT: float, FIELD_TYPE.DOUBLE: float, FIELD_TYPE.LONGLONG: long, FIELD_TYPE.INT24: int, FIELD_TYPE.DECIMAL: float, FIELD_TYPE.YEAR: int } -steve >>>>> "Jon" == Jon Franz <[EMAIL PROTECTED]> writes: Jon> This is additional info for the error mentioned in my last Jon> email. If I alter the column definitions to use 'int' as Jon> opposed to 'mediumint', then everything works fine! So, its Jon> the 'mediumint' type that isnt mapping properly... where Jon> would i fix this? Jon> ___ Zope maillist Jon> - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope Jon> ** No cross posts or HTML encoding! ** (Related lists - Jon> http://lists.zope.org/mailman/listinfo/zope-announce Jon> http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] ZMysqlDA error, and a workaround
Wow, that looks very diffrent from my ZMySQLDA, what version are you running? I just got mine to work, I had to mod the def section in the db.py and some of the code in the MySQLmodule.c file - I want to make it available for download and whatnot, but I need to look through the setup script (since it generated the .c file, I think, or at least moded it) and make sure what I did it integrated into the source at that stage... -Original Message- From: Steve Spicklemire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 7:00 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [Zope] ZMysqlDA error, and a workaround I'm guessing it's in db.py in ZMySQLDA, I had to do the same thing with DECMIAL as shown here, I didn't post that since I'm not sure most folks would want this behavior but you should be able to do the same with MEDIUMINT: class DB: defs={ FIELD_TYPE.CHAR: "i", FIELD_TYPE.DATE: "d", FIELD_TYPE.DATETIME: "d", FIELD_TYPE.DECIMAL: "n", FIELD_TYPE.DOUBLE: "n", FIELD_TYPE.FLOAT: "n", FIELD_TYPE.INT24: "i", FIELD_TYPE.LONG: "i", FIELD_TYPE.LONGLONG: "l", FIELD_TYPE.SHORT: "i", FIELD_TYPE.TIMESTAMP: "d", FIELD_TYPE.TINY: "i", FIELD_TYPE.YEAR: "i", } conv={ FIELD_TYPE.TINY: int, FIELD_TYPE.SHORT: int, FIELD_TYPE.LONG: int, FIELD_TYPE.FLOAT: float, FIELD_TYPE.DOUBLE: float, FIELD_TYPE.LONGLONG: long, FIELD_TYPE.INT24: int, FIELD_TYPE.DECIMAL: float, FIELD_TYPE.YEAR: int } -steve >>>>> "Jon" == Jon Franz <[EMAIL PROTECTED]> writes: Jon> This is additional info for the error mentioned in my last Jon> email. If I alter the column definitions to use 'int' as Jon> opposed to 'mediumint', then everything works fine! So, its Jon> the 'mediumint' type that isnt mapping properly... where Jon> would i fix this? Jon> ___ Zope maillist Jon> - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope Jon> ** No cross posts or HTML encoding! ** (Related lists - Jon> http://lists.zope.org/mailman/listinfo/zope-announce Jon> http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] ZMysqlDA error, and a workaround
I'm guessing it's in db.py in ZMySQLDA, I had to do the same thing with DECMIAL as shown here, I didn't post that since I'm not sure most folks would want this behavior but you should be able to do the same with MEDIUMINT: class DB: defs={ FIELD_TYPE.CHAR: "i", FIELD_TYPE.DATE: "d", FIELD_TYPE.DATETIME: "d", FIELD_TYPE.DECIMAL: "n", FIELD_TYPE.DOUBLE: "n", FIELD_TYPE.FLOAT: "n", FIELD_TYPE.INT24: "i", FIELD_TYPE.LONG: "i", FIELD_TYPE.LONGLONG: "l", FIELD_TYPE.SHORT: "i", FIELD_TYPE.TIMESTAMP: "d", FIELD_TYPE.TINY: "i", FIELD_TYPE.YEAR: "i", } conv={ FIELD_TYPE.TINY: int, FIELD_TYPE.SHORT: int, FIELD_TYPE.LONG: int, FIELD_TYPE.FLOAT: float, FIELD_TYPE.DOUBLE: float, FIELD_TYPE.LONGLONG: long, FIELD_TYPE.INT24: int, FIELD_TYPE.DECIMAL: float, FIELD_TYPE.YEAR: int } -steve > "Jon" == Jon Franz <[EMAIL PROTECTED]> writes: Jon> This is additional info for the error mentioned in my last Jon> email. If I alter the column definitions to use 'int' as Jon> opposed to 'mediumint', then everything works fine! So, its Jon> the 'mediumint' type that isnt mapping properly... where Jon> would i fix this? Jon> ___ Zope maillist Jon> - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope Jon> ** No cross posts or HTML encoding! ** (Related lists - Jon> http://lists.zope.org/mailman/listinfo/zope-announce Jon> http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )