Hi Ryan, I shortened the list up for the email.....should have checked it before sending it. A _us and _ca collection exists for each of the collections in the list.
Thanks, John -----Original Message----- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 11:04 AM To: CF-Talk Subject: RE: Verity Error: VdkADminPurge Is the collection name "health" or "health_us"? The error shows "health_us", but in your loop you are trying to purge "health". -----Original Message----- From: John Lucas [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 10:42 AM To: CF-Talk Subject: Verity Error: VdkADminPurge Good Morning, For over a year and a half our verity searches have been running successfully. As of late, we are getting continually getting the following error when searches are conducted. Collection failed to open: health_us That seems pretty obvious that there is a problem with the collection. When I run our script to refresh the collections, I get the following error: Error # -2 [fffe] VdkAdminPurge If I try to purge the collections using <cfset thelist = "health,wealth,people, property, profits, personal,business,global,industry "> <cfloop index="i" list="#thelist#" delimiters=","> <cfindex action="PURGE" collection="#i#"> <p><cfoutput>#i#</cfoutput> was purged</p> </cfloop> I get the following error: Error # -2 [fffe] VdkAdminPurge If I try to do the same above using cfcollection to delete the collection, I get this error: Error deleting collection: health However, if I delete or purge from within the Coldfusion Administrator, it seems to work just fine. We are running a W2K, IIS 5, CF 5.0 server and the collections are being populated from a SQL database. I have searched the archives of the list and the forums at Macromedia and can not find any specific information on troubleshooting the cause of this error. We are not using the K2 server either. If anyone can point me in the right direction here, I would greatly appreciate it. Regards, John Lucas MCR Interactive, Inc. http://www.mcrinteractive.com ofc. 800.474.5059 ext. 87 fax. 800.474.5059 mob. 815.955.3340 Customer Service Center: http://support.mcrinteractive.com/helpdesk/index.php ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
