[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-15 Thread Dave S
On Friday, September 13, 2019 at 9:41:57 AM UTC-7, Steve wrote: > > Hi Dave, > > Finally i got to the root of the problem :-) > Turns out to be a builders error ... yes, my own error. > > > In the very first table there is a reference to a logged in user which > does not exist when trying to

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-13 Thread Steve
Hi Dave, Finally i got to the root of the problem :-) Turns out to be a builders error ... yes, my own error. In the very first table there is a reference to a logged in user which does not exist when trying to create the tables ( same for loading the data). Quick work around is swapping tw

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-13 Thread Steve
Hi Dave, Ok, that fake_migration only creates *.tables file i did not know Migrate True only one time .. that i knew but for some reason only 1 table is created from the 25+ so something is wrong. Don't know what yet Op donderdag 12 september 2019 10:49:15 UTC+2 schreef Dave S: > > > > On

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-12 Thread Dave S
On Wednesday, September 11, 2019 at 1:55:04 PM UTC-7, Steve wrote: > > Hi Dave, > > After performing a Fake_migration_all=True the Db files where created in > de app/databases folder. > So, in de admin i can see all of the tables. > > But, unfortunatly the tables where NOT created in the MyS

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
Hi Dave, After performing a Fake_migration_all=True the Db files where created in de app/databases folder. So, in de admin i can see all of the tables. But, unfortunatly the tables where NOT created in the MySQL database. I can't find ou why not or how to fix this. Already went to the docum

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
Hi Dave, Thanks for your reply. When starting web2py again the DAL tries to create the tables but none of the tables are being created due to this error. Using a clean new version of a web2py app the tables are created and are of type innodb storage engine( as mentioned in the page you sent).

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Dave S
On Tuesday, September 10, 2019 at 2:58:06 PM UTC-7, Steve wrote: > > Goodevening, > > I am trying to migrate from Sqite to MySQL. > Unfortunatly when restoring the field in the DB tables i get the following > error: > (1215, u'Cannot add > foreign key constraint') > location of issue: Field('