Änderung von Kalendereinträgen erzeugt Database-Error

[Wermuth]

Hallo Zusammen,

wir haben das Problem nach der Ersteinrichtung, das bei Änderung von bestehenden Kalendereinträgen eine Database-Error erzeugt wird. Die geänderten Daten werden trotzdem im Kalendereintrag gespeichert und können anschließend abgerufen werden. Der Fehler tritt nur beim erneuten Speichern der Einträge auf, bei Neuanlage haben wir dieses Problem nicht.

Hier der Fehlercode:

Database error

db::column_data_implode(’ AND ‘,Array
(
[participant] => 8
[0] => cal_deleted IS NULL
[1] => egw_cal_user.cal_status NOT IN (‘R’,‘X’,‘E’)
[2] => 1441231200 < cal_end
[3] => (rejected_by_user.cal_status IS NULL OR rejected_by_user.cal_status NOT IN (‘R’,‘X’))
[4] => egw_cal_user.cal_user_type=‘u’ AND egw_cal_user.cal_user_id IN (‘8’,’-1’,’-2’)
[5] => recur_type IS NULL AND egw_cal_user.cal_recur_date=0
)
,‘1’,

Array

(

[cal_id] => Array

(

[type] => auto

[nullable] =>

[comment] => calendar id

)
[cal_uid] => Array
    (
        [type] => ascii
        [precision] => 128
        [nullable] => 
        [comment] => unique id of event(-series)
    )

[cal_owner] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [nullable] => 
        [comment] => event owner / calendar
    )

[cal_category] => Array
    (
        [type] => ascii
        [meta] => category
        [precision] => 64
        [comment] => category id(s)
    )

[cal_modified] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [comment] => ts of last modification
    )

[cal_priority] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] => 
        [default] => 2
        [comment] => priority: 1=Low, 2=Normal, 3=High
    )

[cal_public] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] => 
        [default] => 1
        [comment] => 1=public, 0=private event
    )

[cal_title] => Array
    (
        [type] => varchar
        [precision] => 255
        [nullable] => 
        [comment] => title of event
    )

[cal_description] => Array
    (
        [type] => varchar
        [precision] => 16384
        [comment] => description
    )

[cal_location] => Array
    (
        [type] => varchar
        [precision] => 255
        [comment] => location
    )

[cal_reference] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] => 
        [default] => 0
        [comment] => cal_id of series for exception
    )

[cal_modifier] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [comment] => user who last modified event
    )

[cal_non_blocking] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
        [comment] => 1 for non-blocking events
    )

[cal_special] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
    )

[cal_etag] => Array
    (
        [type] => int
        [precision] => 4
        [default] => 0
        [comment] => etag for optimistic locking
    )

[cal_creator] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [nullable] => 
        [comment] => creating user
    )

[cal_created] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [comment] => creation time of event
    )

[cal_recurrence] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [default] => 0
        [comment] => cal_start of original recurrence for exception
    )

[tz_id] => Array
    (
        [type] => int
        [precision] => 4
        [comment] => key into egw_cal_timezones
    )

[cal_deleted] => Array
    (
        [type] => int
        [precision] => 8
        [comment] => ts when event was deleted
    )

[caldav_name] => Array
    (
        [type] => ascii
        [precision] => 128
        [comment] => name part of CalDAV URL, if specified by client
    )

[range_start] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [comment] => startdate (of range)
    )

[range_end] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [comment] => enddate (of range, UNTIL of RRULE)
    )

)

nothing known about column 'participant'!

