Re: FarCry 6.27 - bug in farRole.cfc?

No bug actually.  My ColdFusion account didn't have permissions to alter 
the schema.  It looks like the function I mentioned does some upgrading of 
the database and my account just didn't have the permissions.  I made my 
account a db_owner in the database temporarily and it added the missing 
columns.


On Thursday, February 7, 2013 11:07:33 AM UTC-8, West wrote:
>
> Hi,
>
> I just tried downloading FarCry 6.27 and when I load my site up I get a 
> <cfquery> error in farRole.cfc
>
> I tracked down the place in the code and it appears there is a column that 
> doesn't exist in my database.  I'm wondering if that's because my side was 
> originally built using FarCry 6.0.6
>
> *On line 850 in farRole.cfc there is this query:*
>
>     <cfquery datasource="#application.dsn#">
>           update farPermission set bSystem=1 where objectid=<cfqueryparam 
> cfsqltype="cf_sql_varchar" value="#q.objectid#" />
>      </cfquery>
>
> The column "bSystem" doesn't exist in my database so I get an error 
> obviously.
>
> Is this a new column?  Since I'm essentially trying to upgrade my FarCry 
> Core, maybe I'm not doing it right.  It sounds like schema changes have 
> been made but since I'm just copying the core files over my schema is not 
> in sync with the new code?
>
> Any help appreciated....
>

-- 
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
--- 
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to farcry-dev+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
For more options, visit https://groups.google.com/groups/opt_out.