[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: bug? in 1.2.x: departments/accounts/projects change unpredictably on update or post



Two things that might help:

1)  What fields specifically are causing this problem?
2)  are there duplicate db fields (maybe from the SL days) which are
causing this?  The field to look at would be the id field of the
relevant tables.  So for projects:

SELECT id from projects
group by id
having count(*) > 1;

It's possible the id sequence could have been messed up causing
duplicate id's in some tables.  I have seen that a few times with SL.
With 1.2, though,. you should have gotten errors when upgrading.

Best Wishes,
Chris Travers