#0 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_db.inc.php(2176): egw_db->column_data_implode(’ AND ‘, Array, true, false, Array)
#1 [internal function]: egw_db->select(’(SELECT * FROM …’, ‘DISTINCT egw_ca…’, Array, false, false, false, NULL, ‘calendar’, 0, ‘JOIN egw_cal_da…’, Array)
#2 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_db.inc.php(2232): call_user_func_array(Array, Array)
#3 /var/www//html/egroupware/gw/calendar/inc/class.calendar_so.inc.php(954): egw_db->union(Array, 954, ‘/var/www/ud15_3…’)
#4 /var/www//html/egroupware/gw/calendar/inc/class.calendar_bo.inc.php(536): calendar_so->search(1441231200, NULL, Array, 0, ‘default’, 0, 50, Array, 8)
#5 /var/www//html/egroupware/gw/calendar/inc/class.calendar_uilist.inc.php(395): calendar_bo->search(Array, Array)
#6 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(596): calendar_uilist->get_rows(Array, Array, Array)
#7 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(176): etemplate_widget_nextmatch::call_get_rows(Array, Array, Array, NULL, NULL, Object(etemplate_widget_nextmatch))
#8 [internal function]: etemplate_widget_nextmatch->beforeSendToClient(’’, Array)
#9 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget.inc.php(428): call_user_func_array(Array, Array)
#10 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(1115): etemplate_widget->run(‘beforeSendToCli…’, Array, false)
#11 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146): etemplate_widget_nextmatch->run(‘beforeSendToCli…’, Array, false, Array)
#12 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146): etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false, Array)
#13 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146): etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false, Array)
#14 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget.inc.php(434): etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false)
#15 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_template.inc.php(235): etemplate_widget->run(‘beforeSendToCli…’, Array, false)
#16 /var/www//html/egroupware/gw/etemplate/inc/class.etemplate_new.inc.php(131): etemplate_widget_template->run(‘beforeSendToCli…’, Array)
#17 /var/www//html/egroupware/gw/calendar/inc/class.calendar_uilist.inc.php(219): etemplate_new->exec(‘calendar.calend…’, Array, Array, NULL, Array, 0)
#18 /var/www//html/egroupware/gw/jdots/inc/class.jdots_framework.inc.php(1104): calendar_uilist->listview()
#19 [internal function]: jdots_framework->ajax_exec(‘index.php?menua…’)
#20 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_json.inc.php(163): call_user_func_array(Array, Array)
#21 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_json.inc.php(82): egw_json_request->handleRequest(‘calendar.jdots_…’, Array)
#22 /var/www//html/egroupware/gw/json.php(106): egw_json_request->parseRequest(‘calendar.jdots_…’, ‘{“request”:{"pa…’)
#23 {main}

Was müssen wir ändern, damit der Fehler nicht mehr auftritt? Da wir absolute Einsteiger beim Thema EGroupware sind, sind über jeden Tipp dankbar.

[Ralf_Becker_Stylite]

Hallo Wermuth,

Problem ist inzwischen behoben, gibt aber noch kein neues Packet.

In der Zwischenzeit kann einfach das folgende File ausgetauscht werden:

https://svn.stylite.de/egroupware/branches/14.2/calendar/inc/class.calendar_uilist.inc.php

Ralf

Hallo Zusammen,

wir haben das Problem nach der Ersteinrichtung, das bei Änderung von
bestehenden Kalendereinträgen eine Database-Error erzeugt wird. Die
geänderten Daten werden trotzdem im Kalendereintrag gespeichert und können
anschließend abgerufen werden. Der Fehler tritt nur beim erneuten Speichern
der Einträge auf, bei Neuanlage haben wir dieses Problem nicht.

Hier der Fehlercode:

Database error

db::column_data_implode(’ AND ‘,Array
(
[participant] => 8
[0] => cal_deleted IS NULL
[1] => egw_cal_user.cal_status NOT IN (‘R’,‘X’,‘E’)
[2] => 1441231200 < cal_end
[3] => (rejected_by_user.cal_status IS NULL OR
rejected_by_user.cal_status NOT IN (‘R’,‘X’))
[4] => egw_cal_user.cal_user_type=‘u’ AND egw_cal_user.cal_user_id IN
(‘8’,’-1’,’-2’)
[5] => recur_type IS NULL AND egw_cal_user.cal_recur_date=0
)
,‘1’,

Array

(

[cal_id] => Array

(

[type] => auto

[nullable] =>

[comment] => calendar id

)
[cal_uid] => Array
    (
        [type] => ascii
        [precision] => 128
        [nullable] => 
        [comment] => unique id of event(-series)
    )

[cal_owner] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [nullable] => 
        [comment] => event owner / calendar
    )

[cal_category] => Array
    (
        [type] => ascii
        [meta] => category
        [precision] => 64
        [comment] => category id(s)
    )

[cal_modified] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [comment] => ts of last modification
    )

[cal_priority] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] => 
        [default] => 2
        [comment] => priority: 1=Low, 2=Normal, 3=High
    )

[cal_public] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] => 
        [default] => 1
        [comment] => 1=public, 0=private event
    )

[cal_title] => Array
    (
        [type] => varchar
        [precision] => 255
        [nullable] => 
        [comment] => title of event
    )

[cal_description] => Array
    (
        [type] => varchar
        [precision] => 16384
        [comment] => description
    )

[cal_location] => Array
    (
        [type] => varchar
        [precision] => 255
        [comment] => location
    )

[cal_reference] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] => 
        [default] => 0
        [comment] => cal_id of series for exception
    )

[cal_modifier] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [comment] => user who last modified event
    )

[cal_non_blocking] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
        [comment] => 1 for non-blocking events
    )

[cal_special] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
    )

[cal_etag] => Array
    (
        [type] => int
        [precision] => 4
        [default] => 0
        [comment] => etag for optimistic locking
    )

[cal_creator] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 4
        [nullable] => 
        [comment] => creating user
    )

