Upgrade stalls during database upgrade

Ask your questions regarding TimeTrex installation here.
Locked
blabj
Posts: 70
Joined: Wed Dec 26, 2007 5:09 pm

Upgrade stalls during database upgrade

Post by blabj »

Upgrading from 2.2.8 to 2.2.13.. during database upgrade, it stalls at 91%.. the apache error log is below.

Obviously trying to add a column to "station" which already exists.. but why??

[Thu Sep 11 16:35:06 2008] [error] [client 192.168.202.9] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1060: Duplicate column name 'work_code_definition'] in adodb_throw(alter table station add column work_code_definition varchar(250), )\n' in /var/www/localhost/htdocs/timetrex/classes/adodb/adodb-exceptions.inc.php:78\nStack trace:\n#0 /var/www/localhost/htdocs/timetrex/classes/adodb/adodb.inc.php(221): adodb_throw('mysqlt', 'adodb_throw', 1060, 'Duplicate colum...', 'alter table sta...', false, Object(ADODB_mysqlt))\n#1 /var/www/localhost/htdocs/timetrex/classes/adodb/adodb.inc.php(886): ADODB_TransMonitor('mysqlt', 'EXECUTE', 1060, 'Duplicate colum...', 'alter table sta...', false, Object(ADODB_mysqlt))\n#2 /var/www/localhost/htdocs/timetrex/classes/adodb/adodb.inc.php(861): ADOConnection->_Execute('alter table sta...', false)\n#3 /var/www/localhost/htdocs/timetrex/classes/modules/install/InstallSchema_Base.class.php(108): ADOConnection->Execute('alter table sta...')\n#4 /var/www/localhost/htdocs/timetrex/classes/modules/install/InstallSchema_Base.c in /var/www/localhost/htdocs/timetrex/classes/adodb/adodb-exceptions.inc.php on line 78, referer: http://timetrex.dainty.ca/interface/ins ... installer=
blabj
Posts: 70
Joined: Wed Dec 26, 2007 5:09 pm

Post by blabj »

Fixed it myself.. changed the following file:

/var/www/localhost/htdocs/timetrex/classes/modules/install/sql/mysql/1024A.sql

to be:

select 1;


and re-ran install..
Locked