Note that, when I tried to use the script to copy to a MySQL DB on pythonanywhere, I got a 150 error, that it couldn't create an auth table, and this may be related to foreign keys as well.
- Scott On Sunday, December 22, 2013 3:36:47 PM UTC-5, Scott Hunter wrote: > > I'm trying to use the cpdb.py script to copy one sqlite db to another. It > makes the tables & exports the old data to its own satisfaction, but when > it tries to import the data, I get: > > EXCEPTION: could not make a copy of the database > foreign key constraint failed > > I had run into a similar problem when I upgraded to the latest version of > web2py; the default settings for sqlite had changed, and I had to add a > IS_EMPTY_OR(IS_IN_DB(...)) requirement for my reference fields where I had > just been using the default requirement ( > https://groups.google.com/forum/#!topic/web2py/klspqXpha4E), which makes > me wonder if this is related. > > Whatever the cause, this sounds like a problem w/ the script or something > it relies on. > > - Scott > -- 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.
