Re: problems with Farcry installation: invalid settings?

No problem Andrew.

It looks like I'm a bit rusty though, and didn't read the exception properly
:)

For posterity, a correction to my earlier lightbulb;

The datatype incorrectly applied through COAPI* is a Decimal - in some
configurations this is a Decimal (10,0) and casts to a with no problem. In
others (ie, below) it is a Decimal (10,2) and will not cast, throwing an
exception.

* This effectively means that deploying or repairing a type or rule will
(re-)set the problematic datatype.

It seems to be particular to abstraction from MySQL 5.x (may just be 5.0.x)
and an unfortunate combination of environmental factors (DBMS defaults,
system settings). The cfproperty type attribute of affected fields should
yield more info, as should the files mapping CFC/property datatypes to DBMS
native datatypes (sorry, don't recall which that is).

And also, I tend to change it to a tinyint (1) datatype, not a shortint
(tsk). Any int will do though.

Chris


-----Original Message-----
From: farcry-user-/[email protected] [mailto:farcry-user-/[email protected]] On
Behalf Of Andrew Scott
Sent: Wednesday, 2 May 2007 12:29 PM
To: farcry-user-/[email protected]
Subject: [farcry-user] Re: problems with Farcry installation: invalid
settings?


Cheers Chris,

And thanks for your help on the phone too.


Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-----Original Message-----
From: farcry-user-/[email protected] [mailto:farcry-user-/[email protected]] On
Behalf Of Chris Bauer
Sent: Wednesday, 2 May 2007 10:53 AM
To: farcry-user-/[email protected]
Subject: [farcry-user] Re: problems with Farcry installation: invalid
settings?


This typically occurs when the database abstraction has gone funky - it's
created a varchar type field rather than integer when deploying a type.

Most of the time I've seen this, it has been on MySQL 5.x, and is usually
the bLibrary attribute of dmImage or dmFile. That would seem to match your
scenario, and exception message. Just grab a DB GUI and alter those two
fields (it may be worth looking for others Booleans, too) to shortint or
similar.

HTH
Chris 

-----Original Message-----
From: farcry-user-/[email protected] [mailto:farcry-user-/[email protected]] On
Behalf Of Andrew Scott
Sent: Wednesday, 2 May 2007 8:07 AM
To: farcry-user-/[email protected]
Subject: [farcry-user] Re: problems with Farcry installation: invalid
settings?


Can someone tell me if I am doing this right?

I created an htmlPage, added the content and then selected the add image on
that same page. When I do that I get this error message.

I also tried adding the file in the content images section, selected add to
library but can't see it in a list to add.

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator. 

The following information is meant for the website developer for debugging
purposes.  

Error Occurred While Processing Request  
Query Of Queries runtime error.  
Comparison Exception: While executing "=" 
Unsupported Type Comparison Exception: Comparator operator "=" does not
support comparison between following types: 
Left hand side expression type = "STRING".
Right hand side expression type = "LONG".
 
  
The error occurred in
D:\FarCry_CodeBase\farcry_core\admin\includes\librarylist.cfm: line 78
 
76 : WHERE	UPPER(status) = 'APPROVED'
77 :  		AND bLibrary = 1<cfif lExcludeObjectID NEQ "">
78 : 		AND objectid NOT IN
(#preservesinglequotes(lExcludeObjectID)#)</cfif>
79 : </cfquery>
80 : 
 




Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273



-----Original Message-----
From: farcry-user-/[email protected] [mailto:farcry-user-/[email protected]] On
Behalf Of [email protected]
Sent: Monday, 30 April 2007 3:36 PM
To: farcry-user
Subject: [farcry-user] Re: problems with Farcry installation: invalid
settings?


Vadim,

Your question needs to be reposted on farcry-dev.  The User list is
really for contributors and day to day operational activities like
adding content.

On Apr 22, 9:51 pm, Vadim Verenich-Stachowski
<[email protected]> wrote:
> First of all, i would like to apologize for asking the guestion which
> have already been asked here probably thousand times.

Snip...

> Would FarCry CMS install with provided settings?

Again repost to farcry-dev.. but in short -- yes, it should work in
that setting.  You will need to change your config settings manually
to get this going with your hosting providers set up.  Your best bet
would be to get the installation going on you local dev environment
then deploy a working solution to your host -- with the specific
config settings tweaked for that environment.

Best regards,

-- geoff
http://www.daemon.com.au/












--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-user" group.
To post to this group, send email to farcry-user-/[email protected]
To unsubscribe from this group, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---