When an event has ended, it should appear in the archives list, even if its start date is included in current month.

Now, it disappears from the index view because it has ended, but it doesn't yet appear in the archives list because of how the scope is defined in event model.

So here is my proposed fix:

It think this:

    def self.for_archive_list
        with_exclusive_scope { order('start_at DESC').where(['end_at < ?', Time.now.beginning_of_month]) }
    end

Should be replaced by this:

    def self.for_archive_list
        with_exclusive_scope { order('start_at DESC').where(['end_at < ?', Time.now]) }
    end

On the /calendar/events page and the /calendar/events/archive page, the events are listed in descending order. This makes sense for the archive events page but doesn't really make sense for the upcoming events page.

Does it make sense to change the events (/calendar/events) page to use ascending order?

If not, I can write a patch to create an initializer for the calendar gem that includes the event page ordering and add it to the install generator.

The model doesn't inherit ActiveRecord::Base which means it does not do ARel at all.

Sadface

Getting this error when after installing Calendars and trying to view the page 'Venues' it creates.

undefined method `each' for nil:NilClass

1: <% content_for :body_content_left do %>
2:

3: <% @venues.each do |venue| %>
4:
• 
  5: <%= link_to venue.name, refinery.calendar_venue_path(venue) %>
  6:

Could not find gem 'refinerycms-calendar (~> 2.1.0) ruby' in any of the gem sources listed in your Gemfile or available on this machine.

Could not find gem 'refinerycms-calendar (~> 3.0) ruby' in any of the gem sources listed in your Gemfile or available on this machine.

If I try with older version: 2.0.4
https://rubygems.org/gems/refinerycms-calendar

then the problem:
refinerycms (~> 3.0) ruby depends on
refinerycms-images (= 3.0.4) ruby depends on
refinerycms-core (= 3.0.4) ruby

refinerycms-calendar (>= 2.0.4, ~> 2.0) ruby depends on
  refinerycms-core (~> 2.0.3) ruby

I would like to use this extension. Thanks!

Hi,

I'm putting a calendar grid on my refinery/calendar/events/index page. The grid works great, but when I attempt to place links for navigating to the previous or next month, I receive routing errors:

in view:

=link_to "<", date: @date.prev_month

begets exception:

No route matches {:date=>Tue, 09 Oct 2012, :locale=>:en, :controller=>"refinery/calendar/events"}

How should I be referencing this and / or editing config/routes.rb?

Thanks,

Steve

I am trying out the calendar gem and have run across an issue with the event edit page. The datetime fields for from and to are appearing as only textfields. Looking at the form view, they have the class datetime_range which suggests some kind of date picker. Is the missing date picker a problem with the gem or a problem with my installation of refinery?

Dependabot can't resolve your Ruby dependency files.

As a result, Dependabot couldn't update your dependencies.

The error Dependabot encountered was:

Bundler::VersionConflict with message: Bundler could not find compatible versions for gem "bundler":
  In Gemfile:
    quiet_assets was resolved to 1.0.0, which depends on
      rails (~> 3.1) was resolved to 3.2.22.5, which depends on
        bundler (~> 1.0)

  Current Bundler version:
    bundler (2.2.15)

Your bundle requires a different version of Bundler than the one you're running.
Install the necessary version with `gem install bundler:1.17.3` and rerun bundler using `run.rb _1.17.3_`

If you think the above is an error on Dependabot's side please don't hesitate to get in touch - we'll do whatever we can to fix it.

View the update logs.

Hi,

I got this error when creating my first event:

ActionView::Template::Error (PG::Error: ERROR: non-integer constant in ORDER BY
LINE 1: ...ents".* FROM "refinery_calendar_events" ORDER BY 'from' DES...
^
: SELECT "refinery_calendar_events".* FROM "refinery_calendar_events" ORDER BY 'from' DESC LIMIT 20 OFFSET 0):
1:

2: <%= render :partial => 'event', :collection => @events %>
3:

refinerycms v3.0.6
refinery-calendar v3.0.0

seeds.rb has code to generate page parts for events and venues but this results in refinery_page_parts with values for slug = 'title_body_slug_body' and title = '{:title=>"Body", :slug=>"body"}'

I think this code ...
Refinery::Pages.default_parts.each_with_index do |default_page_part, index| page.parts.create(:title => default_page_part, :body => nil, :position => index) end

should be ...
Refinery::Pages.default_parts.each_with_index do |default_page_part, index| page.parts.create(:title => default_page_part[:title], :slug => default_page_part[:slug], :body => nil, :position => index) end

because it's DateTime, not just Date.... note to self

Not sure where we're up to in terms of 2.0 ready'ness!

But just tried it out on a clean refinery 2.0.4 & postgres install:
Not knowing what to expect as trying this gem out for the first time, but is this helps anyone?

• new 'venues' menu item appeared on the front end,
• clicking this cause it to fall over with the following (even after venue data is in the db)

ActionView::Template::Error (undefined method each' for nil:NilClass): 1: <% content_for :body_content_left do %> 2: <ul id="venues"> 3: <% @venues.each do |venue| %> 4: <li> 5: <%= link_to venue.name, refinery.calendar_venue_path(venue) %> 6: </li> /Users/rlarcombe/.rvm/gems/[email protected]/bundler/gems/refinerycms-calendar-1587e0550295/app/views/refinery/calendar/venues/index.html.erb:3:inblock in ___sers_rlarcombe__rvm_gems_ruby_______p____refinery____bundler_gems_refinerycms_calendar_____e________app_views_refinery_calendar_venues_index_html_erb__896554352859260886_70126231033580'
actionpack (3.2.3) lib/action_view/helpers/capture_helper.rb:40:in block in capture' actionpack (3.2.3) lib/action_view/helpers/capture_helper.rb:187:inwith_output_buffer'

• next tried loggin in adding a venue, seem to save ok
• then moved to add an event, fell over with this upon trying to save.

ActionView::Template::Error (PG::Error: ERROR: non-integer constant in ORDER BY
LINE 1: ...ents".* FROM "refinery_calendar_events" ORDER BY 'from' DES...
^
: SELECT "refinery_calendar_events".* FROM "refinery_calendar_events" ORDER BY 'from' DESC LIMIT 20 OFFSET 0):
1:

2: <%= render :partial => 'event', :collection => @events %>
3:

Assume i've either missed something or it's not yet ready for prime time?

Are there any plans to update this Gem to support Refinery 3.x? Also, are there any known compatibility issues using the latest stable release of the calendar with Refinery 3?

Is it planned to upgrade?
I can't get past bundle update.

why public routes are ../connect/events.. and not directly ../events/.. or ../calendar?
for example

                   calendar_events_archive GET     /connect/events/archive(.:format)                         refinery/calendar/events#archive
                            calendar_events GET     /connect/events(.:format)                                 refinery/calendar/events#index
                             calendar_event GET     /connect/events/:id(.:format)                             refinery/calendar/events#show

In seed file is created "Venues" page instead page "Events" and I don't know if that is feature or just unfinished..
I don't want public page "Venues" at all.. (maybe this would be configurable or something like that?)
And last observation: admin page for creating/edit event seems to be unfinished too.

@joemsak do you want pull requests or some time for reviewing?

Btw i thinkin about writing extension to calendar ( for facebook events or doodle.com), but still not decided how

I followed the install as described here in a brand new refinery install, and when i click the newly added "venues" link in the site, i get:

page not found...

Processing by Refinery::PagesController#show as HTML
Parameters: {"path"=>"calendar/venues", "locale"=>:en}
....

Filter chain halted as :find_page rendered or redirected
Completed 404 Not Found in 50ms (Views: 40.3ms | ActiveRecord: 4.6ms)

i've tried this on two new refinery apps, same result.

anyone else seen this, or know what to do?

Hi,

How do I override this? I want to add a calendar grid to my app.

Thanks,

Steve

Is there a branch that supports refinery 2.1.0?

Hello,

Could you bump the refinerycms-calendar version to 2.0.x in http://refinerycms.com/engines ?

Thanks.

Would you mind adding a License file to your plugin?^^ My lawyers wont let me use source without a license of some sore. Thanks!

https://github.com/refinery/refinerycms-calendar/blob/master/app/controllers/refinery/calendar/events_controller.rb#L5

sqlite cant prepare sql statement, should wrap column in quotes

SQLite3::SQLException: near "from": syntax error: SELECT "refinery_calendar_events".* FROM "refinery_calendar_events" WHERE (refinery_calendar_events.from >= '2013-02-08 20:11:44.379436') ORDER BY refinery_calendar_events.from DESC

Calendar month view to see all events in month in grid and also be able to flip through months would be nice.

Hello,
In my application event description contains characters that break the calendar event and it does not get loaded in iCal. How can I modify the field values before they are exported as .ics file?

Sample event that breaks:
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//iCalendar export//EN
BEGIN:VEVENT
UID:[email protected]
SUMMARY:IV MEDITECH 2014
DESCRIPTION:BOGOTA, COLOMBIA - BOGOTA'S INTERNATIONAL HEALTH FAIR 2014

The International Business and Exhibition Center of Bogota – Corferias, and the Colombian Association of Hospitals and Clinics – ACHC, with the support of the Colombian Dental Federation welcome you to IV Meditech and III Odontotech.&#160;

In its previous version in 2012, MEDITECH received 254 exhibitors, 13.717 visitors on 7.329 m2 of exhibition area. It is the most important event for the health sector in Colombia, and an ideal place to market, promote or launch your brand. It will also enable visitors to strengthen existing business contacts as well as establishing new ones.&#160;

LOCATION:BOGOTA- CORFERIAS
URL:https://www.wtca.org/calendar/events/iv-meditech-2014--2
STATUS:CONFIRMED
CLASS:PUBLIC
DTSTART:20140812T080000Z
DTEND:20140815T200000Z
DTSTAMP:20140812T080000Z
END:VEVENT
END:VCALENDAR

&#160; are character sequence that breaks the invite.

Thanks

Hi I'm new to RoR and Refinery. I have a successful install of refinery and it's successfully running on Heroku. I installed the refinerycms-calendar and ran the db:migrate. In the admin there was an events tab. I clicked on that and I was given this error message:

SQLite3::SQLException: no such table: events: SELECT "events".* FROM "events" WHERE (end_at < '2012-01-27 23:57:03.070385') ORDER BY start_at DESC

Thanks!

-Rebekah

Hey,

Thanks for your efforts,

I'm having the following scenario:

I want the anonymous/registered users to be able to submit events for moderation queue and the admin should approve them before publishing. Any ideas how to do that?

Thanks!

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:

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