Get the following error in the timetrex log:
DEBUG [L0065] [00990ms]: DBError::__construct(): postgres8 error: [-1: ERROR: could not create unique index "recurring_schedule_user_id"
DEBUG [L0065] [00990ms]: DBError::__construct(): DETAIL: Key (id)=(7) is duplicated.] in adodb_throw(
DEBUG [L0065] [00990ms]: DBError::__construct(): CREATE UNIQUE INDEX recurring_schedule_user_id ON recurring_schedule_user(id), )
DEBUG [L0065] [00990ms]: DBError::__construct():
DEBUG [L0073] [00990ms]: DBError::__construct(): End Exception...
---------------[ 09-Nov-2015 10:49:48 -0500 [1447084188.1628] (PID: 6389) ]--------------
The system states during install script that it cannot access the db even when test connection passes in previous screen.
Upgrade Help
Re: Upgrade Help
What edition of TimeTrex are you using?
Re: Upgrade Help
That is the version, but what edition are you using?
Re: Upgrade Help
Looks like at least one of your tables is corrupted, are you able to run manual queries from the PostgreSQL console by chance?
Re: Upgrade Help
Try running this query to delete any duplicate records from the recurring_schedule_user table, then try the upgrade again.
Code: Select all
DELETE FROM recurring_schedule_user a WHERE a.ctid <> (SELECT min(b.ctid) FROM recurring_schedule_user b WHERE a.id = b.id);