App install/remove/upgrade: process->current(): Incoming status: calendar,status: U process->current(): Including: /var/www/vhosts/www.dignition.de/subdomains/partners/business/calendar/setup/tables_current.inc.php _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "auto" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: int(11) auto_increment not null NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: varchar(255) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "30" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(30) _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(255) _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "2" } _GetFieldSQL(): Default="2" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 2 _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "10" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(10) _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "80" ["nullable"]=> bool(false) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: varchar(80) NOT NULL DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "text" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: text _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(255) _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "auto" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: int(11) auto_increment not null NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(4) "char" ["precision"]=> string(1) "2" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: char(2) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "50" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: varchar(50) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) ["default"]=> string(0) "" } _GetFieldSQL(): Default="" _GetFieldSQL(): Outgoing SQL: varchar(255) _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(4) "char" ["precision"]=> string(1) "1" ["nullable"]=> bool(true) ["default"]=> string(1) "A" } _GetFieldSQL(): Default="A" _GetFieldSQL(): Calling TranslateDefault for "A" _GetFieldSQL(): Outgoing SQL: char(1) DEFAULT ''A'' _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(1) "1" ["nullable"]=> bool(false) ["default"]=> string(0) "" } _GetFieldSQL(): Default="" _GetFieldSQL(): Outgoing SQL: varchar(1) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "4" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: int NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "40" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: varchar(40) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(false) ["default"]=> string(0) "" } _GetFieldSQL(): Default="" _GetFieldSQL(): Outgoing SQL: varchar(255) NOT NULL CREATE TABLE phpgw_cal ( cal_id int(11) auto_increment not null NOT NULL, uid varchar(255) NOT NULL, owner bigint NOT NULL, category varchar(30), groups varchar(255), datetime bigint, mdatetime bigint, edatetime bigint, priority bigint NOT NULL DEFAULT 2, cal_type varchar(10), is_public bigint NOT NULL DEFAULT 1, title varchar(80) NOT NULL DEFAULT 1, description text, location varchar(255), reference bigint NOT NULL DEFAULT 0, PRIMARY KEY(cal_id) ); CREATE TABLE phpgw_cal_holidays ( hol_id int(11) auto_increment not null NOT NULL, locale char(2) NOT NULL, name varchar(50) NOT NULL, mday bigint NOT NULL DEFAULT 0, month_num bigint NOT NULL DEFAULT 0, occurence bigint NOT NULL DEFAULT 0, dow bigint NOT NULL DEFAULT 0, observance_rule bigint NOT NULL DEFAULT 0, PRIMARY KEY(hol_id) ); CREATE TABLE phpgw_cal_repeats ( cal_id bigint NOT NULL, recur_type bigint NOT NULL, recur_use_end bigint DEFAULT 0, recur_enddate bigint, recur_interval bigint DEFAULT 1, recur_data bigint DEFAULT 1, recur_exception varchar(255) ); 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) ); CREATE TABLE phpgw_cal_extra ( cal_id int NOT NULL, cal_extra_name varchar(40) NOT NULL, cal_extra_value varchar(255) NOT NULL, PRIMARY KEY(cal_id,cal_extra_name) ); _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "auto" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: int(11) auto_increment not null NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: varchar(255) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "30" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(30) _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(255) _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "2" } _GetFieldSQL(): Default="2" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 2 _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "10" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(10) _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "80" ["nullable"]=> bool(false) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: varchar(80) NOT NULL DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "text" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: text _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: varchar(255) _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 Create Table phpgw_cal _GetFieldSQL(): Incoming ARRAY: array(2) { ["type"]=> string(4) "auto" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: int(11) auto_increment not null NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(4) "char" ["precision"]=> string(1) "2" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: char(2) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(7) "varchar" ["precision"]=> string(2) "50" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: varchar(50) NOT NULL _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 Create Table phpgw_cal_holidays _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) } _GetFieldSQL(): Outgoing SQL: bigint NOT NULL _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(3) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) } _GetFieldSQL(): Outgoing SQL: bigint _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(true) ["default"]=> string(1) "1" } _GetFieldSQL(): Default="1" _GetFieldSQL(): Outgoing SQL: bigint DEFAULT 1 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(3) "255" ["nullable"]=> bool(true) ["default"]=> string(0) "" } _GetFieldSQL(): Default="" _GetFieldSQL(): Outgoing SQL: varchar(255) Create Table phpgw_cal_repeats _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(3) "int" ["precision"]=> string(1) "8" ["nullable"]=> bool(false) ["default"]=> string(1) "0" } _GetFieldSQL(): Default="0" _GetFieldSQL(): Outgoing SQL: bigint NOT NULL DEFAULT 0 _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(4) "char" ["precision"]=> string(1) "1" ["nullable"]=> bool(true) ["default"]=> string(1) "A" } _GetFieldSQL(): Default="A" _GetFieldSQL(): Calling TranslateDefault for "A" _GetFieldSQL(): Outgoing SQL: char(1) DEFAULT ''A'' _GetFieldSQL(): Incoming ARRAY: array(4) { ["type"]=> string(7) "varchar" ["precision"]=> string(1) "1" ["nullable"]=> bool(false) ["default"]=> string(0) "" } _GetFieldSQL(): Default="" _GetFieldSQL(): Outgoing SQL: varchar(1) NOT NULLDatabase 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'A'', cal_type varchar(1) NOT NULL, PRIMARY KEY(cal_id,cal_login) Create Table Failed For phpgw_cal_user process->current(): Failed for calendar,status: U process->current(): Outgoing status: calendar,status: F ##### tables installed, unless there are errors printed above. get_langs(): checking db... add_langs(): chose these langs: Array ( ) process->add_langs(): Translations added for calendar ##### Translations Added. ##### Go back