#43: resetting Rails schema_migrations table

Solved!
on May 09, 2009, 02:04 AM UTC   —   from   148c663fd665c53518538e093ce3c2ab_small kueda    ( 2,738 views )
I just ran a failing migration, and in a fit of panic, deleted all the rows from my schema migrations table. That's a pretty dumb thing to do.
Tags: databases, Rails, SQL
1 solution | 0 references     Add Solution | Add Reference    

#34: Indexing the results of an nested set ancestry query

on April 15, 2009, 08:59 PM UTC   —   from   148c663fd665c53518538e093ce3c2ab_small kueda    ( 602 views )
I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt...
Tags: sphinx, indexes, search, ThinkingSphinx, SQL, Rails
0 solutions | 0 references     Add Solution | Add Reference    

#26: Switch a MySQL table charset to UTF8

Solved!
on March 16, 2009, 11:17 PM UTC   —   from   92049143cabb7ba896d7c06e19906303_small yliu    ( 1,113 views )
I would like to switch a MySQL table or database to the UTF-8 character set, after it has already been created as Latin1.
Tags: MySQL, SQL, syntax, programming, UTF8
1 solution | 1 reference     Add Solution | Add Reference