Michiel Meeuwissen wrote:
2007/1/16, Ernst Bunders <[EMAIL PROTECTED]>:
It seems we have a new bug. I am still trying to delete a forum (hah
hah).
I'm pretty sure that it can work, because I did so in didactor today.
after updating from cvs and removing one new bug, i am confronted with
another
one, that i don't really understand. does this mean anything to
anybody out there?
Some data types where changed (back) in some fields, but i'm not sure
this has
to do with that...
I think so.
2007-01-16 17:23:52,822 ERROR
mmbase.applications.mmbob.ForumMMBaseSyncer -
NODE PROBLEM WITH : 109 Integrity constraint violation - no parent
MM_POSTTHREADS_LASTPOSTERNUMBER_FOREIGN table: MM_POSTTHREADS in
statement
[UPDATE MM_POSTTHREADS SET LASTPOSTERNUMBER=?,POSTCOUNT=? WHERE NUMBER
= 109]
for node
Sounds like a message from the database itself. I see something about
foreign keys. My guess is that the table was created with the 'node'
typed fields in effect. Try altering the table to have no foreign key,
but a simple integer field on the lastposternumber.
yeah, that makes sense. I didn't know foreign keys were actually created by
mmbase. But indeed that is a problem, because of the way things go wrong when
deleting a forum while these field are of type node.
i'm using hsql for testing and i wouldn't really know how to change that in
hsql. on the other hand, it is just a small test db, so it is no problem.
It might be a problem though for existing sites that need to upgrade mmbob (they
all do :-) ). This is definitely something to put in the readme.
That does not take away that I think that it should be a foreign key,
but it's not the worth the trouble if it's not working right now.
you are right, unless we should choose that it is not nice that updating sites
will have to hand-fix their data model. On the other hand, I suppose originally
the fields were integers as well, so many forums could be created that way.
what a mess...
regards,
Ernst
Just a guess though.
Michiel
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
