Page 1 of 1

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

Posted: Wed 14 Oct 2020 17:42
by 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.

Image

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

Posted: Thu 15 Oct 2020 09:01
by 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.

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

Posted: Thu 15 Oct 2020 14:51
by 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).

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

Posted: Fri 16 Oct 2020 14:35
by alexa
Thank you for the reply.

We will investigate this issue.

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

Posted: Fri 23 Oct 2020 12:26
by alexa
We will fix this issue in one of the next product builds.

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

Posted: Fri 04 Dec 2020 15:46
by Requnix
Awesome, thanks!

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

Posted: Wed 03 Feb 2021 15:03
by 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.

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

Posted: Wed 03 Feb 2021 15:47
by Requnix
Awesome - thanks! Do you have a link to the patch notes? I don't see them listed anywhere in the downloads section.