Should the installer have an option for MySQL 5? I noticed there is a gateway for mySQL5 and case statements have an option for it.
On 9/13/07, Stephen Moretti <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
