You're the man! Thanks :)
On Mar 29, 3:09 am, Knut <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
