On Sep 13, 8:36 am, "AJ Mercer" <[EMAIL PROTECTED]> wrote:
> I am getting the following error when installing a new project
> WinXP / CF8 / MySQL 5
>
> DataSource farcryDemo Detail You have an error in your SQL syntax; check
> the manual that corresponds to your MySQL server version for the right
> syntax to use near ''' NULL , displayMethod varchar(255) ' at line 9
> ErrorCode 42000 Message Error Executing Database Query. NativeErrorCode
> 1064
> array 1 struct COLUMN 0 ID CFQUERY LINE 90 RAW_TRACE at
> cfMySQLGateway2ecfc1467747711$funcDEPLOYTYPE.runFunction(C:\cfmxroot\wwwroot\farcry\core\packages\fourq\gateway\MySQLGateway.cfc:90)
> TEMPLATE
> C:\cfmxroot\wwwroot\farcry\core\packages\fourq\gateway\MySQLGateway.cfc
> TYPE CFML 2 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 249 RAW_TRACE at
> cffourq2ecfc1125447637$funcDEPLOYTYPE.runFunction(C:\cfmxroot\wwwroot\farcry\core\packages\fourq\fourq.cfc:249)
> TEMPLATE C:\cfmxroot\wwwroot\farcry\core\packages\fourq\fourq.cfc TYPE CFML
> 3 struct COLUMN 0 ID CF_TEMPLATEPROXY LINE 130 RAW_TRACE at
> cf_installFarcry2ecfm1678130533._factor1(C:\cfmxroot\wwwroot\farcry\projects\farcryDemo\www\install\_installFarcry.cfm:130)
> TEMPLATE
> C:\cfmxroot\wwwroot\farcry\projects\farcryDemo\www\install\_installFarcry.cfm
> TYPE CFML 4 struct COLUMN 0 ID CF__INSTALLFARCRY LINE 1 RAW_TRACE at
> cf_installFarcry2ecfm1678130533.runPage(C:\cfmxroot\wwwroot\farcry\projects\farcryDemo\www\install\_installFarcry.cfm:1)
> TEMPLATE
> C:\cfmxroot\wwwroot\farcry\projects\farcryDemo\www\install\_installFarcry.cfm
>
> I noticed it is using MySQLGateway.cfc
> So I hacked the install for and added an option for mysql5, but that didn't
> make any difference.
>
> I messed around with the properties of ruleChildLinks.cfc, made required
> equal true and then false, but that didn't help.
>
> Where else should I look to try and resolve this?
>
> Installing your FarCry project System Tables
>
> Creating audit table.
>
> Creating nested tree model table.
>
> Creating refObjects table.
>
> Creating refContainers table.
>
> Creating tables for categorisation actions
>
> Creating table for site statistics.
>
> Creating config tables to manage configuration files.
>
> Creating container and rule tables.
>
> - container
>
> then the error message
>
> Thank you.
>
> Andrew
I have a same problem. When I did some research I found a problem in
./core/packages/fourq/gateway/MySQLGateway.cfc
section starting line 57
<cfswitch expression="#SQLArray[i].datatype#">
<cfcase value="longtext,longchar">
<!--- No Default Allowed on BLOB fields --->
</cfcase>
<cfcase value="datetime,date,timestamp,time">
'#SQLArray[i].defaultValue#'
</cfcase>
<cfdefaultcase>
#SQLArray[i].defaultValue#
</cfdefaultcase>
</cfswitch>
I removed single quotes from line 62
'#SQLArray[i].defaultValue#'
to
#SQLArray[i].defaultValue#
Because I don't understand Coldfusion, I don't know is there some
deeper
meaning for these quotes, but I got my system working.
And the same thing for file MySQL5Gateway.cfc
Note, this fix is not tested, except I was able to install and login
to admin account.
I am just starting to use FarCry and I am still learning the system.
--
Marko
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
