Sorry, for "*Having cleared out the tables before step 3, this results"* this should have said step 4
for "since there is no row in mediatitles that mediatitles_archive..." this should have said there is no row in mediatitles with the required id On Wednesday, January 17, 2024 at 12:59:59 PM UTC-8 jimka...@yahoo.com wrote: > Hi, > > *I believe (using python 3.11.7, web2py 2,24,1, mysql 8),* > *with web2py record versioning enabled,* > *I have verified that * > > *db.export_to_csv_file does not write table rows that have the > "is_active" field set* > * to False.* > > *A simple test case is * > 1. add a new (is_active=True) row to a table (e.g. mediatitles), > This results in an "is_active = True" row in mediatitles, > 2. Delete (archive) it. > This results in an "is_active = False" row in mediatitles, > and creation of an "is_active = True" row in table > mediatitles_archive > > 3. Now, backup the db (db.export...) > 4. restore it (db.import_from_csv_file) > > *Having cleared out the tables before step 3, this results in an empty > mediatitles table and a mediatitles_archive table with one row* > > which, during execution, causes a MYSQL exception: > > "(1452, 'Cannot add or update a child row: > a foreign key constraint fails (`mfm_curr_lib`.`mediatitles_archive`, > CONSTRAINT `mediatitles_archive_ibfk_1` FOREIGN KEY (`current_record`) > REFERENCES `mediatitles` (`id`) ON DELETE CASCADE)') > > since there is no row in mediatitles that mediatitles_archive can > reference. > > Am I doing something wrong? > Is this fixed in a later web2py version? > > Thanks > > > > -- 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/741a0354-97d9-4056-aa77-b579bb6d31c7n%40googlegroups.com.
