search

refinery / refinerycms-calendar

Refinery CMS Events Engine
http://refinerycms.com
69 stars 73 forks source link

ActiveRecord::StatementInvalid in Refinery/calendar/events#index #43

Open CentroDL opened 11 years ago

CentroDL commented 11 years ago

Hey everyone, I just put together a fresh RefineryCMS 2.0.10 app. Rails 3.2.13 Ruby 1.9.3p392, and running Refinerycms-calendar 2.0.4.

The backend works for creating events, but when I try and load the 'Events' Page from the front end I'm getting the following error:

SQLite3::SQLException: near "from": syntax error: SELECT "refinery_calendar_events".* FROM "refinery_calendar_events" WHERE (refinery_calendar_events.from >= '2013-08-07 04:28:26.168918') ORDER BY refinery_calendar_events.from DESC

Extracted source (around line #3): 1: <% content_for :body_content_left do %> 2:

3: <%= render @events %> 4:
5: <% end %> 6:

So far I'm just using sqlite3, I know that the Postgres compatibility fix was merged, and it looks very similar. Any advice?

parndt commented 11 years ago

It may not have been released, try the github version?

CentroDL commented 11 years ago

github version gives me the same issue unfortunately

jvalente commented 10 years ago

@CentroDL, the from column name on refinery_calendar_events table seems to be what is causing this issue since it is a sqlite keyword.

I've replace from by start here and everything worked as expected.