gistfile1.txt

## Error (only appears in rspec)

Mysql::Error: Unknown column 'refname' in 'where clause': SELECT * FROM `device_profiles`     WHERE (refname = 'pc')  LIMIT 1

## Schema

t.string   "refname",           :limit => 16

## SQL

mysql> SELECT * FROM `device_profiles`     WHERE (refname = 'pc')  LIMIT 1;
+----+--------------+---------+------------------+-------------------+---------------------+---------------------+------------+---------------+-----------------+----------+---------+
| id | manufacturer | model   | resolution_width | resolution_height | created_at          | updated_at          | user_agent | playback_type | playback_format | platform | refname |
+----+--------------+---------+------------------+-------------------+---------------------+---------------------+------------+---------------+-----------------+----------+---------+
| 37 | reeplay      | Generic |              512 |               384 | 2008-07-29 15:16:12 | 2008-07-29 15:16:12 | NULL       | streaming     | flvplayer       | default  | pc      | 
+----+--------------+---------+------------------+-------------------+---------------------+---------------------+------------+---------------+-----------------+----------+---------+
1 row in set (0.00 sec)

## "Failing" Ruby code

def self.reference( ref )
  find( :first, :conditions => ['refname = ?', ref] )
end