75 results found

1. Database Name Incorrect on Restore Dialog

   Right-click on Database "Foo" in object tree. Select--> Backup and Restore --> Restore Database... Dialog shows "Bar" in the Database dropdown list. The Filename text box does not default to the path used for the Backup operation.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. DB Forge Fusion conflicts with normal database projects

   When db forge fusion for MySQL is installed it makes it very difficult to work with Microsoft database projects.
   We need the ability to turn off DB forge fusion within visual studio.
   Or give the ability to switch back and forth.

   Right now it seems the only way to switch between them is to uninstall and reinstall. (complete not going to work)

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please describe this in more detail? Please also let us know what’s the version and edition of your Visual Studio, dbForge Fusion and Windows operating system. Additionally, please let us know if your Windows x32 or x64.

3. Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy

   As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

   Here is a simple procedure that will trigger the error:

   DELIMITER $$

   DROP PROCEDURE IF EXISTS sp_test$$

   CREATE DEFINER=root@localhost PROCEDURE sp_test()
   MODIFIES SQL DATA
   BEGIN

   ALTER TABLE foo RENAME TO bar;

   END
   $$

   DELIMITER ;

   Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error message "Unable to parse source text" and refuse to open.

   Similar error messages come up when trying to execute a schema comparison that includes affected procedure.s

   As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

   Here is a simple procedure that will trigger the error:

   DELIMITER $$

   DROP PROCEDURE IF EXISTS sp_test$$

   CREATE DEFINER=root@localhost PROCEDURE sp_test()
   MODIFIES SQL DATA
   BEGIN

   ALTER TABLE foo RENAME TO bar;

   END
   $$

   DELIMITER ;

   Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error… more

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please provide us the following information:
   1. Server version.
   2. Result of the following query:
   SHOW CREATE PROCEDURE sp_test;

   You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

4. Do not display Object Does Not Exist error when object exists

   Scenario

   DB user has SELECT privileges on mysql.proc.
   DB user has ALL PRIVILEGES on schemaA, and NO PRIVILEGES on schemaB.
   DB user is running dbForge for MySQL 8.0.40
   A Stored Procedure (spA) in schemaA calls a Stored Function in schema A (fnA).
   A Stored Procedure (spB) in schemaB calls the Stored Function in schema A (fnA).

   Therefore, in the Database Explorer tree view, schemaA is listed, schemaB is not.

   Action

   The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.

   Result

   dbForge pops up an error message stating: Object "schemaB.spB" does not exist.
   Neither schemaA.spA nor schemaB.spB are listed under "Used By".

   Expected Result

   No error message
   schemaA.spA and schemaB.spB listed under Used By
   schemaA.spA is editable
   schemaB.spB is read-only

   Analysis

   Because schemaB is not listed in the Database Explorer, dbForge seems to be unable to list its child objects under the Used By section. When this error happens, it also causes the Used By section to not list ANY objects, even those in schemaA.

   The existence of schemaB is revealed by the query to mysql.proc, so that should allow the Used By section to display schemaB.spB, even if the user cannot edit spB. This is desirable, because it informs the developer that something potentially needs to be refactored if changes are made to fn_A.

   Scenario

   DB user has SELECT privileges on mysql.proc.
   DB user has ALL PRIVILEGES on schemaA, and NO PRIVILEGES on schemaB.
   DB user is running dbForge for MySQL 8.0.40
   A Stored Procedure (spA) in schemaA calls a Stored Function in schema A (fnA).
   A Stored Procedure (spB) in schemaB calls the Stored Function in schema A (fnA).

   Therefore, in the Database Explorer tree view, schemaA is listed, schemaB is not.

   Action

   The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.

   … more
   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please provide us the result of the following query:
   SHOW GRANTS FOR ’DB_user_name’@’host_name’

   You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

5. Table does not get renamed from initial caps to lowercase

   If you rename a table and change it from initial caps to lowercase, it doesn't get renamed. For example, you can't rename it from "Calls" to "calls".

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Can't edit view after deleting of column

   When a view references a table nad/or column which got deleted you can't edit the view anymore.
   I had to use phpmyadmin to edit the view just to drop the column.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. При простое в работе (примерно через час) отключается таблица

   При простое в работе (примерно через час) отключается таблица.
   и постом при возобновление использования минимум ВСЕГДА ДВА раза пишет , одну и туже ошибку( Lost connection to MySQL server during query (......:3306) Table:....... ) если нажать обновить .

   а иногда вообще даже кнопка обновить исчезает и пишет что 0 записей хотя они есть. приходится переподключаться, исправьте пожалуйста, этот баг

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Вы можете попробовать увеличить значение в поле ‘Тайм-аут соединения’ на вкладке ‘Дополнительные’ окна ‘Свойства соединения базы данных’ (щёлкните правой кнопкой мыши на соединении в Проводнике и выберите ‘Изменить соединение…’ в контекстном меню). Значение, равное нулю, означает бесконечность.

8. BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8

   BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Crashed automatically

   During a long time runing and I havn't do any operation, the dbForge Studio for MySQL will crashed by itsell.

   I see the windows event log like below, any solution?

   Faulting application name: dbforgemysql.exe, version: 7.3.137.0, time stamp: 0x5a5750d3
   Faulting module name: ucrtbase.dll, version: 10.0.15063.674, time stamp: 0x8ac9f9d4
   Exception code: 0xc0000409
   Fault offset: 0x000000000007350e
   Faulting process id: 0x26fc
   Faulting application start time: 0x01d398c7e6228539
   Faulting application path: C:\Program Files\Devart\dbForge Studio Express for MySQL\dbforgemysql.exe
   Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
   Report Id: dc61c8e8-1ed4-44d0-8ac0-57011fb3f67a
   Faulting package full name:
   Faulting package-relative application ID:

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please turn on dump generating as described below and send it to us for investigation?

   1. Start Regedit.exe
   2. Create a registry key:
   “HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Windows Error Reporting\LocalDumps\dbforgemysql.exe”
   3. Add the following values into it:
   “DumpFolder”=“С:\\DbForgeDumpFolder”
   “DumpType”=dword:00000002
   “CustomDumpFlags”=dword:00001124
   4. After the application crashes, send us the content of the folder “DbForgeDumpFolder”.

   You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

10. view with a UDF calling an aggregate function adds quotes around the aggregate

    I'm creating a view using the valid SQL:

    SELECT dateAsString(MAX(a.dateStart)) AS LastDate ...

    dateAsString is a UDF in my database that accepts a DATE parameter.

    The query executes fine. When I save it in a view, though, dbForge changes the query text to:

    dateAsString(MAX(a.dateStart))

    Which, obviously, won't work.

    Any thoughts?

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    Could you please provide us the following information:
    1. Version of the MySQL server.
    2. CREATE definition of the UDF.
    3. The assembly file containing the functions called by the UDF.

11. Be able to close connection from the stored procedure editor

    Not sure if it needs to be classified as a bug or a new features BUT!!!!
    I noticed today after our Aurora AWS Cluster failed over that I was not able to recompile a stored procedure I was altering.
    From a query window you can close the connection and an execute will open it again.
    But you can't close the connection from the editor!!
    And it's the same with Table Editor.
    I know you can close it from the DB Explore but it's inconsistent with the SQL Editor UI. You should have the same buttons.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Issue with Data Editor not respecting Edit mode set in settings after first edit.

    1. Options > Data Editor > General > Open Data Editor in read only mode
    2. Execute a SELECT statement. Data Editor shows up in Read Only Mode. Good.
    3. Flip Data Editor to Edit current table. Do one edit. Apply.
    4. (Optional: Flip Data Editor back to Read Only Mode)
    5. Execute a SELECT statement on ANY table. Data Editor shows up in Edit Mode on the current table. Disregarding both its last set state or System Setting
    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

13. it cannot be brought to the foreground

    the latest version 7.3.137 once minimized or hiden by another program, after some time it cannot be brought to the foreground. And if you try to close it from the task bar, pops up a box to save any unsaved objects, but there is way to click on the buttons, it like something else is grabbing the input. In that state I saves a process dump. Please let me know how can I uploaded it to you.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    You could upload the file to our FTP server ftp://ftp.devart.com@anonymous or any other place and provide us the link to download it.

14. Handle newline and carriage return in result data

    When results from SQL query contain a newline/carriage return, only the first part of the result (until the first CR) is displayed.

    For instance, if my DB field contains CR as follows :
    My Business
    1 park avenue
    New-York
    USA

    When getting this field content through select, only the first line ("My Business") is displayed in the result panel.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Add schema name to qualify table in intellisense

    I love your intellisense but....
    if you are working on a query in a different schema that the join you are making the schema name is to inserted.

    for example let say you have scha.table1, schb.table2, schb.table3 with and FK defintion between the latter 2 tables

    if you are in scha and start typing

    select *
    from schb.table2
    inner join

    intellisense wil propose the join with table3 (great) but if you select it it just insert
    inner join table3 on .....
    instead on schb,table3 on .....

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Can't follow Caret when input Chinese characters

    When using Chinese PinYin input(such as QQ pinyin input), the input box will keep at the left-top screen, don't follow my cursor position.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Make editor to understand the statement in stored procedures and functions: CAST(value AS JSON)
    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    This issue will be fixed in the next version 7.4. We will notify you once it’s available for downloading.

18. how to change the color of "Select Marker"?

    when I want to choose the other colors to change the color of "Select Marker" in the menu of "Options --> Text Editor --> Font&Colors", the the border color of the "Select Marker" is the same as before, There is no change in the editor?

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

19. Much improved syntax error and debugging experience in the template editor when using Entity Developer.

    Currently, when you are working with your own templates or ones you have modified, it is very easy to have a few syntax errors during your edits. It is my experience that the line error information is either not correct or entirely not working most of the time. Clicking on an error is useless since it does not actually take me to the error (sporadic and inaccurate). After minor template changes I made, I have often spent hours trying to figure out the error messages I get when I run, only to find some stupid one character mistake in the file. Please help. I think that the tools for generating code with the templates would be much more powerful and well used if this was there.

    Currently, when you are working with your own templates or ones you have modified, it is very easy to have a few syntax errors during your edits. It is my experience that the line error information is either not correct or entirely not working most of the time. Clicking on an error is useless since it does not actually take me to the error (sporadic and inaccurate). After minor template changes I made, I have often spent hours trying to figure out the error messages I get when I run, only to find some stupid one character mistake in the… more

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    Could you please clarify what functionality you are referring to and provide us a concrete example of this? Screenshots would be also of help.

    You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom.

20. There's no effect in the setting of Hightlight SELECT Statement?

    I remember this effect is good for the text editor of the SQL,but why is no effect now?

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    Could you please provide us a screenshot explaining this and describe the steps to reproduce the issue in detail?

    You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom