harvesthq/ranked-model — Issue #18: Error creating records
Author: anathematic
Created: 2012-01-30 21:47:40+00:00
State: open

Hi guys,
I've just had a stab at using ranked-model on 1.9.2 + Rails 3.0.4 with little success, hopefully I'm missing something simple here:

ActiveRecord::StatementInvalid: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1: SELECT id, waitlist_position FROM `applications` ORDER BY # ASC LIMIT 1

This is for when I attempt to create an Application in console.

class Application < ActiveRecord::Base
include RankedModel
ranks :waitlist_position
end

I've nuked everything out the terminal / made sure I'm using a medinteger (vs. plain integer) with no luck.
Also tried the gem vs. master on here.

Cheers,
Thomas