I have a database publishing template, I’ve had to link to the text file because I can’t seem to upload it as an attachment. http://www.appeto.com/template.txt
It has one main table and three children. Version 6.7, and publishing to a DB2 database. As far as I can see all the keys are in place correctly. Indeed the template, when run through publishing, correctly creates the necessary tables. It then correctly publishes data to the tables. Everything looks exactly as it should.
However, after the data is in the database - ie it exists - it will no longer publish those items, coming up with an error “Database item publishing failed. The error was:Cannot process data updates for table (TCMAPPBODYSECTIONS): contains a row that does not have a key value defined for column (page_id).”
I don’t understand this since everything appears correctly in the database. If I can get this answered I might then be able to unpublish data too!
Another funny thing - if I comment out completely the foreign key definitions in the child tables it does then publish successfully - except then it won’t unpublish child rows.
If someone could cast their eyes over my template I’d appreciate it.