[kronolith] Short days on calendar

You, Hongtao Howard howard.you at ips.invensys.com
Wed Nov 30 07:29:15 PST 2005


I solved the issue by comment-out a few lines in the codes of month.php as
follows.

    // We may need to adjust the number of days in the view if we're
    // starting weeks on Sunday.
//    if ($startday == HORDE_DATE_SUNDAY) {
//        $daysInView -= 7;
//    }

Thanks

Howard

-----Original Message-----
From: kronolith-bounces at lists.horde.org
[mailto:kronolith-bounces at lists.horde.org] On Behalf Of
kronolith-request at lists.horde.org
Sent: Thursday, November 24, 2005 7:10 AM
To: kronolith at lists.horde.org
Subject: kronolith Digest, Vol 857, Issue 1

Send kronolith mailing list submissions to
	kronolith at lists.horde.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.horde.org/mailman/listinfo/kronolith
or, via email, send a message with subject or body 'help' to
	kronolith-request at lists.horde.org

You can reach the person managing the list at
	kronolith-owner at lists.horde.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of kronolith digest..."


Today's Topics:

   1. Fatal error when adding events within Kronolith
      (Jon-Michael DeShazer)
   2. Re: Short days on calendar (Chuck Hagenbuch)
   3. Calender activation per script (Peter Becker)
   4. Re: Fatal error when adding events within Kronolith
      (Jan Schneider)
   5. Re: Calender activation per script (Jan Schneider)
   6. Re: Kronolith2.0.5 + oracle 10g (samer khalil)
   7. Write/Change access to external ics calendar (Martin Hochreiter)


----------------------------------------------------------------------

Message: 1
Date: Wed, 23 Nov 2005 14:50:14 -0700
From: Jon-Michael DeShazer <jdeshazer at horanandmcconaty.com>
Subject: [kronolith] Fatal error when adding events within Kronolith
To: kronolith at lists.horde.org
Message-ID: <4384E416.6060904 at horanandmcconaty.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I keep getting this error every time I attempt to add new events to a 
calendar using kronolith:


  A fatal error has occurred


      DB Error: extension not found

|[line 542 of /var/www/localhost/htdocs/horde/kronolith/lib/Driver/sql.php]
|

|I have no idea why.  Here are my specs
|

|Gentoo Linux 2005.1
horde 3.0.7
kronolith 2.0.5
PHP 5.0.15
MySQL 4.1.15
Apache 2.0.55
|

I have the MySQL 4.1+ authentication method enabled and the correct user 
name and password for the database.  Any ideas?


------------------------------

Message: 2
Date: Wed, 23 Nov 2005 22:30:32 -0500
From: Chuck Hagenbuch <chuck at horde.org>
Subject: Re: [kronolith] Short days on calendar
To: kronolith at lists.horde.org
Message-ID: <20051123223032.fn3s1g4bp6cc8w0g at marina.horde.org>
Content-Type: text/plain;	charset=ISO-8859-1;	format="flowed"

Quoting "You, Hongtao Howard" <howard.you at ips.invensys.com>:

> I had the latest stable horde products installed on a FC3 box. I found a
> problem of Kronolith. It seems like the month with 1st day as Sunday will
> show only 28 days (4 lines). For example, May 2005 and Jan. 2006 will show
> 28 days on my box. I don't know whether it's because Kronolith or the FC3
> system setup. I have the same issue with previous versions of Horde. Does
> anyone know this issue?

I can't reproduce this. What number corresponds to what you consider 
the latest stable horde products?

-chuck

-- 
"So we're talking near-sonic speeds for a vegetable."
Reasons to go to the Punkin Chunkin World Championships


------------------------------

Message: 3
Date: Thu, 24 Nov 2005 11:19:07 +0100
From: "Peter Becker" <tera at teranus.de>
Subject: [kronolith] Calender activation per script
To: <kronolith at lists.horde.org>
Message-ID: <03dd01c5f0e0$81a39890$496ffc50 at Sinje>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original

Hi

