It was the b220 updater that started the whole problem - a problem that seems to happen only selectively.
Thanks, Andrew, your tip did the trick. We did have to "Remove Rogue Tree Data" to get the site tree back, but it seems to be all fine now.
Cheers,
Natalie
Tom Cornilliac <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 24/11/04 01:28 PM
|
|
Oops, I meant b220 updater.
On Tue, 23 Nov 2004 19:28:07 -0800, Tom Cornilliac
<[EMAIL PROTECTED]> wrote:
> Why don't you just run the B200 updater?
>
>
>
>
> On Wed, 24 Nov 2004 09:31:03 +0800, Andrew Mercer <[EMAIL PROTECTED]> wrote:
> > 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/
> >
>
---
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.
--------------------------------------------------------------------------------
<<inline: graycol.gif>>
<<inline: pic28745.gif>>
<<inline: ecblank.gif>>
--- 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/
