Rails - Mar 2010 - 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
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 28 Mar, 16:17, Graham Farrell
<li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>
wrote:
> 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
> Any help greatly appricated.
>
> Graham
> --
> Posted viahttp://www.ruby-forum.com/.
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Frederick Cheung wrote:
> On 28 Mar, 16:17, Graham Farrell
<li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> 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
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.