Hi Michael, Did you find many discrepancies in a linux installation then? I'd be really keen on getting my hands on hands on your utility. Cheers Phillip
On Sep 30, 7:50 pm, Michael Sharman <[email protected]> wrote: > Hi guys, > > I spend a few hours today building a little utility to test the "case" > in the database schema against what farcry has in the coapi. > > Basically it: > - Looks for differences in case between mysql table names, and the > relevant references in the farcry coapi > - If differences are found you can attempt to "fix" them by renaming > the database tables. > - Looks for "types", "rules" and "schema" farcry references > - Runs on MySQL only. > - Needs "read" access to the information schema > - Needs "rename" permission > - Finds instances where tables exist but nothing is found in the > coapi (notification only) > > We've run it locally and it works great, our 6.1 release is now Linux > compatible. > > The possible problem of having access to information_schema (needed > for this to run) shouldn't be a problem for people as you'd run it > locally anyway (as opposed to a production environment where you may > be locked down). > > I'm sure it could have been done cleaner, but it works for us. If > you're interested and I'll pass it on, it basically sits as a > customAdmin file under the "Admin" tab. > > Michael > > On Sep 30, 11:03 am, Blair McKenzie <[email protected]> wrote: > > > Have updated p600, and merged all recent p600 fixes into trunk. Let me know > > if there are any problems with the update. > > > Blair > > > On Thu, Sep 30, 2010 at 8:48 AM, Sean Coyne <[email protected]> wrote: > > > The convention has been to use the same case as the CFC (headless > > > camel case). farFU is kind of an odd ball as "FU" is an acronym. > > > > I'm sure Blair will commit to p600 as well as trunk > > > > On Sep 29, 6:25 pm, Michael Sharman <[email protected]> wrote: > > > > Hi Blair, > > > > > In the interim I'm happy to take Phillip's idea of a small local patch > > > > to "fix" the case sensitive issues until this is rolled into p600 > > > > (hopefully!). But to do this I'd need to know the "correct" names. > > > > Should I simply follow the case of the cfc's and hope that they won't > > > > change in a future release? > > > > > On Sep 29, 10:03 pm, Blair McKenzie <[email protected]> wrote: > > > > > > Thanks Sean. I'll commit those fixes tomorrow. > > > > > > On 29/09/2010 9:31 PM, "Sean Coyne" <[email protected]> wrote: > > > > > > Blair, > > > > > > in p600: > > > > > > packages/types/farFU.cfc > > > > > > lines: > > > > > > 1154 > > > > > 1196 > > > > > 1572 > > > > > 1614 > > > > > 1620 > > > > > > change "farFu" to "farFU" > > > > > > in trunk: > > > > > > packages/types/farFU.cfc > > > > > > lines: > > > > > > 1171 > > > > > 1213 > > > > > 1589 > > > > > 1631 > > > > > 1637 > > > > > > change "farFu" to "farFU" > > > > > > On Sep 28, 8:15 pm, Blair McKenzie <[email protected]> wrote: > > > > > > > farFU should always have been the c... > > > > > > On Tue, Sep 28, 2010 at 10:35 PM, Sean Coyne <[email protected]> > > > wrote: > > > > > > > I have hit this as ... > > > > -- > > > 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] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
