Package: egroupware
Version: 1.0.0.009.dfsg-3-4
Severity: normal
After a fresh install of the egroupware package: during configuration
(after enabling mysql and creating header file) the install of phpgwapi
fails with an error of this type:
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')
I am not able to reproduce exactly the same situation as for the first
install because I do not yet know how to clear the faulty db tables from
the first install (uninstalling all applications from within egroup does
not seem to be complete - I do not know how to do that manually yet). But
I am 100% sure the same error concerning this invalid default value
occured then too.
During the fresh install the install of the forum application failed
too.
Neither upgrading to the latest versions of the applications solves the
problem.
All the error messages after an uninstallation of all applications from
withing egroup + purge-reinstall of egroup debian packages + install of
applications withing egroup:
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
Best regards,
Tore
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.17-1-686
Locale: LANG=nb_NO.UTF-8, LC_CTYPE=nb_NO.UTF-8 (charmap=UTF-8)
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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
