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
-~----------~----~----~----~------~----~------~--~---