75 results found
-
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 -
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 -
Backup/Restore does not order Views so that a View that references another View is after the referenced View
When doing a Backup / Restore, It does order the Views so that if one View references another, the referenced View is defined first. I assume it orders them by case. Could you make it so that it defines the prerequisite views first or ahead of the views that require them.
Thanks for the amazing program, I realize this probably isnt a bug in dbForge but more a generic SQL issue but it would be nice if dbForge would transparently order them when making a backup.
1 vote -
Can't login to forum, goes around in circles
I don't know my username, I know my email, I can't request my password as it says my account is activated, but I can't get the activation email because I don't know the username apparently.
Someone help, very frustrating
1 vote -
CLIENT_INTERACTIVE flag in mysql_real_connect
How about an option in the connection string to mark the connection as an interactive one so that interactivetimeout applies instead of waittimeout?
1 vote -
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 -
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 -
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 -
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 -
Support reserved keywords and events in MySQL 8.0
dbForge Studio 2019 for MySQL 8.1.22
When sync data between MySQL 5.7.25 and MySQL 8.0.15 and table have field name in reserver keywords, got error like "check syntax ", rank,", fields and tables names must be enclosed in apostrophes.
MySQL 8.0 event like
CREATE
DEFINER = 'username'@'localhost'
EVENT odatabase.eventname
ON SCHEDULE EVERY '1' WEEK
...
in GUI shows as "every '7' (SEVEN) weeks", but DDL is right.1 vote -
Code for CREATE TABLE with MariaDb "system versioning" is not generated correctly.
On a table with system versioning, from context menu I select:
Generate script as > CREATE > To new SQL window.
And the output does not include SYSTEM VERSIONING data at all.
When I run SHOW CREATE TABLE tablename - I get correct information.The same with "Edit table"
(In general it would be nice to set, if "Generate script" uses dbForge engine, or from database "SHOW CREATE TABLE", because output sometimes is drastically different)0 votes -
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 .
-
Find Invalide Objects
== English ==
The "Find Invalid Objects" wizard lists the following objects in the new version "dbForge Studio for MySQL 9.0.338":Temporary tables are listed in Views as not being found
In Vden Views, the temporary tables are e.g. created with the following command:
WITH RECURSIVETMP
as Select .... from ...) Select ... from TMPcrdebug.ENTERMODULE2 is not found. It is searched in the respective database; but not in the cr_debug database.
crdebug.ENTERHANDLER is not found. It is searched in the respective database; but not in the cr_debug database.
No further objects from the cr…
0 votes -
scroll 'wheels' do not work
Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.
0 votesAdminDevart (_, Devart) respondedYou could try the following instructions http://www.microsoft.com/hardware/en-us/help/windows-8/how-to/mouse/use-partialscroll-mouse
-
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 votesAdminDevart (_, Devart) respondedCould 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.
- Don't see your idea?