Upgrade Help

[nubf14]

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.

[shaunw]

What edition of TimeTrex are you using?

[nubf14]

9.02

[shaunw]

That is the version, but what edition are you using?

[nubf14]

CE. Sorry

[shaunw]

Looks like at least one of your tables is corrupted, are you able to run manual queries from the PostgreSQL console by chance?

[nubf14]

Yes via pgadmin

[nubf14]

I can do cli as well.

[shaunw]

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);

[nubf14]

Worked thanks.