The problem turned out to be an issue caused by the upgrade from b211 to b220 - the dmFile had very subtle datatype differences.
If this is the problem, you can try the following: *** back up database *** rename dmFile table eg dmFile_orig deploy the dmFile type then select all the fields from dmFile_orig and insert into dmFile (you have to name all the fields as doing a select * may get the columns in a different otder than the table you are inserting into) On 24-Nov-2004 11:23:59 ZE10, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Hi, > > We are getting the same error when trying to upload files to dmHTML . Have > you made any progress on this, or does anyone else have any suggestions? > > We are running pretty much the same configuration (Farcry 2.2, IIS, Windows > 2000, SQL Server) on our test server, but the file upload has no problems. > On the production server, we don't have a file upload problem on our custom > type file step, which has not been modified for this version of Farcry. > > In addition to the plp error with dmHTML, on trying to create a dmFile > object we get this error: > > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error > converting float to data type numeric. > > > > > Please try the following: > Enable Robust Exception Information to provide greater detail about the > source of errors. In the Administrator, click Debugging & Logging > > Debugging Settings, and select the Robust Exception Information option. > Check the ColdFusion documentation to verify that you are using the correct > syntax. > Search the Knowledge Base to find a solution to your problem. > > > Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) > Remote Address 172.16.159.166 > Referrer > http://www.aftrs.edu.au/farcry/navajo/edit.cfm?objectId=64003C4C-2A54-23A3-69D5E084F6D7B1B7&TYPENAME=dmFile > Date/Time 23-Nov-04 04:56 PM Cheers, > Natalie > > "Mark Wheeler" <[EMAIL PROTECTED]> > > > > "Mark Wheeler" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > > 17/11/04 04:13 PM > > Please respond to > "FarCry Developers" <[EMAIL PROTECTED]> > > > To > "FarCry Developers" <[EMAIL PROTECTED]> > > > cc > > > > Subject > [farcry-dev] Error when trying to upload a file in Farcry > > Hi > > Am creating some HTML type pages that need files uploaded, when I try to > upload the file from the site manager I get the following error message: > > Files > Existing Files > Title Preview Edit Delete > PLP ERROR!an error has occured with this plp. > PLP Step: files > PLP template: /farcry/Patersons/packages/types/_psFloats/plpEdit/files.cfm > ColdFusion Error Data > -------------------------------------------------------------------------------- > object of coldfusion.runtime.UndefinedElementException > > Methods getMessage (returns java.lang.String) > getResolvedname (returns java.lang.String) > getErrNumber (returns int) > getLocalizedMessage (returns java.lang.String) > getType (returns java.lang.String) > getString (returns java.lang.String) > getRootCause (returns java.lang.Throwable) > setLocale (returns void) > findThrowableTarget (returns int) > findAdvancedCFTarget (returns int) > findCustomTarget (returns int) > unwrap (returns java.lang.Throwable) > getDetail (returns java.lang.String) > printStackTrace (returns void) > printStackTrace (returns void) > printStackTrace (returns void) > fillInStackTrace (returns java.lang.Throwable) > toString (returns java.lang.String) > initCause (returns java.lang.Throwable) > getCause (returns java.lang.Throwable) > getStackTrace (returns [Ljava.lang.StackTraceElement;) > setStackTrace (returns void) > hashCode (returns int) > getClass (returns java.lang.Class) > wait (returns void) > wait (returns void) > wait (returns void) > equals (returns boolean) > notify (returns void) > notifyAll (returns void) > > objectType class java.lang.Class > container class java.lang.Object > element FILENAME > > > Have looked through all the files.cfm code at the form.filename and all > seems ok, can anyone shed any light please. > > Regards > > MARK WHEELER > Internet Systems Administrator > > Direct Line: (+61 8) 9263 1277 > Facsimile: (+61 8) 9263 1237 > Email: [EMAIL PROTECTED] > Website: www.patersonssecurities.com.au > > Patersons Securities Limited > Level 23, Exchange Plaza > 2 The Esplanade > PERTH WA 6000 > > AFSL No. 239 052 > > > > -------------------------------------------------------------------------------- > > IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS: > > This document is intended to provide general securities advice only, and > has been prepared without taking account of your objectives, financial > situation or needs and therefore before acting on advice contained in this > document you should consider its appropriateness having regard to your > objectives, financial situation and needs. If any advice in this document > relates to the acquisition or possible acquisition of a particular financial > product, you should obtain a copy of and consider the Product Disclosure > Statement for that product before making any decision. > > While this document is based on the information from sources which are > considered reliable, Patersons, its directors, employees and consultants do > not represent, warrant or guarantee, expressly or impliedly, that the > information contained in this document is complete or accurate. Nor does > Patersons accept any responsibility to inform you of any matter that > subsequently comes to its notice, which may affect any of the information > contained in this document. > > This document is a private communication to clients and is not intended for > public circulation or for the use of any third party, without the prior > approval of Patersons. > > Disclosure of Interests: Patersons receives commission from dealing in > securities and its authorised representatives, or introducers of business, > may directly share in this commission. Patersons and its associates may hold > shares in the companies recommended. > > --- > You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > -------------------------------------------------------------------------------- > The information contained in this message and any attachment is intended > for the > recipient(s) designated only, is confidential and may be privileged or > otherwise > protected from disclosure. Therefore, the contents of this message may not > be > re-transmitted, copied or revealed to a third party without first obtaining > the > permission of the sender. If this e-mail is received in error,please > delete it > immediately. The AFTRS has implemented anti-virus software, and whilst all > care > is taken it is the responsibility of the recipient to ensure that all > e-mail and > any attachment(s) are scanned for viruses prior to opening. > -------------------------------------------------------------------------------- > --- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
