Trunk groupdav.php throws database error

Hans-Jurgen_Tappe 2011-06-02 12:34:10 UTC #1

Hi Ralf!

Access to http://localhost/egroupware/groupdav.php/calendar throws a
database error on a MySQL install:

Database error db::column_data_implode(’ AND ',Array | ( |
[session_php] => d013bcd743bfba6110f4b481e81f1369 | ) | ,‘1’,

Array

( | [ses

Reverting to a version before 34665 fixes the problem.
http://svn.stylite.de/viewvc/egroupware?view=revision&revision=34665

Can you please help to identify the problem source? The culprit is
somewhere here:

http://svn.stylite.de/viewvc/egroupware/trunk/phpgwapi/inc/class.egw_session.inc.php?r1=33174&r2=34665&pathrev=34665

Somewhere, the session_php is not sufficiently interpreted as a member
of an array…

Thanks a lot,
Hans-Jürgen

Simplify data backup and recovery for your virtual environment with vRanger.
Installation’s a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It’s vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev

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

Ralf_Becker_Stylite 2011-06-02 12:46:51 UTC #2

Hi Hans-Juergen,

Hi Ralf!

Access to http://localhost/egroupware/groupdav.php/calendar throws a
database error on a MySQL install:

Database error db::column_data_implode(’ AND ',Array | ( |
[session_php] => d013bcd743bfba6110f4b481e81f1369 | ) | ,‘1’,
Array

( |     [ses

Reverting to a version before 34665 fixes the problem.

http://svn.stylite.de/viewvc/egroupware?view=revision&revision=34665
Can you please help to identify the problem source? The culprit is

somewhere here:
http://svn.stylite.de/viewvc/egroupware/trunk/phpgwapi/inc/class.egw_session.inc.php?r1=33174&r2=34665&pathrev=34665
Somewhere, the session_php is not sufficiently interpreted as a member

of an array…

Sounds like your phpgwapi/setup/tables_current.inc.php does not contain
session_php column for table egw_sessions …

Ralf

Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

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

Hans-Jurgen_Tappe 2011-06-02 13:40:26 UTC #3

Hi Ralf!

Access to http://localhost/egroupware/groupdav.php/calendar throws a
database error on a MySQL install:
Database error db::column_data_implode(’ AND ',Array | ( |
[session_php] => d013bcd743bfba6110f4b481e81f1369 | ) | ,‘1’,
Array

( |     [ses

Reverting to a version before 34665 fixes the problem.

Sounds like your phpgwapi/setup/tables_current.inc.php does not contain

session_php column for table egw_sessions …

session_php is defined only for egw_access_log in the trunk version of
phpgwapi/setup/tables_current.inc.php (and it is there and populated in
the database)? There is no table egw_sessions defined in trunk?

Thanks,
Hans-Jürgen

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

Hans-Jurgen_Tappe 2011-06-02 14:53:57 UTC #4

Hi Ralf!

A ‘rm /var/lib/php5/sess_*’ clarified it. For groupdav, it tries to
re-use the session for the remote IP and the current tables are
obviously part of the sessions…

Maybe, the setup should invalidate the egroupware sessions when altering
the session tables or an exception could be thrown, trying to recheck
the current tables?

Thanks for bearing with me.
Hans-Jürgen

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