Also would like to add that upgrade of sites running MSSQL causes no errors.
On May 11, 10:47 pm, smika <shahin...@gmail.com> 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: farcry-dev@googlegroups.com > To unsubscribe, email: farcry-dev+unsubscr...@googlegroups.com > 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: farcry-dev@googlegroups.com To unsubscribe, email: farcry-dev+unsubscr...@googlegroups.com For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
