ActiveRecord::StatementInvalid: Mysql Errorr public_indices

Hi all,

I'm new to ROR so sorry if this is simple.

I'm using NetBeans 6.8 as my IDE and I'm trying to run tests on my shared project but I'm hitting the error beow and I can't figure out what it means.

ActiveRecord::StatementInvalid: Mysql::Error: Table 'mydatabase_test.publiic_indices' doesn't exist: DELETE FROM `publiic_indices`

I know that none of my tables have an index setup could this be the problem??

Any help greatly appricated.

Graham

Hi all,

I'm new to ROR so sorry if this is simple.

I'm using NetBeans 6.8 as my IDE and I'm trying to run tests on my shared project but I'm hitting the error beow and I can't figure out what it means.

ActiveRecord::StatementInvalid: Mysql::Error: Table 'mydatabase_test.publiic_indices' doesn't exist: DELETE FROM `publiic_indices`

I know that none of my tables have an index setup could this be the problem??

It's looking for a table called publiic_indices, which sounds like a typo to me - public_indices would be a more normal spelling. If your database does contain a public_indices table then see if there are any references to that table name or a publiic_indices.yml fixture file and try correcting the spelling.

Fred

Frederick Cheung wrote:

`publiic_indices`

I know that none of my tables have an index setup could this be the problem??

It's looking for a table called publiic_indices, which sounds like a typo to me - public_indices would be a more normal spelling. If your database does contain a public_indices table then see if there are any references to that table name or a publiic_indices.yml fixture file and try correcting the spelling.

Fred

Hi Fred,

I noticed that it was looking for the table but I knew that I didn't have a table of this name in my project. I found the offending yml file in the fixtures, it was from a MVC that one of the other guys had created then deleted but for some reason the this file wasn't deleted also.

Thanks for your help,

Graham