Module: Google Calendar

Quote
LostBit
1. repetition of events?

Something to add to the todo list. thanks for the suggestion.

Quote

2. When i post a event by google web, i can't see in forum, why?

This module was orginally conceived as way of linking topics to events. I never really considered adding calendar event entered on Google to the seven day event listing. Another suggestion added to the list.

Quote

3. I del the event's topic in forum and i view the event in Event List, why?

Deleting the topic should remove the event from the Google calendar and in turn from the event listing. Can you confirm if the event is removed from the calendar?

Quote

4. When i post a topic with event, in event list and in gmail have +1 hour, why?

The topic will always be posted based on your time zone as Phorum sees it. Your calendar may be in a different time zone. Is it possible you still have daylight savings enabled in the Control Center -> Forum Settings page?

Quote

5. You use cache for this mod?

I use as much caching as possible for this mod. Because of differences in timezone, I can only cache per timezone and only if there have been no event changes and only for the current week (in the case of a weekly event listing) or the current day (in the case of the "next seven days" event listing).

---

Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald

Quote

Quote

3. I del the event's topic in forum and i view the event in Event List, why?

Deleting the topic should remove the event from the Google calendar and in turn from the event listing. Can you confirm if the event is removed from the calendar?

Yes, all OK!

Quote

Quote

4. When i post a topic with event, in event list and in gmail have +1 hour, why?

The topic will always be posted based on your time zone as Phorum sees it. Your calendar may be in a different time zone. Is it possible you still have daylight savings enabled in the Control Center -> Forum Settings page?

The timezone in google and in phorum is the same, but when i post a event in forum, this event have +1 hour in google, in list and in topic.

The real timezone in my country is +1, but if i have +1 in general setting of phorum, all time is +1 in phorum. For that, In phorum and in google my timezone is to 0, but the timezone of the operating system is +1, problem with this?

What is daylight savings ? i can't see it in general setting.



Edited 1 time(s). Last edit at 01/16/2009 04:19AM by LostBit.

The Daylight Savings setting is actually in the forum itself, in your Control Center -> Forum Settings page.

Would you be able to give me a link to check it out myself? (PM if necessary)

---

Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald

Hi!

I'm having a bit of a problem and would be grateful of any help.

I have been using Google Calendar for a week or so. It is a superb piece of software - thank you! - and has performed faultlessly.

On my website I use a large number of mods, but I have replicated the problem on a development PC just using Phorum version 5.2.9a and Google Calendar version 5.2.1.00.RC.2, and by restoring a copy of the MySQL database from the server.

The Google Calendar settings are:

Who can post events: Anyone who can create a new topic
Google's HTML code for embedding your calendar:

<iframe src="[www.google.com]; style="border: 0" width="800" height="600" frameborder="0" scrolling="no"></iframe>

Show event data in the message body: Ticked
Show a seven day event listing on the page: Show a listing of the next seven days' events
Show the event listing automatically: Ticked
Pages on which to show the event listing: Control Ticked, Index Ticked
Maximum number of events to show in a single day: 5

The Database Integrity and System Sanity Checks run normally.

When Phorum outputs the "Sorry, a Phorum database error occurred. Please try again later!" message as in the attached file. I can access the admin page, turn off Google Calendar, and Phorum then performs normally.

The only information I have about how this occurred is from an email I received - here's a part of it:

"I may have crashed the database. I was attempting to post a calendar entry from Private Messages, but could not see the link. When I had noticed it,before, it was while replying to a PM. Therefore, I sent the message to myself. I went to reply, but the prompt still wasn’t there, so I backed out of the message. When I tried to go to the Home page, I got the following message, of which I have only copied the beginning - it goes on for a long time"...

Could anyone shed any light on this, please?

TIA, Kronalias

been trying to find the cause of this problem but so far i am unsuccessful.

so i create an event, everything goes to google correctly but the forum shows the date as 12/31/1969.

is this a getdate() issue? mysql?

any help would be appreciated. :)

Can I get a link to see this in action? PM if need be.

---

Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald

upgrade to php5 corrected the issue.

I have completed v5.2.1.00.RC.3 of this module with the following changes:

- Bugfix: In category mode the calendar event creation option was added to the new PM form. Thanks go to Phorum user Kronalias for pointing out this bug.

- Enhancement: Support added for the Simple Rounded template.

- Bugfix: Unnecessary cache data could have exceeded the storage limit for the database data field. Thanks go to Phorum user Kronalias for reporting this bug.

- Bugfix: Failed to declare the js_event_data array which raised a PHP notice whenever there were no events to display. Thanks go to Phorum user jotech for pointing out this bug.

- Enhancement: Disabled creating new color codings until after authentication has been provided.

---

Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald

first off, awesome mod.. thank you for this!

i do have one issue though.. i have everything working BUT the 7 day list at the top of the pages i've selected. It's not showing anything, but on the calendar itself i see the events, and i can see the info at the top of the event message inside the forum. in the US, so i don't know why this is happening...

any idea? thanks!

here's the event log:


Additional details:

Message:

PHP notice: Undefined variable: js_event_data

PHP notice generated at /home/sirfice/vhost/projekt/htdocs/forum/mods/google_calendar/listings_bin/next_seven_event_listings_start_output.php:306

Back trace:

Function eval called at
{path to Phorum}/mods/google_calendar/listings_bin/next_seven_event_listings_start_output.php:306
----
Function include_once called at
{path to Phorum}/mods/google_calendar/google_calendar.php:413
----
Function phorum_mod_google_calendar_start_output called
----
Function call_user_func called at
{path to Phorum}/common.php:1566
----
Function phorum_hook called at
{path to Phorum}/common.php:1284
----
Function phorum_output called at
{path to Phorum}/include/index_new.php:216
----
Function include_once called at
{path to Phorum}/index.php:84
----

Request info:

HTTP_HOST = www.projektmke.com
HTTP_REFERER = [www.projektmke.com]
REQUEST_URI = /forum/index.php



Edited 1 time(s). Last edit at 06/20/2009 02:58PM by sir fice.

i think i might have something on this.. events adding to the calendar are correct, but if you look at a post, it's showing the calendar event details with a date of 12/31/1969, which would explain why it's not showing up in the 7 days events.. i AM using an older version of mysql (4.1.21) and i'm thinking that's the problem as hugs upgraded and the problem was fixed. i don't necessarily have that luxury right now.. any idea on a fix?

here is a link to a post with calendar event stuff showing the wrong date:
[www.projektmke.com]



something else now too: i deleted/re-uploaded the google calendar mod. reset it uncommenting the dev stuff to start all over. the events/posts i had done previously are still holding data, which i cannot change. in event log, i get this error:

Quote

Google returned this error: info@projektmke.com does not have read privileges on the calendar owned by projektmke.com_jrpkm2gkojtrmq9ug30sall488@group.calendar.google.com.

that address is the owner of the calendar and does have permissions.. i'd love it if i could just have the original data removed from the posts and start over because posting new events/editing old posts with date stuff (that didn't have it previously) works just fine.



Edited 2 time(s). Last edit at 06/22/2009 01:23PM by sir fice.