Mandi! Marco Gaiarin
In chel dì si favelave…
- in setup, phpgwapi display that need ‘manual intervention’: using
egw hit me at least the missing of a field in egw_ table relative to
cron (i don’t remember now…). I’ve not dig this issue.
Ok, very simple: the egw_async table have field (id, next, times, …)
insted of (async_id, async_next, …). Fixed with some ‘alter table’…
In next days i will redo the entire process with some more time, and
i’ll try to wrote down some more precise data.
Some more precise log of the upgrade:
0.9.16.001 -> 1.0.0 OK, no error at all.
process->upgrade(): phpgwapi(1.0.0 --> 1.6.002): running phpgwapi_upgrade1_0_0()
AlterColumnSQL(‘phpgw_accounts’,‘account_email’,Array ( [type] => varchar [precision] => 100 ) ) sql=Array ( [0] => ALTER TABLE phpgw_accounts ADD COLUMN account_email VARCHAR(100) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
–> 1.0.0.000
process->upgrade(): phpgwapi(1.0.0.000 --> 1.6.002): running phpgwapi_upgrade1_0_0_000()
DropColumnSQL(‘phpgw_languages’,‘available’,’’) sql=Array ( [0] => ALTER TABLE phpgw_languages DROP COLUMN available )
ERROR: current transaction is aborted, commands ignored until end of transaction block
–> 1.0.0.001
1.0.0.001 -> 1.0.0.004 OK
process->upgrade(): phpgwapi(1.0.0.004 --> 1.6.002): running phpgwapi_upgrade1_0_0_004()
Error: Ignoring unknown column-type ‘()’ !!!
schema_proc::_egw2adodb_columndef / schema_proc::RenameColumn / phpgwapi_upgrade1_0_0_004() / setup_process::upgrade / setup_process::pass
RenameColumnSQL(‘phpgw_async’,‘id’,‘async_id’) sql=Array ( [0] => ALTER TABLE phpgw_async RENAME COLUMN id TO async_id )
ERROR: current transaction is aborted, commands ignored until end of transaction block
[… and all the async filed similar …]
–> 1.0.1.001
1.0.1.001 -> 1.0.1.002 OK.
process->upgrade(): phpgwapi(1.0.1.002 --> 1.6.002): running phpgwapi_upgrade1_0_1_002()
Error: Ignoring unknown column-type ‘()’ !!!
schema_proc::_egw2adodb_columndef / schema_proc::RenameColumn / phpgwapi_upgrade1_0_1_002() / setup_process::upgrade / setup_process::pass
RenameColumnSQL(‘phpgw_vfs’,‘file_id’,‘vfs_file_id’) sql=Array ( [0] => ALTER TABLE phpgw_vfs RENAME COLUMN file_id TO vfs_file_id )
ERROR: current transaction is aborted, commands ignored until end of transaction block
[… and all the other vfs field …]
–> 1.0.1.003
process->upgrade(): phpgwapi(1.0.1.003 --> 1.6.002): running phpgwapi_upgrade1_0_1_003()
CreateTableSQL(‘egw_api_content_history’,‘sync_appname C(60) NOTNULL, sync_contentid C(60) NOTNULL, sync_added T NOTNULL, sync_modified T NO TNULL, sync_deleted T NOTNULL, sync_id I AUTOINCREMENT NOTNULL PRIMARY, sync_guid C(120) NOTNULL, sync_changedby I4 NOTNULL’) sql=Array ( [0] => CREATE TABLE egw_api_content_history ( sync_appname VARCHAR(60) NOT NULL, sync_contentid VARCHAR(60) NOT NULL, sync_added TIMESTAMP NOT NULL, sync_modified TIMESTAMP NOT NULL, sync_deleted TIMESTAMP NOT NULL, sync_id SERIAL, sync_guid VARCHAR(120) NOT NULL, sync_changedby IN T4 NOT NULL, PRIMARY KEY (sync_id) ) )
ERROR: current transaction is aborted, commands ignored until end of transaction block
[… and subsequent index creation fail, of course …]
–> 1.0.1.004
process->upgrade(): phpgwapi(1.0.1.004 --> 1.6.002): running phpgwapi_upgrade1_0_1_004()
[… some insert/delete/drop… some on egw_api_content_history, but
seems not to fail… boh… ]
–> 1.0.1.005
1.0.1.005 -> 1.3.007 OK
process->upgrade(): phpgwapi(1.3.007 --> 1.6.002): running phpgwapi_upgrade1_3_007()
DropColumnSQL(‘egw_accounts’,‘account_email’,‘account_id I AUTOINCREMENT NOTNULL PRIMARY, account_lid C(64) NOTNULL, account_pwd C(100) NOTNULL, account_lastlogin I4, account_lastloginfrom C(255), account_lastpwd_change I4, account_status C(1) NOTNULL DEFAULT ‘A’, account_expires I4, account_type C(1), account_primary_group I4 NOTNULL NOQUOTE DEFAULT 0’) sql=Array ( [0] => ALTER TABLE egw_accounts DROP COLUMN account_email )
ERROR: column “account_email” of relation “egw_accounts” does not exist
–> 1.3.008
1.3.008 -> 1.5.016 OK
process->upgrade(): phpgwapi(1.5.016 --> 1.6.002): running phpgwapi_upgrade1_5_016()
DropColumnSQL(‘egw_api_content_history’,‘sync_guid’,’’) sql=Array ( [0] => ALTER TABLE egw_api_content_history DROP COLUMN sync_guid )
ERROR: la relazione “egw_api_content_history” non esiste
–> 1.5.017
So, apart some sparse error, seems that the most trouble came from
phpgw_async and egw_api_content_history tables.
I hope in some quick fix. ;-)))
–
Please note that free software should be interpreted as free speach
while most seem to interprete it as free lunch.
(Hugo van der Kooij)
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
