I have seen similar behaviors in the 1.01 db admin of Spectra or upgrades from 1.01. I believe in my case the behavior was caused by existing wddx files in the temp directory used by the db admin during the import/export or upgrade. This could have occurred because the same directory was used to move multiple CODBs and never cleared in between. Perhaps the upgrade was restarted at some point. Regardless, the simplest fix is to repeat the updgrade of the CODB. Spectra 1.51 allows you to do the upgrade from within the 151 webtop.
The alternative of examining and eliminating all duplicates would likely be a difficult task. Regards, Ken Smith Certified ColdFusion 5 Developer Spectra Product Support Macromedia -----Original Message----- From: Stephen Collins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 6:12 PM To: Spectra-Talk Subject: Multiple objects -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Included below are some words from a technically savvy client. The client is upgrading from Spectra 1.01 to 1.51. Can anyone help with what this might be? > Also, as discussed, there are two tables in the ParlcomObjectsSQL > database which were upgraded last month but no longer have Primary > Keys or Indexes. The tables are Objects and Properties. The indexes > and > keys were on > the tables prior to the upgrade, but because there are duplicate > records on > these tables, I am unable to create the Primary Keys or indexes. > > What is the significance of these duplicate records on these > tables and what > effects could this having on the performance/operation of the Cold > Fusion/Spectra for our site? How can this be resolved? Steve ======================================================== Stephen Collins, Technical Consultant - ACIS (Australia) Allaire Certified ColdFusion 5 Developer Work : [EMAIL PROTECTED] Personal : [EMAIL PROTECTED] ICQ UIN : 56321783 Yahoo! : trib "Before I got into triathlon, I was a normal person." -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.5.8 iQA/AwUBPA4b/H65o/U9+lJVEQLs/gCgrZUFF7QTgJDffGKeqwqnng+bOfoAniMz aX7ZkMYruFgRok/wlY8X1Itm =5osr -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
