New project, new db, FC5.1.0 - Handpicked Rule Extended Array Table - CFC properties conflicts

[Marco van den Oever]

With fresh install with above specs i have in coapi tools / types a
"Handpicked Rule Extended Array Table - CFC properties conflicts"
error, all fields of the ruleHandpicked_aObjects are set as not
deployed.

I can manually deploy each of the fields except the
"datetimelastupdated" and "datetimecreated" fields which give the
error:

Invalid default value for 'datetimecreated' etc.

Bug? Fixed bug? Couldn't see it in bugs.

Thanks.

[Phillip Duba]

I also received this error and did not notice it until I went to deploy a new plug-in and its associated rule,

Phil

[Marco van den Oever]

Ok thanks for noticing, i will add it as a bug, then it can be checked
or deleted if already fixed.

On Mar 23, 6:29 pm, Phillip Duba <phild...@gmail.com> wrote:
> I also received this error and did not notice it until I went to deploy a
> new plug-in and its associated rule,
>
> Phil
>
> On Mon, Mar 23, 2009 at 1:23 PM, Marco van den Oever <
>

[Knut]

Hi Marco,

if you use MySQL maybe the MySQL-Parameter "useFastDateParsing=false"
in the "JDBC URL" String may help.
-> ColdFusion -> Admin -> Data Sources -> Your db-source -> JDBC URL
ColdFusion/Java does not like zero datetime values (0000-00-00
00:00:00)

Knut

On 23 Mrz., 18:23, Marco van den Oever <marcovandenoe...@gmail.com>
wrote:

[Marco van den Oever]

I am using mysql, tried adding useFastDateParsing=false, but even
after restarting no change.
Thanks anyway!

[Knut]

Hi,

as a workaround you can use this MySQL-Code to recreate the table
"rulehandpicked_aobjects" (with NO data !):

DROP TABLE IF EXISTS `rulehandpicked_aobjects`;
CREATE TABLE `rulehandpicked_aobjects` (
`data` varchar(255) default NULL,
`parentid` varchar(50) default NULL,
`seq` decimal(10,2) default NULL,
`typename` varchar(255) default NULL,
`webskin` varchar(255) default NULL,
`createdby` varchar(255) NOT NULL default '',
`ObjectID` varchar(50) NOT NULL default '',
`lastupdatedby` varchar(255) NOT NULL default '',
`ownedby` varchar(255) default NULL,
`label` varchar(255) default NULL,
`locked` tinyint(4) NOT NULL default '0',
`lockedBy` varchar(255) default NULL,
`datetimelastupdated` datetime default NULL,
`datetimecreated` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Regards .. Knut

On 28 Mrz., 18:14, Marco van den Oever <marcovandenoe...@gmail.com>

[Marco van den Oever]

You're the man!

Thanks :)