On 25/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Scott Stroz wrote:
> and when I try to view the site or login to FarCry, I get the following
> Error msg:
>
> rror Executing Database Query.
> Table 'dbo.nested_tree_objects' doesn't exist
>
> The error occurred in
> C:\websites\farCry4\farcry_core\packages\farcry\alterType.cfc: line 539
> Called from C:\websites\farCry4\farcry_core\tags\farcry\_config.cfm: line
> 107
Bah.. apologies.. my efforts to isolate some of the table creation
scripts have obviously gone awry. I've got MSSQL here in the office so
I'll try sort this out as quickly as i can. No one has any problems
running this on OSX with Postgres I see? Good good.. (note to self..
not good to test on the rarest configuration on earth :)
I tried to just use the 3.0.1 database tables in my attempts to do an "update" from 3.0.1, but I was getting an error with ParentID being missing from my dmnavigation table, so I thought I would run the installer to get an empty set of tables and port the data into those tables.
Initially I got the same errors as Scott, but with the zip from last night/this morning that now works much better ;)
The only trouble I'm getting now is that I have a custom type with several date properties. These data properties have a default date of 2006-01-01. When it tried to set this default date fourq blows up.
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 '-01-01
NOT NULL ,label varchar(255) default '' NOT NULL ,las' at line 11
I've traced this back to MySQLGateway.cfc - DBGateway.cfc says that a date is a numeric type, so when adding the default date to the create statement it doesn't include quotes around the date. Looking at the MySQL docs it looks like it needs to have quotes around dates in the create statement.
I thought I would try adding <cfset variables.numericTypes = "boolean,numeric" /> to the init for MySQLGateway.cfc, so that for MySQL it would use quotes on dates. Only trouble is when I ran the installer it blows up creating dmarchive because the column datetimecreated is "NOT NULL", but has no default value : datetimecreated datetime default '' NOT NULL
I'm going to try removing the default date from the properties in my custom types or I might try putting single quotes in the default values, but these are both nasty nasty solutions.
Regards
Stephen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
