Anonymous

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