[Phpgroupware-developers] Has someone tried phpgw with MySQl 4 ?

[Kai Hofmann]

Hi all,

has someone of you tried to run phpg 0.9.14/0.9.16 on a MySQL 4?

I found problems with inserts into the phpgw_preferences table:

insert into phpgw_preferences
values('631','a:2:s:6:"common";a:8:s:12:"template_set";s:11:"probusiness";s:
10:"dateformat";s:5:"d.m.Y";s:10:"timeformat";s:2:"24";s:7:"country";s:2:"DE
";s:4:"lang";s:2:"de";s:8:"currency";s:3:"EUR";s:5:"theme";s:11:"probusiness
";s:13:"navbar_format";s:14:"icons_and_text";}s:3:"tts";a:3:{s:12:"groupdefa
ult";s:3:"514";s:15:"assigntodefault";s:3:"503";s:15:"prioritydefault";s:1:"
5";}}')

thats because it seems MySQL does NOT like the double quotes for the
preference_value db column.

I tried to start mysqld with --sql-mode=MYSQL323 or --ansi but this won't
help here.

Seems like the inserts in phpgw that use double quotes within a column have
to be rewritten.
This should really be done before releasing 0.9.16 as final.


Greetings

   Kai

-- 
*****    Open Source und Linux im professionellen Einsatz    *****
**  komplexe Mailserver, Groupware, Office: sprechen Sie uns an **
Dipl.-Inform. Kai Hofmann                    Team Softwarelösungen
pro|business AG, EXPO Plaza 1 (Deutscher Pavillon), 30539 Hannover
E-Mail: address@hidden,   Tel.: 0511/60066-332, Fax: -355
WWW: http://www.probusiness.de/