Is there any possibility to activate a shared calender per script for every 
user?
Could I do this in the database?

There is a global calender for every user of the domain and I want that 
everybody could read this per default

Kind Regards,
Peter 



------------------------------

Message: 4
Date: Thu, 24 Nov 2005 12:17:41 +0100
From: Jan Schneider <jan at horde.org>
Subject: Re: [kronolith] Fatal error when adding events within
	Kronolith
To: kronolith at lists.horde.org
Message-ID: <20051124121741.iwrryz4n44owkg4o at neo.wg.de>
Content-Type: text/plain;	charset=ISO-8859-15;	format="flowed"

Zitat von Jon-Michael DeShazer <jdeshazer at horanandmcconaty.com>:

> I keep getting this error every time I attempt to add new events to a
> calendar using kronolith:
>
>
>   A fatal error has occurred
>
>
>       DB Error: extension not found
>
> |[line 542 of
/var/www/localhost/htdocs/horde/kronolith/lib/Driver/sql.php]
> |
>
> |I have no idea why.  Here are my specs
> |
>
> |Gentoo Linux 2005.1
> horde 3.0.7
> kronolith 2.0.5
> PHP 5.0.15
> MySQL 4.1.15
> Apache 2.0.55
> |
>
> I have the MySQL 4.1+ authentication method enabled and the correct user
> name and password for the database.  Any ideas?

No, you have the the "MySQL improved" driver selected, which is a huge 
difference, because you don't have the mysqli extension.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


------------------------------

Message: 5
Date: Thu, 24 Nov 2005 12:26:03 +0100
From: Jan Schneider <jan at horde.org>
Subject: Re: [kronolith] Calender activation per script
To: kronolith at lists.horde.org
Message-ID: <20051124122603.uhr7t35tcso40sww at neo.wg.de>
Content-Type: text/plain;	charset=ISO-8859-15;	format="flowed"

Zitat von Peter Becker <tera at teranus.de>:

> Is there any possibility to activate a shared calender per script for
every
> user?
> Could I do this in the database?
>
> There is a global calender for every user of the domain and I want that
> everybody could read this per default

Set read permissions for all authenticated users for that calendar.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/


------------------------------

Message: 6
Date: Thu, 24 Nov 2005 14:00:53 +0200
From: samer khalil <samerk1 at gmail.com>
Subject: Re: [kronolith] Kronolith2.0.5 + oracle 10g
To: Jan Schneider <jan at horde.org>
Cc: kronolith at lists.horde.org
Message-ID:
	<ba167e630511240400p3c6cd23frdac0b564df110995 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

It's me again,
I reinstalled the hole system and got the same result.
No events are showing in Kronolith alltough they are inserted in the DB.
my kronolith conf.php :

<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: kronolith/config/conf.xml,v 1.14.10.1 2005/03/04 04:04:31 ben Exp
$
$conf['calendar']['params']['table'] = 'kronolith_events';
$conf['calendar']['params']['driverconfig'] = 'horde';
$conf['calendar']['driver'] = 'sql';
$conf['storage']['params']['table'] = 'kronolith_storage';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['metadata']['keywords'] = false;
$conf['reminder']['server_name'] = 'localhost';
$conf['reminder']['from_addr'] = 'imail at aub.edu.lb';
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('imp', 'turba');
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

and horde conf.php:

<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42 mrubinsk
Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['persistent'] = false;
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '*********';  # with the right password
$conf['sql']['hostspec'] = 'europa';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'oci8';
$conf['auth']['admins'] = array('Administrator', 'samerk');
$conf['auth']['checkip'] = true;
$conf['auth']['driver'] = 'composite';

$conf['auth']['params']['drivers'] = array(
    'imp' => array('driver' => 'application',
                   'params' => array('app' => 'imp')),
    'mimp' => array('driver' => 'application',
                    'params' => array('app' => 'mimp')));

$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';

