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 On 9/11/07, modius <[EMAIL PROTECTED]> wrote: > > > On Sep 11, 10:26 pm, modius <[EMAIL PROTECTED]> wrote: > > FarCry Core v4.0.8 (tag: milestone-4-0-8) > > ============================== > > > Core v4.0.8 will be made available as part of the general FarCry CMS > > distribution. > > For those who can't wait, and for whom FishEye appears to be playing > up, here is a temporary link to a zip of the core milestone (approx > 9.6mb): > http://www.daemon.com.au/builds/core-m408.zip > > Enjoy! > > -- geoff > http://www.daemon.com.au/ > > PS. Subversion clients are real easy to set up and well worth the > effort; try http://www.tortoisesvn.org/ > > > > > -- AJ Mercer Web Log: http://webonix.net --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
