Thank you Klaus,
I thought that was the problem. Meanwhile I applied the original patch found
on the Tracker which worked.
I will try your proposal with r27672.
For first view the chat easy to use and working well. Of course, everybody
could see all conversation as I can see, but this module is really useful. I
dropped to a company to test it and they can use and understand that, focus
on work because the boss could read their chat 
Thank you again,
Cheers,
István
----------------eredeti üzenet-----------------
Feladó: “Klaus Leithoff” kl@stylite.de
Címzett: "development of eGroupWare,for active developers"
egroupware-developers@lists.sourceforge.net
Dátum: Mon, 7 Sep 2009 10:41:27 +0200
YES, as PFC uses group as columnname, thats a bugger. The integration
lacks
some issues as admins for
the chat and so on, but basically it seems fine. It was not meant for 1.6
as
there are still some issues.
But you may use
Revision 27672 -> "quote all table or column names, to allow to use
reserved
words of dbms"
with your 1.6. that should fix the install problem.
Von: "Pongrácz István"
An: “eGroupware Developers” egroupware-developers@lists.sourceforge.net
Datum: Sat, 5 Sep 2009 22:28:31 +0200
Hello Everybody,
I tried to install the phpfreechat from the trunk into my existing 1.6.002
installation. Unfortunately the installation failed. After that I
installed
the trunk version of egroupware, which went fine, including PFC.
So, I expect, under 1.6.002 names of the columns has no ` borders around
and
that cause the problem. See below:
CreateTableSQL(‘egw_phpfreechat’,‘server C(32) NOTNULL, group C(64)
NOTNULL
PRIMARY, subgroup C(128) NOTNULL PRIMARY, leaf C(128) NOTNULL PRIMARY,
leafvalue X, timestamp I4 NOTNULL NOQUOTE DEFAULT 0’) sql=Array ( [0] =>
CREATE TABLE egw_phpfreechat ( server VARCHAR(32) NOT NULL, group
VARCHAR(64) NOT NULL, subgroup VARCHAR(128) NOT NULL, leaf VARCHAR(128)
NOT
NULL, leafvalue TEXT, timestamp INTEGER NOT NULL DEFAULT 0, PRIMARY KEY
(group, subgroup, leaf) )CHARACTER SET utf8 )
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ‘group
VARCHAR(64) NOT NULL, subgroup VARCHAR(’ at line 3
CreateIndexSql(‘egw_phpfreechat_server_group_subgroup_timestamp’,‘eg
w_phpfreechat’,Array
( [0] => server [1] => group [2] => subgroup [3] => timestamp ) ,False)
sql=Array ( [0] => ALTER TABLE egw_phpfreechat ADD INDEX
egw_phpfreechat_server_group_subgroup_timestamp (server, group,
subgroup,
timestamp) )
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ‘group,
subgroup,
timestamp)’ at line 1
Is that possible to fix this kind of issue?
Thank you,
István
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Stylite GmbH
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de
Geschäftsführer: Andre Keller, Gudrun Müller, Nigel Vickers, Ralf Becker
Handelsregister Kaiserslautern HRB 30575
USt-ID: DE214280951
SteuerNr. 44/667/1114/3
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
