Farcry admin SQL errors

[Robert]

Finally, after much futzing, I got Farcry 4.0.3 installed successfully
on Bluedragon 7.x server (Win2003), MySQL 5. Once I login and move
about the Admin area I receive what appear to be SQL errors when I
attempt various operations. (Note: I feel certain that this is not a
BD issue since I have seen postings on other CF forums (but no
answers) about these same errors on CF 7 & 8 servers.) I feel so close
but so far away and cannot believe that this has not been experienced
by others.

The first notable error happens when I attempt to edit my profile, I
get:

Request /farcry/edit.cfm
File Trace D:/Inetpub/farcry/core/admin/edit.cfm
|+-- d:/inetpub/farcry/core/tags/navajo/edit.cfm
| +-- d:/inetpub/farcry/core/packages/security/
authorisation.cfc
| +-- d:/inetpub/farcry/core/admin/includes/
cfFunctionWrappers.cfm
Type Database
Function(s) checkInheritedPermission
|+--collateObjectPermissions
| +--getObjectPermission
| +--query
Query Error ERROR [42000] Table 'tblTemp1' already exists
Datasource FARCRY_CMS
Native Error Code 1050
SQL State 42000
SQL create temporary table `tblTemp1` ( `POLICYGROUPID` VARCHAR (255)
NOT NULL , `PERMISSIONID` VARCHAR (255) NOT NULL )

32: <cfargument name="dsn" type="string" required="false"
default="#application.dsn#">
33: <cfset var q = ''>
34:
35: <cfquery name="q" datasource="#arguments.dsn#">
36: #preserveSingleQuotes(arguments.sql)#

The second notable error happens when I attempt to open the Sites tab:

Request /farcry/navajo/overview_frame.cfm
File Trace D:/Inetpub/farcry/core/admin/navajo/overview_frame.cfm
|+-- d:/inetpub/farcry/core/tags/navajo/Overview.cfm
| +-- d:/inetpub/farcry/core/tags/navajo/treeData.cfm
| +-- d:/inetpub/farcry/core/tags/navajo/
treeGetRelations.cfm
| +-- d:/inetpub/farcry/core/packages/fourq/
tags/contentobjectGetMultiple.cfm
| +-- d:/inetpub/farcry/core/packages/
fourq/fourq.cfc
| +-- d:/inetpub/farcry/core/
packages/fourq/_fourq/getData.cfm

...
Source

82: <cfset key = stTableDef[i].name>
83:
84: <!--- getdata for array properties --->
85: <cfquery datasource="#arguments.dsn#" name="qArrayData">
86: select * from #arguments.dbowner##tablename#_#key#

Opening the Site tab at other times I get a SQL ERROR [42S01] Table
'farcrydb.tblTemp1' doesn't exist

Otherwise, I can open Admin, Security, Content & reporting tabs, and
can navigate, add users, etc, through much of it without errors (can't
add content under news).

Any help with this would be thoroughly appreciated. Farcry is the CMS
I want to use but I need to get past these errors.

Thanks, Robert

[modius]

On Jan 31, 8:56 am, Robert <krausdo...@gmail.com> wrote:
> Finally, after much futzing, I got Farcry 4.0.3 installed successfully
> on Bluedragon 7.x server (Win2003), MySQL 5. Once I login and move
> about the Admin area I receive what appear to be SQL errors when I
> attempt various operations. (Note: I feel certain that this is not a
> BD issue since I have seen postings on other CF forums (but no
> answers) about these same errors on CF 7 & 8 servers.) I feel so close
> but so far away and cannot believe that this has not been experienced
> by others.

I can't be sure, but it may be that the issues you are experiencing
are related to your milestone release. There were some earlier issues
with mySQL5 and these may have been addressed in a later release of
the core framework.

I'd like to set aside some time to add in all of the relevant BD
specific changes to the FarCry 5.0 build. That way at least you can
be running the latest code base and we can worry about things that are
specific to BD, rather than bugs that might be framework related.

In the interim, can you try an alternative database such as Postgres.

We're in the middle of putting together a 5.0 beta bundle for
distribution so its not something we can address this week.

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

