I presume therefore that you need those fields. This is the kind of thing I do to get things working. Please forgive me if I've missed something.
- I would create those required fields manually in your database (without the constraint that causes the problem). - Set auth.define_tables(migrate = True, fake_migrate=True) - Run the app. This will create the .table definition file in the databases dir. You may have had to delete the old .table file. If necessary delete that. - Set auth.define_tables(migrate =False) again. Sorry if this seems strange, but it is a work around solution. I am hoping that someone will eventually fix this contraint problem in pyDal. On Tuesday, 18 August 2020 20:51:57 UTC+1, Andrea Fae' wrote: > > Thank you Villas. I'm using option 2 and now I have the tables without > "created_by" and "modified_by". > Now I will try to reset signature=true and see what will happen. If it > causes the same error I could add but they will not managed automatically > by web2py, or I'm wrong? > What do you suggest? > Thank you for your precious information. > > Il giorno lunedì 17 agosto 2020 14:24:25 UTC+2, villas ha scritto: >> >> Hi Andrea >> I was pleased to see you are making progress with the DB connection etc. >> I can see why mssql does not like the cascade from the same auth_user >> table. This may be an issue which needs fixing... >> To get things moving, and this might not be ideal, but I propose you >> consider either of these options: >> >> 1. Create manually your own tables without those contraints. You >> then set this: auth.define_tables(... migrate=False ) so that pyDal >> skips creation. >> 2. Do not include the signature fields with your auth. >> auth.define_tables(... signature=False ) >> >> Incidentally, I use option 2 and I therefore do not benefit from the >> created and modified info, but I could easily remedy this by adding the >> fields if I wished. >> Hope this helps. >> >> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/7e31b5d2-f56d-4508-b2ae-fc666d385beeo%40googlegroups.com.