Greetings all happy holidays.
I have been attempting to move a egw install from and old install to a newer server.
I can log into “set up” and begin upgrading applications starting with phpwapi
I believe it runs the file tables_update.inc.php
process->upgrade(): Incoming : appname: phpgwapi, version: 1.6.001, status: U
process->upgrade(): phpgwapi(1.6.001 --> 1.8.004): running phpgwapi_upgrade1_6_001() --> 1.7.001
process->upgrade(): phpgwapi(1.7.001 --> 1.8.004): running phpgwapi_upgrade1_7_001() --> 1.7.002
process->upgrade(): phpgwapi(1.7.002 --> 1.8.004): running phpgwapi_upgrade1_7_002() --> 1.7.003
process->upgrade(): phpgwapi(1.7.003 --> 1.8.004): running phpgwapi_upgrade1_7_003() --> 1.8.001
process->upgrade(): phpgwapi(1.8.001 --> 1.8.004): running phpgwapi_upgrade1_8_001() --> 1.8.002
process->upgrade(): phpgwapi(1.8.002 --> 1.8.004): running phpgwapi_upgrade1_8_002() --> 1.8.003
process->upgrade(): phpgwapi(1.8.003 --> 1.8.004): running phpgwapi_upgrade1_8_003()
DropTable(‘egw_links’) sql=Array ( [0] => DROP TABLE “egw_links” )
ERROR: current transaction is aborted, commands ignored until end of transaction block
CreateTableSQL(‘egw_links’,‘link_id I AUTOINCREMENT NOTNULL PRIMARY, link_app1 C(25) NOTNULL, link_id1 C(50) NOTNULL, link_app2 C(25) NOTNULL, link_id2 C(50) NOTNULL, link_remark C(100), link_lastmod I8 NOTNULL, link_owner I4 NOTNULL, deleted T’) sql=Array ( [0] => CREATE TABLE “egw_links” ( “link_id” SERIAL, “link_app1” VARCHAR(25) NOT NULL, “link_id1” VARCHAR(50) NOT NULL, “link_app2” VARCHAR(25) NOT NULL, “link_id2” VARCHAR(50) NOT NULL, “link_remark” VARCHAR(100), “link_lastmod” INT8 NOT NULL, “link_owner” INT4 NOT NULL, “deleted” TIMESTAMP, PRIMARY KEY (“link_id”) ) )
Is there any way i can get the specif snippet of SQL that is causing the rollback?
Cheers
