[zope2-tracker] [Bug 401988] [NEW] z sql method gives inexplicable programming error

[Launchpad Bug Tracker]

You have been subscribed to a public bug:

When testing a common Z SQL Method with MySQL 5.1.36 on Mac OS X 10.5.7
(I don't know wheather this does metter) I get this error:

Site Error

An error was encountered while publishing this resource.

ProgrammingError
(Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: 'ascii' codec can't encode character u'\xdc' in position 3378: ordinal not in range(128))Traceback (innermost last): Module ZPublisher.Publish, line 202, in publish_module_standard Module ZPublisher.Publish, line 150, in publish Module plone.app.linkintegrity.monkey, line 21, in zpublisher_exception_hook_wrapper Module Zope2.App.startup, line 252, in __call__ Module ZPublisher.Publish, line 119, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 42, in call_object Module Shared.DC.ZRDB.DA, line 343, in manage_test Module Shared.DC.ZRDB.DA, line 321, in manage_test Module Shared.DC.ZRDB.DA, line 500, in __call__ - Module Products.ZMySQLDA.db, line 284, in query ProgrammingError: (see above)

The query is "SELECT * FROM mytable WHERE col1='foo' AND col2='bar'". If I leave "AND col2='bar'" out, it works. Even if I use non-existing table and column names I get the same error.
My Zope version is 2.11.3, python 2.4.6
On this Zope instance is running Plone but my query doesn't use anything of Plone's methods.

** Affects: zope2
     Importance: Undecided
         Status: New

-- 
z sql method gives inexplicable programming error
https://bugs.launchpad.net/bugs/401988
You received this bug notification because you are a member of Zope 2 Developers, which is subscribed to Zope 2.