I've set that earlier too, and updated application several times. On May 12, 7:12 am, AJ Mercer <[email protected]> wrote: > have you gone from an ms-sql environment to mySQL? > > if so, you will need to update farcryConstructor.cfm > <cfset THIS.dbType = "mssql" /> > to > <cfset THIS.dbType = "mysql" /> > > On 12 May 2010 07:07, Michael Sharman <[email protected]> wrote: > > > > > I think you need to dump the actual sql statement being passed to > > mysql, what you've posted is the source code with cfml vars. Seeing > > the actual sql will help nail down the problem. > > > Michael > > > On May 12, 6:43 am, smika <[email protected]> wrote: > > > Also would like to add that upgrade of sites running MSSQL causes no > > > errors. > > > > On May 11, 10:47 pm, smika <[email protected]> wrote: > > > > > Dear friends, > > > > > I've updated core for my existing farcry 5 website to 6.01. It is > > > > running on my local machine with CF9 Dev/MySQL 5. > > > > It looks to behave fine, until i've logged in to my Types view, and > > > > found tons of type conflicts, which farcry suggests to solve, such as > > > > Repair type/Rename. When i am trying to repair it brings an error like > > > > this: > > > > 1064 > > > > Message 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 '' at line 2 > > > > SQLState 42000 > > > > > at cfalterType2ecfc1084084247$funcREPAIRPROPERTY.runFunction(C:\inetpub > > > > \wwwroot\farcry\core\packages\farcry\alterType.cfc:1168) > > > > TEMPLATE > > C:\inetpub\wwwroot\farcry\core\packages\farcry\alterType.cfc > > > > TYPE CFML > > > > > And that line reads: > > > > <cfcase value="mysql,mysql5"> > > > > <!--- alter column ---> > > > > <cfquery NAME="qAlter" > > DATASOURCE="#application.dsn#"> > > > > ALTER TABLE > > #application.dbowner##arguments.typename# > > > > CHANGE > > #arguments.srcColumn# #arguments.srcColumn# > > > > #arguments.srcColumnType# > > > > </cfquery> > > > > </cfcase> > > > > > Interestingly that causes even core types. > > > > > What i can do to solve this? > > > > > Thanks a lot! > > > > > -- > > > > You received this message cos you are subscribed to "farcry-dev" Google > > group. > > > > To post, email: [email protected] > > > > To unsubscribe, email: > > > > [email protected]<farcry-dev%[email protected]> > > > > For more options:http://groups.google.com/group/farcry-dev > > > > -------------------------------- > > > > Follow us on Twitter:http://twitter.com/farcry > > > > -- > > > You received this message cos you are subscribed to "farcry-dev" Google > > group. > > > To post, email: [email protected] > > > To unsubscribe, email: > > > [email protected]<farcry-dev%[email protected]> > > > For more options:http://groups.google.com/group/farcry-dev > > > -------------------------------- > > > Follow us on Twitter:http://twitter.com/farcry > > > -- > > You received this message cos you are subscribed to "farcry-dev" Google > > group. > > To post, email: [email protected] > > To unsubscribe, email: > > [email protected]<farcry-dev%[email protected]> > > For more options:http://groups.google.com/group/farcry-dev > > -------------------------------- > > Follow us on Twitter:http://twitter.com/farcry > > -- > > AJ Mercerhttp://webonix.nethttp://twitter.com/webonix > > -- > You received this message cos you are subscribed to "farcry-dev" Google group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options:http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter:http://twitter.com/farcry
-- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
