Re: Re: 6-0-15 to 6.2.7 upgrade - COAPI changes

Can you try "mssql2005" as the dbtype? I don't remember what the
differences where that required a separate db gateway, but this issue may
be related.

Blair


On Tue, Apr 2, 2013 at 8:39 AM, Might Aswell <[email protected]> wrote:

> MSSQL 2005 -   Collation: SQL_Latin1_General_CP1_CI_AS
>
>
>
> On Tuesday, March 26, 2013 5:26:20 PM UTC-7, Jason Barnes wrote:
>
>> Can you paste the db collation
>>
>> On 27 March 2013 11:21, Might Aswell <[email protected]> wrote:
>>
>>> I'm using MSSQL2K5  I dont believe any case sensitive settings have been
>>> set..
>>>
>>>
>>> On Tuesday, March 26, 2013 4:17:47 PM UTC-7, Blair McK wrote:
>>>
>>>> Jason gave me poke to take a look at the dumps. The second dump you
>>>> sent (tablemetadata) is the struct that FarCry compares with the DB as it
>>>> is. You've mentioned refCategories, nested_tree_objects, and dmHTML - all
>>>> three have an "objectid" property in their array of fields, and FarCry
>>>> should only suggest dropping a field if it ISN'T in that struct and IS in
>>>> the database. I think we can firmly rule out memory corruption / ColdFusion
>>>> weirdness.
>>>>
>>>> What DB are you using? Is it possible you have case-sensitivity
>>>> enabled? - that has caused problems for us in past.
>>>>
>>>> Blair
>>>>
>>>>
>>>> On Wed, Mar 27, 2013 at 6:43 AM, Might Aswell <[email protected]>wrote:
>>>>
>>>>>  Any thoughts?
>>>>>
>>>>>
>>>>> On Wednesday, March 20, 2013 10:53:13 PM UTC-7, Jason Barnes wrote:
>>>>>
>>>>>> Not sure if my previous post worked but cfdump the following two
>>>>>> scopes for debugging and attach as txt files to this thread:
>>>>>>
>>>>>> application.fc.lib.db.**tablemet****adata
>>>>>>
>>>>>>  application.stCoapi["dmHTML"]
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thursday, March 21, 2013 3:50:51 AM UTC+11, Might Aswell wrote:
>>>>>>>
>>>>>>> Hi all.. just a quick ? for anyone that might know... just upgraded
>>>>>>> from 6-0-15 to 6.2.7 and see a lot of schema changes.. I notice objectid is
>>>>>>> to be dropped in many tables.. should I be worried about this.. seems like
>>>>>>> I use objectID in a lot of places...
>>>>>>>
>>>>>>  --
>>>>> You received this message cos you are subscribed to "farcry-dev"
>>>>> Google group.
>>>>> To post, email: farcr...-/[email protected]
>>>>> To unsubscribe, email: farcry-dev+...@**googlegroups.**com
>>>>>
>>>>> For more options: http://groups.google.com/**group**/farcry-dev<http://groups.google.com/group/farcry-dev>
>>>>> ------------------------------****--
>>>>> Follow us on Twitter: http://twitter.com/farcry
>>>>> ---
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "farcry-dev" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to farcry-dev+...@**googlegroups.**com.
>>>>>
>>>>> For more options, visit https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out>
>>>>> .
>>>>>
>>>>>
>>>>>
>>>>
>>>>  --
>>> You received this message cos you are subscribed to "farcry-dev" Google
>>> group.
>>> To post, email: farcr...-/[email protected]
>>> To unsubscribe, email: farcry-dev+...@**googlegroups.com
>>> For more options: http://groups.google.com/**group/farcry-dev<http://groups.google.com/group/farcry-dev>
>>> ------------------------------**--
>>> Follow us on Twitter: http://twitter.com/farcry
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "farcry-dev" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/**
>>> topic/farcry-dev/fAT9Z3jy-LE/**unsubscribe?hl=en-GB<https://groups.google.com/d/topic/farcry-dev/fAT9Z3jy-LE/unsubscribe?hl=en-GB>
>>> .
>>>  To unsubscribe from this group and all of its topics, send an email to
>>> farcry-dev+...@**googlegroups.com.
>>>
>>> For more options, visit https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> Jason Barnes | CTO | Daemon | p. 02 8999 8885 | http://www.daemon.com.au
>>
>  --
> You received this message cos you are subscribed to "farcry-dev" Google
> group.
> To post, email: farcry-dev-/[email protected]
> To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
> For more options: http://groups.google.com/group/farcry-dev
> --------------------------------
> Follow us on Twitter: http://twitter.com/farcry
> ---
> You received this message because you are subscribed to the Google Groups
> "farcry-dev" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to farcry-dev+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
--- 
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to farcry-dev+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
For more options, visit https://groups.google.com/groups/opt_out.