Your message dated Fri, 20 Jan 2006 20:07:48 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Bug#349039: egroupware mysql backend not working properly
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 20 Jan 2006 18:30:37 +0000
>From [EMAIL PROTECTED] Fri Jan 20 10:30:37 2006
Return-path: <[EMAIL PROTECTED]>
Received: from iluvatar.caltech.edu ([131.215.35.27])
by spohr.debian.org with esmtp (Exim 4.50)
id 1F011x-0006Uu-7r
for [EMAIL PROTECTED]; Fri, 20 Jan 2006 10:30:37 -0800
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Johannes Graumann <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: egroupware mysql backend not working properly
Message-ID: <[EMAIL PROTECTED]>
X-Mailer: reportbug 3.18
Date: Fri, 20 Jan 2006 10:30:13 -0800
X-Debbugs-Cc: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-11.0 required=4.0 tests=BAYES_00,HAS_PACKAGE,
X_DEBBUGS_CC autolearn=ham version=2.60-bugs.debian.org_2005_01_02
Package: egroupware
Version: 1.0.0.009.dfsg-3-4
Severity: grave
Justification: renders package unusable
Upon installinng all applications I get the following error:
Database error: Invalid SQL: CREATE TABLE phpgw_history_log (history_id
int(11) auto_increment not null, history_record_id int NOT NULL,
history_appname varchar(64) NOT
NULL, history_owner int NOT NULL, history_status char(2) NOT NULL,
history_new_value text NOT NULL, history_timestamp datetime NOT NULL DEFAULT
'now', history_old_value
text NOT NULL, PRIMARY KEY(history_id),
INDEX(history_appname,history_record_id,history_status,history_timestamp ))
mysql Error: 1067 (Invalid default value for 'history_timestamp')
Function: schema_proc_mysql::createtable / schema_proc::createtable /
schema_proc::executescripts / setup_process::post_process /
setup_process::current /
setup_process::pass
Database error: Invalid SQL: CREATE TABLE phpgw_forum_threads (id int(11)
auto_increment not null, postdate datetime NOT NULL DEFAULT 'now', main int NOT
NULL, parent int
NOT NULL, cat_id int NOT NULL, for_id int NOT NULL, thread_owner int NOT NULL,
subject varchar(255) NOT NULL, stat smallint NOT NULL, thread int NOT NULL,
depth int NOT
NULL, pos int NOT NULL, n_replies int NOT NULL, PRIMARY KEY(id))
mysql Error: 1067 (Invalid default value for 'postdate')
Function: schema_proc_mysql::createtable / schema_proc::createtable /
schema_proc::executescripts / setup_process::post_process /
setup_process::current /
setup_process::pass
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads
(main,parent,cat_id,for_id,thread_owner,subject,stat,thread,depth,pos,n_replies)
VALUES ('1', '-1', '1',
'1',0, 'Example','0', '1', '0', '0', '1')
mysql Error: 1146 (Table 'egroupware.phpgw_forum_threads' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records /
setup_process::pass
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads
(main,parent,cat_id,for_id,thread_owner,subject,stat,thread,depth,pos,n_replies)
VALUES ('2', '1', '1',
'1',0,
'Re: Example','0', '1', '1', '1', '1')
mysql Error: 1146 (Table 'egroupware.phpgw_forum_threads' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records /
setup_process::pass
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads
(main,parent,cat_id,for_id,thread_owner,subject,stat,thread,depth,pos,n_replies)
VALUES ('3', '-1', '1',
'2',0, 'Example message','0', '3', '0', '0', '0')
mysql Error: 1146 (Table 'egroupware.phpgw_forum_threads' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records /
setup_process::pass
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads
(main,parent,cat_id,for_id,thread_owner,subject,stat,thread,depth,pos,n_replies)
VALUES ('4', '-1', '2',
'3',0, '','0', '4', '0', '0', '0')
mysql Error: 1146 (Table 'egroupware.phpgw_forum_threads' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records /
setup_process::pass sitemgr-link installed
The system then presents me with the following blurb:
You appear to be running version 1.0.0 of eGroupWare.
We will automatically update your tables/records to 1.0.0.009 but we highly
recommend backing up your tables in case the script causes damage to your data.
These automated scripts can easily destroy your data.
Please backup before going any further!
I hit "upgrade" and am being presented with these eroors:
Database error: Invalid SQL: ALTER TABLE phpgw_accounts ADD COLUMN
account_email varchar(100)
mysql Error: 1060 (Duplicate column name 'account_email')
Function: schema_proc_mysql::addcolumn / schema_proc::addcolumn /
phpgwapi_upgrade1_0_0 / setup_process::upgrade / setup_process::pass
Database error: Invalid SQL: ALTER TABLE phpgw_languages DROP COLUMN available
mysql Error: 1091 (Can't DROP 'available'; check that column/key exists)
Function: schema_proc_mysql::dropcolumn / schema_proc::dropcolumn /
phpgwapi_upgrade1_0_0_000 / setup_process::upgrade / setup_process::pass
"Recheck my installation" and "Create admin account" now makes everything look
ok. But under "Manage Applications" "forum" is listed as in
Need of installation and "phpgwapi" as "Requires reinstall or manual repair".
Hitting "Potential Problem" for the latter lets me know:
"phpgwapi" is broken because of a failed upgrade or install.
Some or all of its tables are missing.
You should either uninstall and then reinstall it, or attempt manual repairs.
trying to uninstall and reinstall phpgwapi leads to:
Database error: Invalid SQL: CREATE TABLE phpgw_history_log (history_id
int(11) auto_increment not null, history_record_id int NOT NULL,
history_appname varchar(64) NOT
NULL, history_owner int NOT NULL, history_status char(2) NOT NULL,
history_new_value text NOT NULL, history_timestamp datetime NOT NULL DEFAULT
'now', history_old_value
text NOT NULL, PRIMARY KEY(history_id),
INDEX(history_appname,history_record_id,history_status,history_timestamp ))
mysql Error: 1067 (Invalid default value for 'history_timestamp')
Function: schema_proc_mysql::createtable / schema_proc::createtable /
schema_proc::executescripts / setup_process::post_process /
setup_process::current
If I don't mess with the components shown to be broken, I get a halfway
functional system with a continuous stream of
mysql errors.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (550, 'unstable'), (500, 'testing'), (500, 'stable')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12-1-amd64-k8-smp
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages egroupware depends on:
ii egroupware-addressboo 1.0.0.009.dfsg-3-4 eGroupWare addressbook management
ii egroupware-bookmarks 1.0.0.009.dfsg-3-4 eGroupWare bookmark management app
ii egroupware-calendar 1.0.0.009.dfsg-3-4 eGroupWare calendar management app
ii egroupware-comic 1.0.0.009.dfsg-3-4 eGroupWare comic strip application
ii egroupware-core 1.0.0.009.dfsg-3-4 eGroupWare core modules
ii egroupware-developer- 1.0.0.009.dfsg-3-4 eGroupWare developer tools
ii egroupware-email 1.0.0.009.dfsg-3-4 eGroupWare E-mail client applicati
ii egroupware-emailadmin 1.0.0.009.dfsg-3-4 eGroupWare E-mail user administrat
ii egroupware-etemplate 1.0.0.009.dfsg-3-4 widget-based template system for e
ii egroupware-felamimail 1.0.0.009.dfsg-3-4 eGroupWare FeLaMiMail application
ii egroupware-filemanage 1.0.0.009.dfsg-3-4 eGroupWare file manager applicatio
ii egroupware-forum 1.0.0.009.dfsg-3-4 eGroupWare forum application
ii egroupware-ftp 1.0.0.009.dfsg-3-4 eGroupWare FTP application
ii egroupware-fudforum 1.0.0.009.dfsg-3-4 eGroupWare FUDforum application
ii egroupware-headlines 1.0.0.009.dfsg-3-4 eGroupWare headlines catcher appli
ii egroupware-infolog 1.0.0.009.dfsg-3-4 eGroupWare infolog application
ii egroupware-jinn 1.0.0.009.dfsg-3-4 content management system for eGro
ii egroupware-manual 1.0.0.009.dfsg-3-4 eGroupWare manual
ii egroupware-messenger 1.0.0.009.dfsg-3-4 eGroupWare messenger application
ii egroupware-news-admin 1.0.0.009.dfsg-3-4 eGroupWare news administration int
ii egroupware-phpbrain 1.0.0.009.dfsg-3-4 eGroupWare phpbrain application
ii egroupware-phpldapadm 1.0.0.009.dfsg-3-4 eGroupWare phpLDAPadmin applicatio
ii egroupware-phpsysinfo 1.0.0.009.dfsg-3-4 eGroupWare phpSysInfo application
ii egroupware-polls 1.0.0.009.dfsg-3-4 eGroupWare polling application
ii egroupware-projects 1.0.0.009.dfsg-3-4 eGroupWare projects management app
ii egroupware-registrati 1.0.0.009.dfsg-3-4 eGroupWare registration applicatio
ii egroupware-sitemgr 1.0.0.009.dfsg-3-4 eGroupWare site manager applicatio
ii egroupware-stocks 1.0.0.009.dfsg-3-4 eGroupWare stock management applic
ii egroupware-tts 1.0.0.009.dfsg-3-4 eGroupWare trouble ticket system a
ii egroupware-wiki 1.0.0.009.dfsg-3-4 eGroupWare wiki application
egroupware recommends no packages.
-- no debconf information
---------------------------------------
Received: (at 349039-done) by bugs.debian.org; 20 Jan 2006 19:07:59 +0000
>From [EMAIL PROTECTED] Fri Jan 20 11:07:59 2006
Return-path: <[EMAIL PROTECTED]>
Received: from ipx11302.ipxserver.de ([212.112.227.254] helo=gauss.credativ.com)
by spohr.debian.org with esmtp (Exim 4.50)
id 1F01c6-0006H7-Qe
for [EMAIL PROTECTED]; Fri, 20 Jan 2006 11:07:59 -0800
Received: from colt.pezone.net (dslb-084-063-022-007.pools.arcor-ip.net
[84.63.22.7])
(using TLSv1 with cipher RC4-MD5 (128/128 bits))
(No client certificate requested)
by gauss.credativ.com (Postfix) with ESMTP id 04F46D7648;
Fri, 20 Jan 2006 20:07:57 +0100 (CET)
From: Peter Eisentraut <[EMAIL PROTECTED]>
To: Johannes Graumann <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: Bug#349039: egroupware mysql backend not working properly
Date: Fri, 20 Jan 2006 20:07:48 +0100
User-Agent: KMail/1.8.3
References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <[EMAIL PROTECTED]>
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Already reported as #347480. Try using MySQL 4.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
