[Phpgroupware-developers] More problems found during the SAP DB port

[Kai Hofmann]

As it seems I have to patch a lot more of te phpgw, because of reserved
identifiers.
The errors on the bottom have to be evaluated a bit more before I exactly
know whats the problem there.




Database error: Invalid SQL: CREATE TABLE phpgw_felamimail_cache (accountid
INTEGER NOT NULL, hostname VARCHAR(60) NOT NULL, accountname VARCHAR(200)
NOT NULL, foldername VARCHAR(200) NOT NULL, uid INTEGER NOT NULL, subject
LONG, striped_subject LONG, sender_name VARCHAR(120), sender_address
VARCHAR(120), to_name VARCHAR(120), to_address VARCHAR(120), date
VARCHAR(120), size INTEGER, attachments VARCHAR(120), PRIMARY
KEY(accountid,hostname,accountname,foldername,uid))
ODBC Error: 37000 ([SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-7006 POS(166) Reserved identifier not allowed.)

date?

---

Database error: Invalid SQL: CREATE TABLE phpgw_p_projects (id SERIAL NOT
NULL, num VARCHAR(255) NOT NULL, owner INTEGER NOT NULL DEFAULT '0', access
VARCHAR(7), entry_date INTEGER NOT NULL DEFAULT '0', start_date INTEGER NOT
NULL DEFAULT '0', end_date INTEGER NOT NULL DEFAULT '0', coordinator INTEGER
NOT NULL DEFAULT '0', customer INTEGER NOT NULL DEFAULT '0', status
VARCHAR(9) NOT NULL DEFAULT 'active', descr LONG, title VARCHAR(255) NOT
NULL, budget DECIMAL(20,2) NOT NULL DEFAULT '0', category INTEGER NOT NULL
DEFAULT '0', parent INTEGER NOT NULL DEFAULT '0', time_planned INTEGER NOT
NULL DEFAULT '0', date_created INTEGER NOT NULL DEFAULT '0', processor
INTEGER NOT NULL DEFAULT '0', investment_nr VARCHAR(50), pcosts
DECIMAL(20,2) NOT NULL DEFAULT '0', main INTEGER NOT NULL DEFAULT '0', level
INTEGER NOT NULL DEFAULT '0', previous INTEGER NOT NULL DEFAULT '0', PRIMARY
KEY(id), UNIQUE(num))
ODBC Error: 37000 ([SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-7006 POS(52) Reserved identifier not allowed.)

id?

---

Database error: Invalid SQL: CREATE TABLE phpgw_cal (cal_id SERIAL NOT NULL,
uid VARCHAR(255) NOT NULL, owner INTEGER NOT NULL, category VARCHAR(30),
groups VARCHAR(255), datetime INTEGER, mdatetime INTEGER, edatetime INTEGER,
priority INTEGER NOT NULL DEFAULT '2', cal_type VARCHAR(10), is_public
INTEGER NOT NULL DEFAULT '1', title VARCHAR(80) NOT NULL DEFAULT '1',
description LONG, location VARCHAR(255), reference INTEGER NOT NULL DEFAULT
'0', PRIMARY KEY(cal_id))
ODBC Error: 37000 ([SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-7006 POS(49) Reserved identifier not allowed.)

datetime?

---

Database error: Invalid SQL: CREATE TABLE phpgw_felamimail_cache (accountid
INTEGER NOT NULL, hostname VARCHAR(60) NOT NULL, accountname VARCHAR(200)
NOT NULL, foldername VARCHAR(200) NOT NULL, uid INTEGER NOT NULL, subject
LONG, striped_subject LONG, sender_name VARCHAR(120), sender_address
VARCHAR(120), to_name VARCHAR(120), to_address VARCHAR(120), date
VARCHAR(120), size INTEGER, attachments VARCHAR(120), PRIMARY
KEY(accountid,hostname,accountname,foldername,uid))
ODBC Error: 37000 ([SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-7006 POS(166) Reserved identifier not allowed.)

date?

---

Database error: Invalid SQL: CREATE TABLE phpgw_p_projects (id SERIAL NOT
NULL, num VARCHAR(255) NOT NULL, owner INTEGER NOT NULL DEFAULT '0', access
VARCHAR(7), entry_date INTEGER NOT NULL DEFAULT '0', start_date INTEGER NOT
NULL DEFAULT '0', end_date INTEGER NOT NULL DEFAULT '0', coordinator INTEGER
NOT NULL DEFAULT '0', customer INTEGER NOT NULL DEFAULT '0', status
VARCHAR(9) NOT NULL DEFAULT 'active', descr LONG, title VARCHAR(255) NOT
NULL, budget DECIMAL(20,2) NOT NULL DEFAULT '0', category INTEGER NOT NULL
DEFAULT '0', parent INTEGER NOT NULL DEFAULT '0', time_planned INTEGER NOT
NULL DEFAULT '0', date_created INTEGER NOT NULL DEFAULT '0', processor
INTEGER NOT NULL DEFAULT '0', investment_nr VARCHAR(50), pcosts
DECIMAL(20,2) NOT NULL DEFAULT '0', main INTEGER NOT NULL DEFAULT '0', level
INTEGER NOT NULL DEFAULT '0', previous INTEGER NOT NULL DEFAULT '0', PRIMARY
KEY(id), UNIQUE(num))
ODBC Error: 37000 ([SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access
violation;-7006 POS(52) Reserved identifier not allowed.)

id?

---
---

Database error: Invalid SQL: CREATE TABLE phpgw_anglemail (account_id
VARCHAR(20) NOT NULL, data_key VARCHAR(255) NOT NULL, content LONG NOT NULL,
PRIMARY KEY(account_id,data_key))
ODBC Error: S0001 ([SAP AG][SQLOD32 DLL][SAP DB]Base table or view already
exists;-6000 POS(14) Duplicate table name:PHPGW_ANGLEMAIL.)

---

Database error: Invalid SQL: CREATE TABLE phpgw_etemplate (et_name
VARCHAR(80) NOT NULL, et_template VARCHAR(20) NOT NULL, et_lang VARCHAR(5)
NOT NULL, et_group INTEGER NOT NULL DEFAULT '0', et_version VARCHAR(20) NOT
NULL, et_data LONG, et_size VARCHAR(128), et_style LONG, et_modified INTEGER
NOT NULL DEFAULT '0', PRIMARY
KEY(et_name,et_template,et_lang,et_group,et_version))
ODBC Error: S0001 ([SAP AG][SQLOD32 DLL][SAP DB]Base table or view already
exists;-6000 POS(14) Duplicate table name:PHPGW_ETEMPLATE.)

---

Database error: Invalid SQL: CREATE TABLE phpgw_todo (todo_id SERIAL NOT
NULL, todo_id_parent INTEGER NOT NULL DEFAULT '0', todo_id_main INTEGER NOT
NULL DEFAULT '0', todo_level SMALLINT NOT NULL DEFAULT '0', todo_owner
INTEGER NOT NULL DEFAULT '0', todo_access VARCHAR(7) NOT NULL, todo_cat
INTEGER NOT NULL DEFAULT '0', todo_title VARCHAR(255) NOT NULL, todo_des
LONG NOT NULL, todo_pri INTEGER NOT NULL, todo_status INTEGER NOT NULL,
todo_datecreated INTEGER NOT NULL, todo_startdate INTEGER NOT NULL,
todo_enddate INTEGER NOT NULL DEFAULT '0', entry_date INTEGER NOT NULL
DEFAULT '0', PRIMARY KEY(todo_id))
ODBC Error: S0001 ([SAP AG][SQLOD32 DLL][SAP DB]Base table or view already
exists;-6000 POS(14) Duplicate table name:PHPGW_TODO.)



Greetings

  Kai

-- 
*****    Open Source und Linux im professionellen Einsatz    *****
**  komplexe Mailserver, Groupware, Office: sprechen Sie uns an **
Dipl.-Inform. Kai Hofmann                    Team Softwarelösungen
pro|business AG, EXPO Plaza 1 (Deutscher Pavillon), 30539 Hannover
E-Mail: address@hidden,   Tel.: 0511/60066-332, Fax: -355
WWW: http://www.probusiness.de/