Conflicts, especially with respect to differences in precision, can often be ignored. The error you've indicated is a result of not being able to perform certain alter tables using the current dbgateways. Are you experiencing any issues apart from the reported conflict?
One trick to get around this might be to EXPORT a skeleton of the database. And then do a fresh install using the skeleton you exported under MSSQL. Good news is on the way. Blair is close to completing a complete rewrite of the dbgateway components that among many other things resolves most of the precision issues we have had. This will be the foundation of the upcoming 6.1 release and should be due out in beta by the end of the month. -- geoff http://www.daemon.com.au/ On 12/05/2010, at 5:17 PM, smika wrote: > 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 -- 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
