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 Mercer http://webonix.net http://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
