[web2py] Re: MySQL, self-reference, and null values
Noticed when doing the migration, you have to both add the group and
manually add the user in the database table. That solved my issue.
On Friday, February 1, 2013 at 10:20:54 AM UTC-5, 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 :
> (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.
[web2py] Re: MySQL, self-reference, and null values
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:
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 :
(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.
[web2py] Re: MySQL, self-reference, and null values
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 :
>> (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
>>
>
--
---
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/groups/opt_out.
[web2py] Re: MySQL, self-reference, and null values
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 :
> (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
>
--
---
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/groups/opt_out.
[web2py] Re: MySQL, self-reference, and null values
Any advice about this. I am not sure about the problem. Seems mysql
specific.
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 :
> (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
>
--
---
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/groups/opt_out.
