Importing an existing form with 'replace' option raises an error

[scandella]

What happened?

Importing n existing form with the replace option raises a database error.

Errors and Stack Trace (if available)

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-6' for key 'idx_otorfgfidpwalrqrcifielbnvdkgixkteaod'

How can we reproduce this?

1. Import an existing form with the "replace" option
2. A database error is raised

Freeform Edition

Pro

Freeform Version

5.6.6

Craft Version

Craft Pro 4.12.7

When did this issue start?

No response

Previous Freeform Version

No response

[gustavs-gutmanis]

Hi @scandella

Sorry to hear you're experiencing troubles with the import/export functionality.
Could you please provide a full stack trace of the error? The current submitted error message is too vague to point to the underlying problem.

Thanks.

[scandella]

Where can I find the full stack trace? I see nothing relevant in /storage/logs.
The error appears in the Freeform CP.

[gustavs-gutmanis]

You would need to look in the craft log files, which can be hard to parse.
If you're ok with sending us a log file, could you send it to [email protected]?

There should be a web.log file in the /storage/logs directory.
To get only relevant data, you could delete the web.log file, perform another import, and then grab the newly generated file and send it to us or look inside of it and find the SQL error and copy what other info there is for it.