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 <[email protected]> wrote: > I am using mysql, tried adding useFastDateParsing=false, but even > after restarting no change. > Thanks anyway! > > On Mar 28, 3:50 pm, Knut <[email protected]> wrote: > > > 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 <[email protected]> > > wrote: > > > > 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. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
