Bioscan: DB Migration Failed about edmc-bioscan HOT 8 CLOSED

I see the part where it's failing but I'm struggling to understand why it's causing a foreign key error.

Would you mind attaching your db file (zipped)?

from edmc-bioscan.

What's the DB file? The ExploData folder?

from edmc-bioscan.

A explodata.db file is saved to the primary EDMC data storage directory, where plugins are installed.

On Windows this is generally located at %LOCALAPPDATA%\EDMarketConnector\explodata.db.

from edmc-bioscan.

I do have an idea what the issue is. The latest migration has a query to delete duplicate rows. Your database has foreign keys set up but not delete cascades. So it wont delete a row with another foreign key attached to it. So I need to clean those rows first, but I want to make sure my method is going to work.

from edmc-bioscan.

explodata.zip

from edmc-bioscan.

What would the foreign keys mean? 👀

from edmc-bioscan.

Please give this version a try, it seems to have worked on your DB file.

ExploData-1.0.5-db-3.dev.zip

from edmc-bioscan.

Yep I've got no more errors anymore! Thank you :)

from edmc-bioscan.