[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Phpgroupware-developers] phpgroupware installation error
From: |
Scott Killen |
Subject: |
RE: [Phpgroupware-developers] phpgroupware installation error |
Date: |
Thu, 1 Jul 2004 12:09:58 -0400 |
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
RE: [Phpgroupware-developers] phpgroupware installation error, Brian Johnson, 2004/07/01