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] > > 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 -- 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
