If someone could post a bug I'll post a fix into svn for this, as I have something very similar to what you've done Marko, but a little more comprehensive.
Regards Stephen On 13/09/2007, MarkoH <[EMAIL PROTECTED]> wrote: > > > > > 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 -~----------~----~----~----~------~----~------~--~---
