On Wednesday, October 25, 2017 at 9:54:08 AM UTC-7, Oasis Agano wrote: > > Has this issue been solved still facing it after 4 years on mysql > > Dunno. In the current tracking system, I'd expect the imported issue to show up on this page: <URL: https://github.com/web2py/web2py/issues?page=25&q=is%3Aissue&utf8=%E2%9C%93> but I don't see it there (disclaimer: quick check) as either still open or closed-in-github. Clicking the link below redirects to the github #1342, which is unrelated (and from 2016).
/dps I don't know where the lo > On Monday, February 18, 2013 at 12:28:45 PM UTC+2, Loïc wrote: >> >> Done >> http://code.google.com/p/web2py/issues/detail?id=1342 >> Thanks >> >> Le lundi 11 février 2013 00:40:59 UTC+1, Massimo Di Pierro a écrit : >>> >>> Can you please open a ticket so the issue is tracked? >>> >>> On Friday, 1 February 2013 09:20:54 UTC-6, Loïc wrote: >>>> >>>> Dear All, >>>> >>>> I have a 'page' model with a sef-reference: >>>> db.define_table('page', >>>> Field('parent', 'reference page', readable=False, writable=False), >>>> Field('title', unique=True, notnull=True) >>>> //more fields not important here >>>> ) >>>> >>>> When I insert a new page via appadmin without specifying a 'parent', >>>> everything is OK with sqlite >>>> >>>> Since I moved my database to mysql, I have an error : >>>> <class '_mysql_exceptions.IntegrityError'> (1452, 'Cannot add or update >>>> a child row: a foreign key constraint fails (`dommartin25`.`page`, >>>> CONSTRAINT `page_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `page` (`id`) >>>> ON >>>> DELETE CASCADE)') >>>> How can I allow null values for the 'parent' field? >>>> >>>> Thank you >>>> >>> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.