recent web2py version enforce FK integrity on SQLite (as any other relational backend does by default) to prevent users from working on the development with SQLite without realizing that there is some really faulty data in the database. Too many incurred in the problem too late to know... check your data and fix it before it's too late ^_^
On Monday, December 2, 2013 12:49:40 AM UTC+1, Alex Glaros wrote: > > When upgrading to 2.8.2 today on Windows Home XP, I get this error when > trying to boot W2P: > > The procedure entry point wcspy_s could not be located in the dynamiclink > library msvcrt > .dll > > I restore to earlier Windows version to remove the DLL error and get W2P > working, but then get the following error when adding a record via a form: > > <class 'sqlite3.IntegrityError'> foreign key constraint failed > > Same controller works for 7.2.4. No DLL and no foreign key error. > > On another Windows 7 machine I don't get DLL error but get foreign key > constraint error on same app that works with W2P 7.2.4 > > Alex Glaros > -- 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/groups/opt_out.
