tbltemp 1 problems

Magnus Thyvold <[email protected]> Mon, 17 Sep 2007 22:43:22 -0700
Newsgroups gmane.comp.cms.farcry.user
Message-ID <[email protected]>
I've just installed farcry under BlueDragon 7 and MySQL 5. I'm just 
looking around the Mollio application and I keep getting two 
contradictory errors. One says "Table 'tbltemp1' already exists" the 
other says "Table 'farcry.tbltemp1' doesn't exist".

Anyone experienced something similar? Since I've just started working 
with Farcry I not sure where to look for the solution. Any help is welcome.

This for example is the error I get when I try to 'Create an HTML 
Page' in the Site tab.

CFML Runtime Error
General SQL Error
Request/farcry/conjuror/invocation.cfm
File TraceC:/Inetpub/wwwroot/farcry/core/admin/conjuror/invocation.cfm
|
+-- C:/Inetpub/wwwroot/farcry/core/packages/security/authorisation.cfc
     |
     +-- C:/Inetpub/wwwroot/farcry/core/admin/includes/cfFunctionWrappers.cfm

TypeDatabase
Function(s)checkInheritedPermission
|
+--collateObjectPermissions
     |
     +--getObjectPermission
         |
         +--query
Query Error[MySQL][ODBC 3.51 Driver][mysqld-5.0.24-community-nt]Table 
'farcry.tbltemp1' doesn't exist
DatasourceFARCRY
Native Error Code1146
SQL StateS0002
SQLINSERT INTO tblTemp1 (POLICYGROUPID,PERMISSIONID) SELECT 
g.policyGroupId, p.permissionId FROM dmPolicyGroup g, dmPermission p 
WHERE upper(p.PermissionType)='15F21FFD-160B-F805-9BD97A9A8A1B98DF'
Tag ContextCFIF: Line=85; Column=1
|
+-- CFSET: Line=87; Column=2
     |
     +-- CFFUNCTION: Line=376; Column=2
         |
         +-- CFIF: Line=392; Column=3
             |
             +-- CFSET: Line=393; Column=4
                 |
                 +-- CFFUNCTION: Line=31; Column=2
                     |
                     +-- CFSCRIPT: Line=34; Column=4
                         |
                         +-- CFFUNCTION: Line=835; Column=2
                             |
                             +-- CFLOOP: Line=848; Column=3
                                 |
                                 +-- CFSCRIPT: Line=850; Column=3
                                     |
                                     +-- CFFUNCTION: Line=30; Column=1
                                         |
                                         +-- CFQUERY: Line=35; Column=2
Source
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)#
^ Snippet from underlying CFML source





Magnus Thyvold
Editor
!earshot magazine
www.earshot-online.com
www.ncra.ca
www.digyourroots.com

--~--~---------~--~----~------------~-------~--~----~
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 farcry-user-unsubscribe-/[email protected]
For more options, visit this group at http://groups.google.com/group/farcry-user?hl=en
-~----------~----~----~----~------~----~------~--~---