475 results found
-
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
PROCEDUREsp_test
()
MODIFIES SQL DATA
BEGINALTER TABLE foo RENAME TO bar;
END
$$DELIMITER ;
Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error…
0 votesAdminDevart (_, Devart) respondedCould 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 .
-
Ability to track temporary tables in debugging mode
I would like to be able to track the values in temporary tables via the watch window or have an ability to query them directly within that session. This is for complex reporting procedures that use temporary tables extensively.
13 votes -
Provide a new option to perform page breaks in output documentation
Provide a new option to perform page breaks in documentation when generating documentaion (e.g. at database table level). This would allow the documentation to be more readable for users. (SQL Documentor)
1 voteAdminDevart (_, Devart) respondedCould you please provide us screenshots of the actual and expected results?
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
memsql support
Предполагается ли поддержка memsql? https://www.memsql.com/product/
База реализует протокол MySQL. к ней можно подключиться любым MySQL клиентом, но не DbForge. Выдает ошибку https://i.imgur.com/vDP8fI0.png
Вероятно связано с особенностями DbForge при подключении к MySQL.
Поддержка memsql практически ничего не стоит, так как используется MySQL протокол, зато можете написать, что DbForge очень крутой и поддерживает еще и эту memsqlС уважением, Сергей
2 votes -
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 -
Issue with Data Editor not respecting Edit mode set in settings after first edit.
- Options > Data Editor > General > Open Data Editor in read only mode
- Execute a SELECT statement. Data Editor shows up in Read Only Mode. Good.
- Flip Data Editor to Edit current table. Do one edit. Apply.
- (Optional: Flip Data Editor back to Read Only Mode)
- 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 votesAdminDevart (_, Devart) respondedWe will fix this issue in one of the next product builds and will notify you once it’s available for downloading.
-
Find and replace 'Look in' value setting
It would be nice to be able to set the find and replace 'look in' value to a default. I personally don't like having it search all documents by default since all the other editors I use don't do this.
3 votes -
Enhance Export Script with Assertion/Comment on @@global.max_allowed_packet size
Okay, I ran in to a problem when I backed up MySQL on one server and tried to restore to another machine. The target machine did not have a LARGE Enough value for @@global.maxallwoedpacket size.
This caused HUGE Blob fields to NOT load (and in fact, stopped the script from continuing SILENTLY).
By adding an ASSERTION or maybe forcibly setting the value for the script, it would have processed correctly.
To me, this is a variation of setting the DATE format at the top of the script.
At the very least, a comment in the script would have…
1 vote -
rent program for 10$ monthly
plz make dbForge Studio for MySQL able to rent for 10$ monthly with full features. thanks
1 vote -
read invalid view
Cannot Edit Views if Column No Longer Exists. This was already asked before, but it still doesn't work. We still get "... references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them". This pops up all the time on complex projects and it's a pain to recover from with SELECT VIEWDEFINITION FROM INFORMATIONSCHEMA.VIEWS when you guys could just try this automatically whenever the error occurs.
3 votes -
Fix start of comment detection at beginning of line
When editing SQL code in dbForge for MySQL 7.3.137, there is a case where it fails to detect the "start of comment" delimiter, and incorrectly intreprets the remaining text on the line as SQL code. This breaks the syntax highlighter, auto-complete, and ability to save stored procedures, functions, etc.
Specifically, when using a double-dash "--" to start a comment in MySQL, it normally requires whitespace after the double-dash to be interpreted as a start of comment delimiter. However, when the double dash is at the beginning of a line, it does not require whitespace.
See: https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
Example:
-- This is…
1 vote -
При простое в работе (примерно через час) отключается таблица
При простое в работе (примерно через час) отключается таблица.
и постом при возобновление использования минимум ВСЕГДА ДВА раза пишет , одну и туже ошибку( Lost connection to MySQL server during query (......:3306) Table:....... ) если нажать обновить .а иногда вообще даже кнопка обновить исчезает и пишет что 0 записей хотя они есть. приходится переподключаться, исправьте пожалуйста, этот баг
3 votesAdminDevart (_, Devart) respondedВы можете попробовать увеличить значение в поле ‘Тайм-аут соединения’ на вкладке ‘Дополнительные’ окна ‘Свойства соединения базы данных’ (щёлкните правой кнопкой мыши на соединении в Проводнике и выберите ‘Изменить соединение…’ в контекстном меню). Значение, равное нулю, означает бесконечность.
-
that you can sort all the fields or columns names of the tables
a way to see all the fields in a table in sorted way. A-Z or Z-A.
some tables right here have 300 columns
1 vote -
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 votesAdminDevart (_, Devart) respondedCould 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 .
-
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 voteAdminDevart (_, Devart) respondedYou 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.
-
0 votes
-
Configure SECURITY DEFINER
Have an option to be able to configure the default SECURITY DEFINER, currently it always selects Definer and the current user. I want to be able to configure a different user or for it to be SECURITY INVOKER.
6 votes -
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 joinintellisense 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 -
procedure combined layout shortcut
Hello
I need combined layout shortcut for editing procedure or function.
Always, I click split or combined button.
It's very inconvenience.
1 vote -
NEXT AND PRIOR SQL
in the previous version there was the option to navigate within the same document between the commands executed next / previous ... I noticed that in the new version 7.3 no longer exists this command. My suggestion since I see that there is no longer this possibility and it is impossible to access the history in another tab copying and pasting I would like to know if it would have the possibility since it has all the recorded history (and it was good) to have a command or key that navigate to history by copying the command automatically to the…
1 vote
- Don't see your idea?