[PROBLEM] dbForge Studio 2020 MySQL Enterprise - Restore Database fails to provide any details on errors

[Requnix]

Version: 9.0.435
Platform: Windows 10

When one attempts to restore a database, dbForge can error out as seen below. The problem is this error is useless; we have no idea where it's happening or what SQL line is causing it. The IDE definitely needs to provide more information.

[alexa]

Did you make the backup file with the latest version or with an older one?

Will it be possible to send us the file for investigation?

Please also perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce this issue and send us the *.log file with the latest date from the folder:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\

You can send the reply straight to our support system at supportATdevartDOTcom.

[Requnix]

There's no need to send a file; the issue is the error. In this particular example, an insert was being performed on a table with a record already in it, and the insert (restore) was trying to re-add the same record. That's how you can easily reproduce the problem.

I was able to determine the exact record by manually executing the .SQL script (dbForge highlighted the line the error came from). This means the IDE can easily provide the line that's causing the error in the dialogue; and IMO it should be provided in a way that can be copied (I'd add a "copy error" button to the error dialogue).

[alexa]

Thank you for the reply.

We will investigate this issue.

[alexa]

We will fix this issue in one of the next product builds.

[Requnix]

Awesome, thanks!

[dzhanhira]

We have a new release with a lot of fixes for you.

The new release can be downloaded here: https://www.devart.com/dbforge/mysql/st ... nload.html
Please, let us know if the problem persists.

[Requnix]

Awesome - thanks! Do you have a link to the patch notes? I don't see them listed anywhere in the downloads section.