no idea. you have any kind of isolated test case? http://stackoverflow.com/help/mcve ?
On 11/24/2015 12:17 AM, robert rottermann wrote: > Hi there, > > DB: mysql 5.5.46-0ubuntu0.12.04.2 > Python: 2.7.3 > SQLAlchemy-1.0.9-py2.7-linux-x86_64.egg > > snippet that provokes trace back: > c = tblMembership.__table__.c > records = session.query(tblMembership).filter(c['idPerson'] == > member_id).all() > > > I use a zope/plone python framework. > when I run a query as follows on the procuction server, I get an error. > When I do the same setup locally, every thing works fine. > difference between production and local: > local python 2.7.10 (remote 2.7.3) > local mysql 5.6.27-0ubuntu1 (remote 5.5.46-0ubuntu0.12.04.) > > Moreover doing the generated query that was generated by sqlalchemy > directly in mysql, it works fine. > > there is one difference I see: the GOOD sql has no backticks around > tblMembershiptype.name in the following statement: > 2015-11-23 16:19:36,835 INFO sqlalchemy.engine.base.Engine SELECT > (SELECT tblMembershiptype.name > FROM tblMembershiptype > WHERE tblMembershiptype.id = tblMembership.mtype) AS anon_1 ... > > whereas the BAD statement has backticks like so: > 2015-11-23 17:26:09 INFO sqlalchemy.engine.base.Engine SELECT (SELECT > `tblMembershiptype.name` > FROM tblMembershiptype > WHERE tblMembershiptype.id = tblMembership.mtype) AS anon_1 ... > > > this is the query done by hand, only '\n' and backticks removed and > parameter replaced.: > ------------------------------------------------------------------------------------------------------------------------ > > mysql> SELECT (SELECT tblMembershiptype.name FROM tblMembershiptype > WHERE tblMembershiptype.id = tblMembership.mtype) AS anon_1, > tblMembership.id AS tblMembership_id, tblMembership.idCompany AS > tblMembership_idCompany, tblMembership.idPerson AS > tblMembership_idPerson, tblMembership.mtype AS tblMembership_mtype, > tblMembership.request AS tblMembership_request, tblMembership.accepted > AS tblMembership_accepted, tblMembership.comment AS > tblMembership_comment, tblMembership.bemerkungen AS > tblMembership_bemerkungen FROM tblMembership WHERE > tblMembership.idPerson = 3; > +------------+------------------+-------------------------+------------------------+---------------------+-----------------------+------------------------+-----------------------+---------------------------+ > > | anon_1 | tblMembership_id | tblMembership_idCompany | > tblMembership_idPerson | tblMembership_mtype | tblMembership_request | > tblMembership_accepted | tblMembership_comment | > tblMembership_bemerkungen | > +------------+------------------+-------------------------+------------------------+---------------------+-----------------------+------------------------+-----------------------+---------------------------+ > > | company_10 | 531 | 31419 | 3 | 4 | > 2010-09-08 | NULL | NULL | > NULL | > +------------+------------------+-------------------------+------------------------+---------------------+-----------------------+------------------------+-----------------------+---------------------------+ > > 1 row in set (0.00 sec) > > this is the traceback. : > ------------------------------- > 2015-11-23 17:26:09 INFO sqlalchemy.engine.base.Engine SELECT (SELECT > `tblMembershiptype.name` > FROM tblMembershiptype > WHERE tblMembershiptype.id = tblMembership.mtype) AS anon_1, > `tblMembership`.id AS `tblMembership_id`, `tblMembership`.`idCompany` AS > `tblMembership_idCompany`, `tblMembership`.`idPerson` AS > `tblMembership_idPerson`, `tblMembership`.mtype AS > `tblMembership_mtype`, `tblMembership`.request AS > `tblMembership_request`, `tblMembership`.accepted AS > `tblMembership_accepted`, `tblMembership`.comment AS > `tblMembership_comment`, `tblMembership`.bemerkungen AS > `tblMembership_bemerkungen` > FROM `tblMembership` > WHERE `tblMembership`.`idPerson` = %s > 2015-11-23 17:26:09,265 INFO sqlalchemy.engine.base.Engine (3L,) > 2015-11-23 17:26:09 INFO sqlalchemy.engine.base.Engine (3L,) > 2015-11-23 17:26:09 ERROR Zope.SiteErrorLog 1448295969.270.343287466397 > http://www.energie-cluster.ch/ecweb5/de/ecweb_site/uber-uns/mitgliedschaft/start-registration > > Traceback (innermost last): > Module ZPublisher.Publish, line 70, in publish > Module ZPublisher.mapply, line 77, in mapply > Module ZPublisher.Publish, line 48, in call_object > Module energiecluster.membership.browser.registration, line 316, in > __call__ > Module energiecluster.membership.browser.member, line 394, in > getMembershiptypeByPersonId > Module energiecluster.membership.Membership, line 412, in getMembership > Module energiecluster.membership.Membership, line 390, in _getMembership > Module sqlalchemy.orm.query, line 2423, in all > Module sqlalchemy.orm.query, line 2571, in __iter__ > Module sqlalchemy.orm.query, line 2586, in _execute_and_instances > Module sqlalchemy.engine.base, line 914, in execute > Module sqlalchemy.sql.elements, line 323, in _execute_on_connection > Module sqlalchemy.engine.base, line 1010, in _execute_clauseelement > Module sqlalchemy.engine.base, line 1146, in _execute_context > Module sqlalchemy.engine.base, line 1341, in _handle_dbapi_exception > Module sqlalchemy.util.compat, line 199, in raise_from_cause > Module sqlalchemy.engine.base, line 1139, in _execute_context > Module sqlalchemy.engine.default, line 450, in do_execute > Module MySQLdb.cursors, line 205, in execute > Module MySQLdb.connections, line 36, in defaulterrorhandler > OperationalError: (_mysql_exceptions.OperationalError) (1054, "Unknown > column 'tblMembershiptype.name' in 'field list'") [SQL: u'SELECT (SELECT > `tblMembershiptype.name` \nFROM tblMembershiptype \nWHERE > tblMembershiptype.id = tblMembership.mtype) AS anon_1, > `tblMembership`.id AS `tblMembership_id`, `tblMembership`.`idCompany` AS > `tblMembership_idCompany`, `tblMembership`.`idPerson` AS > `tblMembership_idPerson`, `tblMembership`.mtype AS > `tblMembership_mtype`, `tblMembership`.request AS > `tblMembership_request`, `tblMembership`.accepted AS > `tblMembership_accepted`, `tblMembership`.comment AS > `tblMembership_comment`, `tblMembership`.bemerkungen AS > `tblMembership_bemerkungen` \nFROM `tblMembership` \nWHERE > `tblMembership`.`idPerson` = %s'] [parameters: (3L,)] > > > thanks for any hints where to locate the problem > robert > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
