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

[Dave Hall]

Hi Kai,

I have it running quite happily on mysql 4 on 2 boxes, neither of them
production versions.  The double quotes should just be treated as any
other normal char in the string.  The string is actually generated by
php serialize().

Also are you using 14 or 16, that looks like it is a 14 prefs insert.

A bit more info might help us track this one down.

Cheers

Dave

Kai Hofmann <address@hidden> wrote:

> 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'thelp 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/
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>