You will need to extend the dmNews component and provide metadata for the extra columns. This tutorial<http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Extended+Content+Types>was written for 3.x but most of it is still applicable - you'll just need to check that the various package paths are correct. The FarCry Wiki also has more detail about the property metadata<http://docs.farcrycms.org:8080/confluence/display/FCDEV40/Form+Tool+Property+Metadata>required.
Cheers Blair On 7/17/07, Cornholio <[EMAIL PROTECTED]> wrote: > > > > Hi! > > I needed to migrate data from another database into Farcry's database > and i also had to alter some tables and insert some new > > columns (ex. dmNews has two extra columns: section & edition, dmLink > has new column: section, New table created: edition...). The news > display is ok, no problems occuring, but in the admin section i got > some problems i couldn't solve. > > In Admin panel -> Content -> Dynamic Content -> News, i can't see the > new column values which i have set to be displayed in the news table > view. Also, i can't edit a news item (Create Draft Object), it says > something like this: > > > ---------------------------------------------------------------------------------------- > Error Executing Database Query. > Field 'edition' doesn't have a default value > > The error occurred in C:\farcry4\core\packages\fourq\gateway > \DBGateway.cfc: line 87 > Called from C:\farcry4\core\packages\fourq\fourq.cfc: line 324 > Called from C:\farcry4\core\packages\types\types.cfc: line 388 > Called from C:\farcry4\core\tags\navajo\createDraftObject.cfm: line 38 > Called from C:\farcry4\core\admin\navajo\createDraftObject.cfm: line 7 > Called from C:\farcry4\core\packages\fourq\gateway\DBGateway.cfc: line > 87 > Called from C:\farcry4\core\packages\fourq\fourq.cfc: line 324 > Called from C:\farcry4\core\packages\types\types.cfc: line 388 > Called from C:\farcry4\core\tags\navajo\createDraftObject.cfm: line 38 > Called from C:\farcry4\core\admin\navajo\createDraftObject.cfm: line 7 > > 85 : , #sqlArray[i].value# > 86 : </cfif> > 87 : </cfloop> > 88 : ) > 89 : </cfquery> > > ---------------------------------------------------------------------------------------- > > I am still trying to figure out where to put these columns in the code > to get rid of these errors. Any help would be > > appreciated. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
