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 [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 -~----------~----~----~----~------~----~------~--~---
