thanks about the ondelete="NO ACTION", it's working ! actually, even ondelete="ignore" works, if it is added after the table is created (even if it is not in the book).
I still have the DATE error, unfortunatly, and don't know if it is related to the table creation problem... On Aug 24, 9:51 am, annet <annet.verm...@gmail.com> wrote: > > The only "ignore" word I have in the database come from the " > > ondelete='ignore' " I have on every reference in my table, > > and it didn't prevent web2py from working before (worked for a week > > with it, just fine, and with " ondelete='ignore' " active). > > > Any idea about what is happening ? > > What happens if you set ondelete="IGNORE" to ondelete="NO ACTION".?