Announcing Calendar 1.0

[calguy1000]

Here's the latest status of the translations.

Hey, I did warn people that a new version of Calendar was coming out.
At least 8 languages were updated..... why not french? german?

robl@ws:/home/website/cms_test/svn/modules/Calendar$ ls -lt lang/ext
total 484
-rw-r--r-- 1 48 48 24588 2008-11-02 17:12 sk_SK.php
-rw-r--r-- 1 48 48 21547 2008-10-24 10:28 it_IT.php
-rw-r--r-- 1 48 48 23154 2008-10-24 10:28 nb_NO.php
-rw-r--r-- 1 48 48 24207 2008-10-24 10:28 pt_PT.php
-rw-r--r-- 1 48 48 23332 2008-10-20 08:48 cs_CZ.php
-rw-r--r-- 1 48 48 19589 2008-10-20 08:48 nl_NL.php
-rw-r--r-- 1 48 48 23142 2008-10-19 09:23 da_DK.php
-rw-r--r-- 1 48 48 24955 2008-10-19 09:23 sv_SE.php
-rw-r--r-- 1 48 48 19015 2008-10-13 11:53 es_ES.php
-rw-r--r-- 1 48 48 20604 2008-08-08 07:56 lt_LT.php
-rw-r--r-- 1 48 48 28528 2008-07-02 09:09 de_DE.php
-rw-r--r-- 1 48 48 23837 2008-07-02 09:09 fi_FI.php
-rw-r--r-- 1 48 48 24962 2008-07-02 09:09 pl_PL.php
-rw-r--r-- 1 48 48 24794 2008-06-17 08:28 ro_RO.php
-rw-r--r-- 1 48 48 33655 2008-05-08 11:14 fr_FR.php
-rw-r--r-- 1 48 48 26827 2008-02-22 16:35 hu_HU.php
-rw-r--r-- 1 48 48 25660 2008-01-23 20:08 ru_RU.php
-rw-rw-r-- 1 48 48  9725 2006-09-10 20:27 et_EE.php
-rw-rw-r-- 1 48 48  9609 2006-08-28 18:55 el_GR.php
-rw-rw-r-- 1 48 48  7518 2006-08-28 18:55 en_GB.php
-rw-rw-r-- 1 48 48  8415 2006-08-28 18:55 zh_TW.php

[rab]

This 1.0 version is great - recurring events work so much better - thanks! One question and one possible bug:

Question - how can I get Event Template to NOT display a time if the event is an all day thing with no start or end time, like a holiday?

Possible bug? - When I input a start and end date/time for an event, then save it, and then later decide to NOT have an end time, unchecking the "To Date:" box and then updating the event record does not delete the end date.

Thanks!

[seitenwind]

Can you please(!) make a note at the download section, that this is not backward compatible!

I just saw that 1.0 is out, updated and guess what: It's not working correctly.
When I'm trying to add a new event I get the following error:

FATAL ERROR:
QUERY = INSERT INTO cms_module_calendar_events (event_id,event_title,event_summary,event_details ,event_date_start,event_date_end,event_parent_id ,event_recur_period, event_date_recur_end, event_created_by ,event_recur_nevents, event_recur_interval, event_recur_weekdays ,event_create_date, event_modified_date) VALUES (211,'test','test','test','2008-11-18 08:30:00','NULL',-1,'none','NULL','5',-1,1,'',NOW(),NOW())
ERROR = Unknown column 'event_recur_nevents' in 'field list'

[KO]

I've seen that compatibility warning in many places but probably not everywhere.

We are building something that has Calender and tried to use this upgrade just to see what comes out. But upgrade has nothing inside so that's one of the reasons why upgrade to old one is not supported. Bit confusing as you are still able to do upgrade in admin.

Here is few changes we noticed on database. With these changes you might get yours running.

Look cms_module_calendar_events -> event_recur_period

and change that from int(11) to varchar(10)

Also you need to change 'none' to '0' on those fields and you can do that with SQL command:

Code: Select all

UPDATE `cms_module_calendar_events` SET event_recur_period = 'none' WHERE event_recur_period = '0'

Also add following fields as those are not done with upgrade:

event_recur_nevents  int(11)
event_recur_interval  int(11)
event_recur_weekdays  varchar(255)

at the end of

[KO]

at the end of

...

at the end of  cms_module_calendar_events

Ofcourse take a backup from whatever you have. As these worked for us but might not be for you.

[seitenwind]

Hoooray! It's working, Thank you sooo much!!!

[seitenwind]

ok, I am annoying but I'm having another issue with the 1.0 version:

When adding  a new event I can only choose time steps of 15min. In previous versions I could choose exact minutes.
We need this because we post alarms of our volunteer fire fighter unit.

[jans]

Hi,

I don't want to be nasty but, after updating v1.0 did not work so I deinstalled it and then freshley installed v1.0.

It seemed to work but what do I see, my previous templates are shot to hell and I see an ugly type of text version.
Not only that but adding any event give an error, so I read this forum thread (after long searh) and tried your "edit SQL" option.

What do I discover ? the complete Db table is GONE, or atleast every entry for the calendar module is, why ??  I mean if upgrading I expect a complete upgrade or at least some error or warnings during upgrade that table parts are not there so I can abort installation.

Any way how do I recreate the calendar dB tables ? and what's even more annoying how do I recreate or rescue the entries in my calendar (if possible at all)

Greets and please help me to get it all back.JanS

[jans]

