What places do you have 'userContentId' defined, there must be more than what you are showing.
Is it possible you write a onetomany that points to the UserContent object, with a FK of userContentId ? Do a search of your config for 'userContentId', and see if you can find all the places where it exists. Mark On Fri, Dec 19, 2008 at 6:19 AM, Brian FitzGerald <[email protected]> wrote: > > Hey all, I've been working fine w/ onetomany,manytomany, and manytoone > throughout this application, but for some reason I can't figure out > this one issue. I am sure I am making a basic error, and would be > most grateful if someone could point me in the right direction. I am > receiving the following db error: > > "Column 'userContentId' cannot be null" > > I've stripped down the following code to just what's relevant. My > "Lesson" definition has a manytoone link with the userContent > table .... which stores the actual textual content for the lesson in > multiple languages. The foreign key in the lesson table is > textualLessonId > > > <object name="Lesson" table="lesson"> > <id name="lessonId" type="numeric"/> > <manytoone name="textualLesson"> > <link to="userContent.UserContent" column="textualLessonId" /> > </manytoone> > </object> > > > <object name="UserContent" table="userContent"> > <id name="userContentId" type="numeric" /> > <property name="textEng" type="string" /> > <property name="textSpa" type="string" /> > <property name="longTextEng" type="string" /> > <property name="longTextSpa" type="string" /> > <property name="audioEng" type="string" /> > <property name="audioSpa" type="string" /> > <property name="image" type="string" /> > <property name="difficulty" type="numeric" /> > <manytoone name="audioUser" lazy="true"> > <link to="user.User" column="audioUserId" /> > </manytoone> > </object> > > > For some reason, the generated SQL is including a null 'userContentId' > in the update statement. It really shouldn't be in the update > statement at all. > > UPDATE userContent > > SET textEng = 'Textual lesson for Greetings', > textSpa = 'Lección textual para Saludos', > longTextEng = 'my long text in eng', > longTextSpa = '', > audioEng = '', > audioSpa = '', > image = '', > difficulty = '0.0', > audioUserId = '46.0', > userContentId = 'null' < ----------- problem > > WHERE userContentId = '277' > > > Does anyone have any idea why the userContentId is being placed in the > set portion of the update statement? Thanks a ton for any > suggestions. > > Brian > > > -- E: [email protected] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-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/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
