Hi Wilson, The problem was with the comment in front of the table. In MySQL, comments starting with -- need a whitespace character following it.
Bob Silva http://www.railtie.net/ > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:rails-core- > [EMAIL PROTECTED] On Behalf Of Wilson Bilkovich > Sent: Friday, February 10, 2006 6:38 AM > To: rails-core@lists.rubyonrails.org > Subject: Re: [Rails-core] AR Unit Tests > > On 2/10/06, Bob Silva <[EMAIL PROTECTED]> wrote: > > > > test_lock_column_name_existing(LockingTest): > > > > ActiveRecord::StatementInvalid: Mysql::Error: #42S02Table > > 'activerecord_unittest.legacy_things' doesn't exist: DELETE > > FROM legacy_things > > This is a test I wrote. I don't use MySQL, unfortunately, so I can > only hope that I got the definition syntax right. This is what is in > the mysql.sql file.. is this correct? > > CREATE TABLE `legacy_things` ( > `id` int(11) NOT NULL auto_increment, > `tps_report_number` int(11) default NULL, > `version` int(11) NOT NULL default 0, > PRIMARY KEY (`id`) > ) TYPE=InnoDB; > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
