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/b08c2ba6-3847-4571-a3d3-27258637c1d9o%40googlegroups.com.