Got the databse back by copying from an old backup and editing it so it is up to date now, still error, see blow:


FATAL ERROR:
QUERY = INSERT INTO cms_module_calendar_events (event_id,event_title,event_summary,event_details ,event_date_start,event_date_end,event_parent_id ,event_recur_period, event_date_recur_end, event_created_by ,event_recur_nevents, event_recur_interval, event_recur_weekdays ,event_create_date, event_modified_date) VALUES (5,'test','test','test','2008-11-29 23:45:00','NULL',-1,'none','NULL','1',-1,1,'',NOW(),NOW())
ERROR = Incorrect datetime value: 'NULL' for column 'event_date_end' at row 1

[KO]

Also you need to change 'none' to '0' on those fields and you can do that with SQL command:

Code: Select all

UPDATE `cms_module_calendar_events` SET event_recur_period = 'none' WHERE event_recur_period = '0'

One thing I notice from your error that you still have "none" there and it is not accepted.

[michi1979]

Hello,
is there a replacement for table_id="small" in V1.0 ?

Greetings,
Michael

[jans]

I ran your sql command and I tried to ad an item, now I get this error.

What's wrong with calendar ? it was such a nice and helpfull module, after updating it's not even close to it anymore.

Is ther a newer version (like 1.1) that can be installed and that repairs all errors ? please help

Greets, Jans

FATAL ERROR:
QUERY = INSERT INTO cms_module_calendar_events (event_id,event_title,event_summary,event_details ,event_date_start,event_date_end,event_parent_id ,event_recur_period, event_date_recur_end, event_created_by ,event_recur_nevents, event_recur_interval, event_recur_weekdays ,event_create_date, event_modified_date) VALUES (1,'test','test','test','2008-12-10 14:30:00','NULL',-1,'none','NULL','1',-1,1,'',NOW(),NOW())
ERROR = Incorrect datetime value: 'NULL' for column 'event_date_end' at row 1



BTW, this is the sql command for creation of the tables as shown by mySQLmanager, I don't see any 0 (zero) value only NULL why then change 0 into none, and where  ?

CREATE TABLE `cms_module_calendar_events` (
  `event_id` int(11) NOT NULL,
  `event_title` varchar(255) default NULL,
  `event_summary` text,
  `event_details` text,
  `event_date_start` datetime default NULL,
  `event_date_end` datetime default NULL,
  `event_parent_id` int(11) default NULL,
  `event_recur_period` varchar(10) default NULL,
  `event_date_recur_end` datetime default NULL,
  `event_created_by` int(11) default NULL,
  `event_create_date` datetime default NULL,
  `event_modified_date` datetime default NULL,
  `event_recur_nevents` int(11) default NULL,
  `event_recur_interval` int(11) default NULL,
  `event_recur_weekdays` varchar(255) default NULL,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[jans]

badaboing badabump

Is there anybody home ??

I'm dying to get my calendar back to work as it was before please !!!

[Charles Butcher]

Can anyone tell me if there's a way to export data from previous versions of Calendar so that I can re-import it to the new version?

Calguy wrote:

Warning: This version of Calendar is not backward compatible with earlier versions. Upgrade is not possible

I think we've got the message, though not having looked here in the Forum, I found this out the hard way -- I don't think the lack of upgradeability is mentioned in the Forge Calendar pages.

I appreciate Calguy's hard work on this, and I really like the look of the improvements in v1.0. However, it would be nice to apply them to existing calendar data. Surely there must be a way to do this even if it means extracting data from MySQL and formatting it as CSV?

I don't know much about MySQL, and my web-based database access (DB WebAdmin and Plesk 8.6) doesn't seem to work. A steer in the right direction would be much appreciated.

[seitenwind]

I think we've got the message, though not having looked here in the Forum, I found this out the hard way -- I don't think the lack of upgradeability is mentioned in the Forge Calendar pages.

This and the hard way to upgrade were already mentioned earlier in this topic. Unfortunately there's still no "warning sign" in the download center.

I installed the 1.0 version too, without knowing I shouldn't. You can fix this by adding some entries to your database.

I just saw that 1.0 is out, updated and guess what: It's not working correctly.
When I'm trying to add a new event I get the following error:

FATAL ERROR:
QUERY = INSERT INTO cms_module_calendar_events (event_id,event_title,event_summary,event_details ,event_date_start,event_date_end,event_parent_id ,event_recur_period, event_date_recur_end, event_created_by ,event_recur_nevents, event_recur_interval, event_recur_weekdays ,event_create_date, event_modified_date) VALUES (211,'test','test','test','2008-11-18 08:30:00','NULL',-1,'none','NULL','5',-1,1,'',NOW(),NOW())
ERROR = Unknown column 'event_recur_nevents' in 'field list'

Solution:

We are building something that has Calender and tried to use this upgrade just to see what comes out. But upgrade has nothing inside so that's one of the reasons why upgrade to old one is not supported. Bit confusing as you are still able to do upgrade in admin.

Here is few changes we noticed on database. With these changes you might get yours running.

Look cms_module_calendar_events -> event_recur_period

and change that from int(11) to varchar(10)

Also you need to change 'none' to '0' on those fields and you can do that with SQL command:

Code: Select all

UPDATE `cms_module_calendar_events` SET event_recur_period = 'none' WHERE event_recur_period = '0'

Also add following fields as those are not done with upgrade:

event_recur_nevents    int(11)
event_recur_interval   int(11)
event_recur_weekdays  varchar(255)

at the end of