[cal_created] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [comment] => creation time of event
    )

[cal_recurrence] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [default] => 0
        [comment] => cal_start of original recurrence for exception
    )

[tz_id] => Array
    (
        [type] => int
        [precision] => 4
        [comment] => key into egw_cal_timezones
    )

[cal_deleted] => Array
    (
        [type] => int
        [precision] => 8
        [comment] => ts when event was deleted
    )

[caldav_name] => Array
    (
        [type] => ascii
        [precision] => 128
        [comment] => name part of CalDAV URL, if specified by client
    )

[range_start] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [nullable] => 
        [comment] => startdate (of range)
    )

[range_end] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
        [comment] => enddate (of range, UNTIL of RRULE)
    )

)

*nothing known about column 'participant'!*

#0 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_db.inc.php(2176):
egw_db->column_data_implode(’ AND ‘, Array, true, false, Array)
#1 [internal function]: egw_db->select(’(SELECT * FROM …’, ‘DISTINCT
egw_ca…’, Array, false, false, false, NULL, ‘calendar’, 0, ‘JOIN
egw_cal_da…’, Array)
#2 /var/www//html/egroupware/gw/phpgwapi/inc/class.egw_db.inc.php(2232):
call_user_func_array(Array, Array)
#3
/var/www//html/egroupware/gw/calendar/inc/class.calendar_so.inc.php(954):
egw_db->union(Array, 954, ‘/var/www/ud15_3…’)
#4
/var/www//html/egroupware/gw/calendar/inc/class.calendar_bo.inc.php(536):
calendar_so->search(1441231200, NULL, Array, 0, ‘default’, 0, 50, Array, 8)
#5
/var/www//html/egroupware/gw/calendar/inc/class.calendar_uilist.inc.php(395):
calendar_bo->search(Array, Array)
#6
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(596):
calendar_uilist->get_rows(Array, Array, Array)
#7
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(176):
etemplate_widget_nextmatch::call_get_rows(Array, Array, Array, NULL, NULL,
Object(etemplate_widget_nextmatch))
#8 [internal function]: etemplate_widget_nextmatch->beforeSendToClient(’’,
Array)
#9
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget.inc.php(428):
call_user_func_array(Array, Array)
#10
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_nextmatch.inc.php(1115):
etemplate_widget->run(‘beforeSendToCli…’, Array, false)
#11
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146):
etemplate_widget_nextmatch->run(‘beforeSendToCli…’, Array, false, Array)
#12
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146):
etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false, Array)
#13
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_grid.inc.php(146):
etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false, Array)
#14
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget.inc.php(434):
etemplate_widget_grid->run(‘beforeSendToCli…’, Array, false)
#15
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_widget_template.inc.php(235):
etemplate_widget->run(‘beforeSendToCli…’, Array, false)
#16
/var/www//html/egroupware/gw/etemplate/inc/class.etemplate_new.inc.php(131):
etemplate_widget_template->run(‘beforeSendToCli…’, Array)
#17
/var/www//html/egroupware/gw/calendar/inc/class.calendar_uilist.inc.php(219):
etemplate_new->exec(‘calendar.calend…’, Array, Array, NULL, Array, 0)
#18
/var/www//html/egroupware/gw/jdots/inc/class.jdots_framework.inc.php(1104):
calendar_uilist->listview()
#19 [internal function]: jdots_framework->ajax_exec(‘index.php?menua…’)
#20
/var/www//html/egroupware/gw/phpgwapi/inc/class.egw_json.inc.php(163):
call_user_func_array(Array, Array)
#21
/var/www//html/egroupware/gw/phpgwapi/inc/class.egw_json.inc.php(82):
egw_json_request->handleRequest(‘calendar.jdots_…’, Array)
#22 /var/www//html/egroupware/gw/json.php(106):
egw_json_request->parseRequest(‘calendar.jdots_…’, ‘{“request”:{"pa…’)
#23 {main}

Was müssen wir ändern, damit der Fehler nicht mehr auftritt? Da wir absolute
Einsteiger beim Thema EGroupware sind, sind über jeden Tipp dankbar.

–
View this message in context: http://egroupware.219119.n3.nabble.com/Anderung-von-Kalendereintragen-erzeugt-Database-Error-tp4008877.html
Sent from the egroupware-german mailing list archive at Nabble.com.

---

Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140

---

egroupware-german mailing list
egroupware-german@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-german

–
Ralf Becker
Director Software Development

Stylite AG

Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 46224 Mainz Germany

[Wermuth]

Hallo Ralf,

vielen Dank für die schnelle Hilfe! Funktioniert nun alles fehlerfrei, besser geht es einfach nicht.

Beste Grüße nach Mainz

Wermuth