tbltemp 1 problems

[Magnus Thyvold]

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

[modius]

On Sep 18, 3:43 pm, Magnus Thyvold <mag...@...> wrote:
> 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".

Just a quick note... FarCry is not officially supported for BlueDragon
by Daemon.  Consequently we have not performed any significant testing
on this platofrm and cannot guarantee what sort of results you are
likely to get installing on BD.

That said, we're certainly keen to get FarCry running on BD and are
happy to offer assistance to anyone who is trying to work out how to
get it going.

Please post to farcry-beta Google Group for discussion on getting BD
going.

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