# ActiveRecord::StatementInvalid: Mysql Errorr public\_indices

**URL:** <https://www.ruby-forum.com/t/activerecord-mysql-errorr-public-indices/185893>\
**Category:** Rails\
**Created:** [March 28, 2010, 5:17pm UTC](https://www.ruby-forum.com/t/activerecord-mysql-errorr-public-indices/185893 "2010-03-28T17:17:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![graham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4af34b/32.png) [@graham](https://www.ruby-forum.com/u/graham)\
**Post date:** [March 28, 2010, 5:17pm UTC](https://www.ruby-forum.com/t/activerecord-mysql-errorr-public-indices/185893/1 "2010-03-28T17:17:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![graham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4af34b/32.png) [@graham](https://www.ruby-forum.com/u/graham)\
**Post date:** [March 28, 2010, 6:35pm UTC](https://www.ruby-forum.com/t/activerecord-mysql-errorr-public-indices/185893/2 "2010-03-28T18:35:12Z")

</div>

On 28 Mar, 16:17, Graham F. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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

---

<div class="post-metadata">

**Author:** ![graham](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/4af34b/32.png) [@graham](https://www.ruby-forum.com/u/graham)\
**Post date:** [March 28, 2010, 8:26pm UTC](https://www.ruby-forum.com/t/activerecord-mysql-errorr-public-indices/185893/3 "2010-03-28T20:26:11Z")

</div>

Frederick C. wrote:

> On 28 Mar, 16:17, Graham F. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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