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

[Dave Hall]

Kai Hofmann <address@hidden> wrote:

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

I am happy to apply setup fixes, as submitted on the tracker.  But I
think the scope of the overall changes to the schema are too great for
it to be included in 16.  We are nearing the release of RC2, and I want
RC2 to be a short cycle.  These schema changes would appear to create a
fair bit of work and require more testing.

What do others think?

Cheers

Dave

> 
> 
> 
> Database error: Invalid SQL: CREATE TABLE phpgw_felamimail_cache 
> (accountidINTEGER NOT NULL, hostname VARCHAR(60) NOT NULL, 
> accountname VARCHAR(200)
> NOT NULL, foldername VARCHAR(200) NOT NULL, uid INTEGER NOT NULL, 
> subjectLONG, striped_subject LONG, sender_name VARCHAR(120), 
> sender_addressVARCHAR(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 
> (accountidINTEGER NOT NULL, hostname VARCHAR(60) NOT NULL, 
> accountname VARCHAR(200)
> NOT NULL, foldername VARCHAR(200) NOT NULL, uid INTEGER NOT NULL, 
> subjectLONG, striped_subject LONG, sender_name VARCHAR(120), 
> sender_addressVARCHAR(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 
> alreadyexists;-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 
> alreadyexists;-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_catINTEGER 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 
> alreadyexists;-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/
> 
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>