Here is one approach I would start with: Maybe the metadata instance used to generate the SQL thinks tables have _1 appended to some of the table names. Look at metadata.tables.keys() to see if that is the case.
If that is true, track back to how the metadata instance was built. If not, then it could be something in SQL generation. -- Mike Conley On Fri, Jun 5, 2009 at 6:15 AM, outlier <aga...@gmail.com> wrote: > > I'm not even sure where to start studying this problem but here goes: > I have an application that uses a MySQL db wrapped with SA and it > works fine. While writing new features, I've been working on a test > database. Call it 'baz'. Content with the way things are working, I > dump data from from the live instance and make a second database > 'baz2'. But when I access the this new database I get: > > OperationalError: (OperationalError) (1054, "Unknown column > 'biosequences_1.sample_id' in 'field list'") u'SELECT > samples.identifier AS samples_identifier, samples.title AS > samples_title, [...] samples.status AS samples_status, > biosequences_1.seqtype AS biosequences_1_seqtype, > bioseqannotations_1.identifier AS bioseqannotations_1_identifier, > bioseqannotations_1.name AS bioseqannotations_1_name [...] > documents_1.identifier AS documents_1_identifier [...] assays_1.source > AS assays_1_source > > Basically, SA is looking for tables with an '_1' appended to the name > that should be and is there. So where the query should look for > 'biosequences', 'bioseqannotations' and 'assays", it is instead > looking for 'biosequences_1', 'bioseqannotations_1' and 'assays_1'. > Note this doesn't happen for all my tables, only some. > > Perplexing. The db schema are the same. Restarting the instance > doesn't change anything. Shows up with Python 2.5 with SA 0.5.1, and > Python 2.4.5 with SA 0.5.2. Reverting to the old "baz" database shows > the expected and correct behaviour. > > Pointers? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
