ActiveRecord::StatementInvalid: Mysql Errorr public_indices

Rails
1

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

2

On 28 Mar, 16:17, Graham F. [email protected] 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

3

Frederick C. wrote:

On 28 Mar, 16:17, Graham F. [email protected] 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