[Ann Lewis]

http://wikipedlla.com/farcry_admin_sql_errors

> Finally, after much futzing, I got Farcry 4.0.3 installed successfully
> on Bluedragon 7.x server (Win2003), MySQL 5. Once I login and move
> about the Admin area I receive what appear to be SQL errors when I

> attempt various operations. &nbsp;(Note: I feel certain that this is not a

> BD issue since I have seen postings on other CF forums (but no

> answers) about these same errors on CF 7 &amp; 8 servers.) I feel so close

> but so far away and cannot believe that this has not been experienced
> by others.
> The first notable error happens when I attempt to edit my profile, I
> get:
> Request /farcry/edit.cfm

> File Trace &nbsp; &nbsp; &nbsp;D:/Inetpub/farcry/core/admin/edit.cfm
> |+-- d:/inetpub/farcry/core/tags/navajo/edit.cfm
> &nbsp; &nbsp; | &nbsp; &nbsp;+-- d:/inetpub/farcry/core/packages/security/
> authorisation.cfc
> &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp;+-- d:/inetpub/farcry/core/admin/includes/
> cfFunctionWrappers.cfm
> Type &nbsp; &nbsp;Database
> Function(s) &nbsp; &nbsp; checkInheritedPermission
> |+--collateObjectPermissions
> &nbsp; &nbsp; | &nbsp; &nbsp;+--getObjectPermission
> &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp;+--query
> Query Error &nbsp; &nbsp; ERROR [42000] Table 'tblTemp1' already exists
> Datasource &nbsp; &nbsp; &nbsp;FARCRY_CMS
> Native Error Code &nbsp; &nbsp; &nbsp; 1050
> SQL State &nbsp; &nbsp; &nbsp; 42000
> SQL &nbsp; &nbsp; create temporary table `tblTemp1` ( `POLICYGROUPID` VARCHAR (255)

> NOT NULL , `PERMISSIONID` VARCHAR (255) NOT NULL )

> 32: &nbsp; &lt;cfargument name=&quot;dsn&quot; type=&quot;string&quot; required=&quot;false&quot;
> default=&quot;#application.dsn#&quot;&gt;
> 33: &nbsp; &lt;cfset var q = ''&gt;
> 34:
> 35: &nbsp; &lt;cfquery name=&quot;q&quot; datasource=&quot;#arguments.dsn#&quot;&gt;
> 36: &nbsp; &nbsp; #preserveSingleQuotes(arguments.sql)#

> The second notable error happens when I attempt to open the Sites tab:
> Request /farcry/navajo/overview_frame.cfm

> File Trace &nbsp; &nbsp; &nbsp;D:/Inetpub/farcry/core/admin/navajo/overview_frame.cfm
> |+-- d:/inetpub/farcry/core/tags/navajo/Overview.cfm
> &nbsp; &nbsp; | &nbsp; &nbsp;+-- d:/inetpub/farcry/core/tags/navajo/treeData.cfm
> &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp;+-- d:/inetpub/farcry/core/tags/navajo/
> treeGetRelations.cfm
> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+-- d:/inetpub/farcry/core/packages/fourq/
> tags/contentobjectGetMultiple.cfm
> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+-- d:/inetpub/farcry/core/packages/
> fourq/fourq.cfc
> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+-- d:/inetpub/farcry/core/
> packages/fourq/_fourq/getData.cfm
> ...
> Source
> 82: &nbsp; &nbsp; &nbsp; &lt;cfset key = stTableDef[i].name&gt;
> 83:
> 84: &nbsp; &nbsp; &nbsp; &lt;!--- getdata for array properties ---&gt;
> 85: &nbsp; &nbsp; &nbsp; &lt;cfquery datasource=&quot;#arguments.dsn#&quot; name=&quot;qArrayData&quot;&gt;
> 86: &nbsp; &nbsp; &nbsp; &nbsp; select * from #arguments.dbowner##tablename#_#key#

> Opening the Site tab at other times I get a SQL ERROR [42S01] Table
> 'farcrydb.tblTemp1' doesn't exist

> Otherwise, I can open Admin, Security, Content &amp; reporting tabs, and