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]