|
From: Bob S. <bo...@pr...> - 2001-04-24 20:30:33
|
This is just an announcement to everyone who plans to upgrade phpgroupware to 0.9.10 and who currently uses phpgwtimetrack. The current release of phpgroupware has what I consider a few serious bugs when it comes to upgrading the addressbook tables properly, especially when timetrack is installed. There are currently 2 issues involved, which are: 1. When setup upgrades the addressbook table by copying it to phpgw_addressbook, it re-assigns integer id's in a consecutive order, but if anyone has deleted contacts, then the original data will not neccessarily be consecutive in the first place, so any tables which reference the contact by an id will have incorrect data returned. 2. Again, while the addressbook is being updated, company name information is blindly pulled from the company field, ignoring any company_id fields which are joined against the customers table to get the company name from an ID. Supposedly a fix was added to handle this situation, but it must have got lost somewhere in cvsland. Do not despair. Thankfully, the current setup leaves the original addressbook table unchanged and does not drop it. This is a good thing. I will have an option available for those upgrading timetracker which will allow re-doing the upgrade of the addressbook table to another phpgw_addressbook table in a way that will preserve all data. I hope to have a beta release of phpgwtimetracker for phpgroupware 0.9.10 available within the next week or so. If anyone would like an advance copy of what I have so far, let me know. I haven't bothered with CVS in quite awhile, so you can't get it there. _____________________________ Bob Schader CAD Systems Admin Product Design Intl., Inc. 4880 36th St. SE, Suite 100 Grand Rapids, MI 49512 (616) 667-2600 x104 |