RE: [Phpgroupware-developers] phpgroupware installation error

[Scott Killen]

I am installing from the tarball + latest cvs update;  I am following
installation instructions.

Some of the modules will not install due to MySQl syntax errors.

For instance:  calendar gives the following error message on install:

Database error: Invalid SQL: CREATE TABLE phpgw_cal_user (cal_id bigint NOT
NULL DEFAULT 0, cal_login bigint NOT NULL DEFAULT 0, cal_status char(1)
DEFAULT ''A'', cal_type varchar(1) NOT NULL, PRIMARY KEY(cal_id,cal_login))
MySQL Error: 1064 (You have an error in your SQL syntax near 'A'', cal_type
varchar(1) NOT NULL, PRIMARY KEY(cal_id,cal_login))' at line 3)

If I manually set up the table using CREATE TABLE phpgw_cal_user (cal_id
bigint NOT NULL DEFAULT 0, cal_login bigint NOT NULL DEFAULT 0, cal_status
char(1) DEFAULT 'A', cal_type varchar(1) NOT NULL, PRIMARY
KEY(cal_id,cal_login)) everything works fine, but the calendar won't install
because the tables already exist...

Other application have similar issues...

Any suggestions?

Thanks,

Scott

-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Brian Johnson
Sent: 07/01/2004 10:20 AM
To: address@hidden
Subject: RE: [Phpgroupware-developers] phpgroupware installation error

People seem to have numerous problems using the debs

I recommend getting the tar ball or straight from cvs

You don't have to compile it or anything so it is very easy to do



Scott Killen (address@hidden) wrote:
>
> Yes.
>
> These are the packages available on http://debs.phpgroupware.org.  I 
> have downloaded them multiple times.  If the problem is an old sed 
> version, then the package dependencies should indicate that a newer 
> version of the sed package is needed.  I am using sed package 3.02-8.  
> I will try upgrading to
> 4.09-5 and see if that fixes anything.  I will post results.
>
> Thanks,
>
> Scott
>
> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden 
> On Behalf Of Chris Weiss
> Sent: 07/01/2004 9:25 AM
> To: address@hidden
> Subject: Re: [Phpgroupware-developers] phpgroupware installation error
>
> bad download or old sed version maybe?
>
> have you tried these? http://debs.phpgroupware.org/ (note that this 
> also contains updated php packages too so take care when using it)
>
>
> ----- Original Message -----
> From: Scott Killen <address@hidden>
> Date: Thu, 1 Jul 2004 09:15:41 -0400
> Subject: [Phpgroupware-developers] phpgroupware installation error
> To: address@hidden
>
>
>
>
>
>
>
> I am installing the
> phpgroupware debian package from scratch.  I pick the apache server, 
> the mysql database, enter the appropriate passwords and choose to 
> delete data on purge.
>
>
>
> I get the following
> error:
>
>
>
> Setting up
> phpgroupware (0.9.16.000-1-1) ...
> sed: -e expression #1, char 618: Extra characters after command
>
>
>
> Does anyone have any
> suggestions?
>
>
>
> Thanks,
>
>
>
> Scott
>
>
>
> noname - 1K Download
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
>
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
>
>



_______________________________________________
Phpgroupware-developers mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers