Good to know. I'll be more careful with when guessing at MySQL syntax next time. Sorry for the inconvenience. :)
On 2/11/06, Bob Silva <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
