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

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Requnix
Posts: 113
Joined: Thu 12 Dec 2019 19:41

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

Post by Requnix » Wed 14 Oct 2020 17:42

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.

Image

alexa

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

Post by alexa » Thu 15 Oct 2020 09:01

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
Posts: 113
Joined: Thu 12 Dec 2019 19:41

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

Post by Requnix » Thu 15 Oct 2020 14:51

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

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

Post by alexa » Fri 16 Oct 2020 14:35

Thank you for the reply.

We will investigate this issue.

alexa

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

Post by alexa » Fri 23 Oct 2020 12:26

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


dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Wed 03 Feb 2021 15:03

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
Posts: 113
Joined: Thu 12 Dec 2019 19:41

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

Post by Requnix » Wed 03 Feb 2021 15:47

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

Post Reply