CiviCRM Community Forums (archive)

Awesome that works!  I have however run into another issue.  We were testing this on our local machines, not our actual website.  When trying to enable the CiviRepeat on our website we have run into an error.  I have a feeling I know why this is happening, I think it is because we are using translations to change some of the default words that civicase uses into words that are used by our non profit.   Using translations however causes several database table names and column names to change (so it can store the words used in default english (en_us) as well as our own version (en_oo) Here is the error:  (I assume I will have to edit some of the civirepeat SQL scripts (which I am quite comfortable with), I was just wondering if you can provide me with any insight before I begin)

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_event_en_OO DROP FOREIGN KEY FK_civicrm_event_loc_block_id [nativecode=1347 ** 'leapywca.civicrm_event_en_oo' is not BASE TABLE]
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_event_en_OO DROP FOREIGN KEY FK_civicrm_event_loc_block_id [nativecode=1347 ** 'leapywca.civicrm_event_en_oo' is not BASE TABLE]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_event_en_OO DROP FOREIGN KEY FK_civicrm_event_loc_block_id [nativecode=1347 ** 'leapywca.civicrm_event_en_oo' is not BASE TABLE]"]
)
[/code]

Thanks for all your help, Matt!

Another question: as of last Thursday, CiviEvent Repeat was working great - once an even was added, it was immediately available to select in CiviEvent Repeat. However, as of this morning, new events are no longer visible. These new events have the same settings as the previous events we've marked as recurring: publically accessible, active, no online registration, no tell-a-friend feature.

Can't figure out why it would be working last week and not anymore... any tips on what could be causing new events to not show up in CiviEvent Repeat drop-down menu?

thanks!

One other thought:

Did you delete the original event or any of it's clones? If so, you may have deleted all of them, if the SQL queries mentioned above were never successfully executed.


(CiviCRM uses cascading deletes normally; the aforementioned SQL ALTER statements prevent this. Without it, since locations are shared by the cloned events, when you delete one, CiviCRM deletes it's location record, and then deletes every other event that used that location.)

CiviRepeat does not implement any caching. As far as I know, neither does the CiviCRM Event API.

Do the events that aren't showing up contain any special characters (quotes, or other HTML-significant punctuation) in the title?

Can you view the HTML source and see if there's anything strange about the selector input? I'm wonderin gif the events are being retrieved, but not displayed correctly for some reason.

If you have Drupal's devel module, you could also uncomment `//dvm($events);` at ~line 243 and see if your missing events are included in the output.

Also, I'm assuming that the events do show up on the normal CiviEvent managment interface; they're just missing from the CiviRepeat selector. Let me know if otherwise.

Thanks leapywca.

I've posted a patch for the event api function that would allow civirepeat to be updated with a larger (or user specified) limit:

http://issues.civicrm.org/jira/browse/CRM-5266

Did you try the steps here: http://forum.civicrm.org/index.php/topic,3329.msg44379.html#msg44379

Anyway, as I said before, there's not really any reason to use the block. I suggest you just add you own menu item that points to admin/civirepeat

Thanks for the module. Installed and activated, but two issues:
1- No block to activate in my list as far as I can see
2- If I go to the url: <site>/admin/civirepeat, it shows me the right page, but in CiviEvent: there is only a "-" or "- Select an Event -"
no event are listed even though many exist

Thanks

The files have been restored to their locations given at the top of the thread.

However, there's no guarantee the module still works with current versions of Civi. It would be much better to use CiviEvent's built-in event template tool now.