I have the following stack, which works fine on two different Linux
systems, but produces the error below on a Mac OS X 10.6.4 machine:
- Ubuntu 10.04 / Fedora 8 (works) - Mac OS X 10.6.4 (does not
work)
- freeTDS 0.82
- unixODBC 2.3.0
- pyodbc 2.1.7
- collective.lead 1.0
- SQLAlchemy 0.4.8
- Zope 2.10.11
- Plone 3.3.5
>From the debugger (bin/instance debug) I can make simple connections
and execute simple queries, both using pyodbc and sqlalchemy.
Basically, it looks like it's breaking at this line in _setup_tables
(which overrides collective.lead.Database's):
tables['WebRegions'] = Table('lut_WebRegions', metadata,
autoload=True)
Any assistance or leads on where to go next would be greatly
appreciated!
Thanks!
2010-07-14 20:40:33 ERROR Zope.SiteErrorLog
1279165233.140.347153571577
<a href="http://localhost:8080/mysite/@@database-controlpanel";>http://
localhost:8080/mysite/@@database-controlpanel</a>
Traceback (innermost last):
Module ZPublisher.Publish, line 119, in publish
Module ZPublisher.mapply, line 88, in mapply
Module Products.PDBDebugMode.runcall, line 70, in pdb_runcall
Module ZPublisher.Publish, line 42, in call_object
Module zope.formlib.form, line 769, in __call__
Module Products.Five.formlib.formbase, line 55, in update
Module zope.formlib.form, line 750, in update
Module zope.formlib.form, line 594, in success
Module plone.app.controlpanel.form, line 41, in handle_edit_action
Module mysite.content.browser.dbsettings, line 40, in _on_save
Module collective.lead.database, line 49, in invalidate
Module collective.lead.database, line 95, in _initialize_engine
Module mysite.content.db, line 61, in _setup_tables
Module sqlalchemy.schema, line 110, in __call__
Module sqlalchemy.schema, line 226, in __init__
Module sqlalchemy.engine.base, line 1275, in reflecttable
Module sqlalchemy.databases.mssql, line 570, in reflecttable
Module sqlalchemy.engine.base, line 844, in execute
Module sqlalchemy.engine.base, line 895, in execute_clauseelement
Module sqlalchemy.engine.base, line 907, in _execute_compiled
Module sqlalchemy.engine.base, line 916, in __execute_raw
Module sqlalchemy.engine.base, line 960, in _cursor_execute
Module sqlalchemy.engine.base, line 942, in _handle_dbapi_exception
ProgrammingError: (ProgrammingError) ('The SQL contains 0 parameter
markers, but 2 parameters were supplied', 'HY000') u'SELECT
[COLUMNS_1].[TABLE_SCHEMA], [COLUMNS_1].[TABLE_NAME], [COLUMNS_1].
[COLUMN_NAME], [COLUMNS_1].[IS_NULLABLE], [COLUMNS_1].[DATA_TYPE],
[COLUMNS_1].[ORDINAL_POSITION], [COLUMNS_1].
[CHARACTER_MAXIMUM_LENGTH], [COLUMNS_1].[NUMERIC_PRECISION],
[COLUMNS_1].[NUMERIC_SCALE],
[COLUMNS_1].[COLUMN_DEFAULT] \nFROM [INFORMATION_SCHEMA].[COLUMNS] AS
[COLUMNS_1] \nWHERE [COLUMNS_1].[TABLE_NAME] = ? AND
[COLUMNS_1].[TABLE_SCHEMA] = ? ORDER BY [COLUMNS_1].
[ORDINAL_POSITION]' ['lut_WebRegions', 'dbo']
> /Users/fulvio/plone/mysite/buildout/eggs/SQLAlchemy-0.4.8-py2.4.egg/sqlalchemy/engine/base.py(944)_handle_dbapi_exception()
-> del self._reentrant_error
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