if (!function_exists('_horde_select_loginscreen')) {
    function _horde_select_loginscreen()
    {
        require_once 'Horde/Browser.php';
        require_once 'Horde/Browser.php';
        $browser = &new Browser();
        if ($browser->isMobile()) {
            return 'mimp';
        }
        return 'imp';
    }
}
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_DEBUG;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/tmp/horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$conf['sessionhandler']['type'] = 'none';
$conf['problems']['email'] = 'imail at aub.edu.lb';
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'all';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
$conf['imsp']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

when i enable PEAR_LOG_DEBUG, i get the following lines in horde.log when i
click on 'Calendar' :


Nov 24 13:38:00 HORDE [debug] [kronolith] Hook _horde_hook_share_init in
application horde not called. [on line 1387 of "/web/horde3/lib/Horde.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND
a1.attribute_key = ?)   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND ((a1.attribute_name = ? AND
a1.attribute_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?))   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (722, 689) AND group_uid = '
horde.shares.kronolith' ORDER BY datatree_id [on line 275 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name,
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id IN
(?, ?, ?) AND group_uid = ? ORDER BY datatree_id [on line 305 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name,
attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (722, 689) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND
a1.attribute_key = ?)   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND ((a1.attribute_name = ? AND
a1.attribute_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?))   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name,
attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (722, 689) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL session setup by samerk: query
= "ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'" [on line 558
of "/web/horde3/kronolith/lib/Driver/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL event list by samerk: query =
"SELECT event_id, event_uid, event_description, event_location,
event_status, event_attendees, event_keywords, event_title, event_category,
event_recurtype, event_recurenddate, event_recurinterval, event_recurdays,
event_start, event_end, event_alarm, event_modified, event_exceptions,
event_creator_id FROM kronolith_events WHERE calendar_id = ? AND ((event_end
> ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start <= ?
AND event_recurtype <> ?))" [on line 239 of
"/web/horde3/kronolith/lib/Driver/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] Hook _horde_hook_share_init in
application horde not called. [on line 1387 of "/web/horde3/lib/Horde.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND
a1.attribute_key = ?)   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM
horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id =
c.datatree_id WHERE c.group_uid = ? AND ((a1.attribute_name = ? AND
a1.attribute_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?))   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id
IN (690) AND group_uid = 'horde.shares.nag' ORDER BY datatree_id [on line
275 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE datatree_id IN (?, ?) AND group_uid = ? ORDER BY
datatree_id [on line 305 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name,
attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (690) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] Nag_Driver_sql::retrieve(): SELECT *
FROM nag_tasks WHERE task_owner = ? [on line 350 of
"/web/horde3/nag/lib/Driver/sql.php"]

can anyone tell me what am i still missing?
Thanks
Samer


On 11/21/05, Jan Schneider <jan at horde.org> wrote:
>
> Zitat von samer khalil <samerk1 at gmail.com>:
>
> > I know, there is no event_id in the querry, allthough the event ID (the
> > serial) shows in calendar_id field ! while calendar_id should point to
> the
> > username.
> >  Please correct me if i am rong.
>
> You are wrong.
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
> --
> Kronolith mailing list - Join the hunt:
> http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>


------------------------------

Message: 7
Date: Thu, 24 Nov 2005 14:09:25 +0100
From: Martin Hochreiter <linuxbox at wavenet.at>
Subject: [kronolith] Write/Change access to external ics calendar
To: kronolith at lists.horde.org
Message-ID: <4385BB85.10503 at wavenet.at>
Content-Type: text/plain; charset=ISO-8859-1

Hi!

Is there a chance to get write/change access on an external
.ics calendar .... to use .ics as full data source?

lg



------------------------------


-- 
Kronolith mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org


End of kronolith Digest, Vol 857, Issue 1
*****************************************

-------------- next part --------------
A non-text attachment was scrubbed...
Name: month.php
Type: application/octet-stream
Size: 7771 bytes
Desc: not available
Url : http://lists.horde.org/archives/kronolith/attachments/20051130/dbbe89c9/month-0001.obj


More information about the kronolith mailing list