76 results found
-
1 vote
-
Erro no atalho
Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar
1 vote -
Export to MS Excel 2007
Currently, exporting to MS Excel 2007 more than 1048576 rows, dbForge doesn't slipt to a new Sheet the remaining rows.
1 vote -
Character set 'perlogicalinterfacedtoview' is not supported
Comparing two databases I encounter this error.
I have selected "Detect mysql charset" as I am advised by the error message.
However I keep receiving this error.
Is there a way to manually add some encodings?
I have updated the application to the latest update.
DB forge Studio for Mysql Pro.1 vote -
1 vote
-
Selected cell of Data-Compare goes blank
Awesome product btw - (just) one annoying bug:
This relates to the top part of the data compare section; any selected cell to pick a related view turns white and doesn't show the number anymore - just the checkbox. Same for the source or target object name.
(Moving away to see the number again resets the list view; looking at the tag bubble of the list requires searching the columns since the position is always shifting based on the length of all numbers. Not so much fun on large data sets)
Thanks for your fantastic work,
Regards,
Martin.(customer since…
1 vote -
Compare data bases lists table as different, thought they are the identical
When comparing databases, we constantly get the tables with no differences. And final script doesn't have any alter statements.
Ex.: the table
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT NULL,
SiteGroupId INT NOT NULL
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb40900ai_ci;ALTER TABLE SecurityContextXSiteGroup
ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;The other table ("differs"):
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT…1 vote -
Profiling for queries with CTEs
When running the query profiler on a query that contains CTEs, the results are not accurate and the Explain Plan section does not appear in the profiler tree.
To profile queries with CTEs I have to re-write them as subqueries which is a waste of time and makes it more difficult to read.
1 vote -
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
USAWhen getting this field content through select, only the first line ("My Business") is displayed in the result panel.
1 vote -
Facilitate MariaDB 10.11
The current version of DB fORGE STUDIO supports up to MariaDB 10.6 which is limited in respect of JSON functionality. With respect to querying you cannot join a regular table on a JSON path or use methods like JSON_TABLE(). Such efforts result in an error.
1 vote -
output window
1) meanwhile the execution of SQL script file if I click on some other window, ant then return in output window...the output windows shows the first output...and not the (more usefull) last one.
2) please fix it! I have more than one schema. I select the first one. Open a SQL file...launch it. Ok. I open a second SQL file...THE SCHEMA CHANGE without show me the change and dbForge run the SQL script on the second schema!!! Damn it!
1 vote -
Error when importing DBF file with field type CURRENCY
A have dbf files with FoxPro database. When i trying to import file with CURRENCY datafields I get error: "Неверный или неизвестный тип колонки DBF"
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us the CREATE definition of the table into which you are importing data and the imported .dbf file so we can reproduce this issue on our side?
-
Stop the view from being centered after moving an object with the arrow keys in the Database Diagram view
(or add an option if this is intended behavior). If I am zoomed in and move an object with the arrow keys the view will center on the object which makes moving something relative to something else that [was visible before the centering] very hard to do. It looks like the system is trying to guarantee the whole object is visible which results in the jumping if part of it is outside the view (clipped).
1 vote
AdminDevart
(_, Devart)
responded
Could you please describe this in more detail? Screenshots or video will be also of help.
You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.
-
Data viewer stops working
The data viewer stops working intermittently. The only way to get it working again is to restart dbForge. I execute a query, and then right click on a cell in the results and select Data Viewer. In most cases this shows the data in the Data Viewer panel but it regularly jus displays nothing.
1 vote
AdminDevart
(_, Devart)
responded
Please make sure you are using the latest build 6.2.280.
If the issue still persists in the latest build, please provide us the CREATE definition of the table and a test record so we can reproduce the issue on our side.
You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.
-
Issue with / character on its own line in a stored proc
I am working with other devs, one of which uses another app for sp's.
In his app he has a weird formatter, but it will place / on there own line as part of a division statement in the sp.
dbForge for MySQL won't even open the sp, says it cannot parse the sp, so I cannot even open the sp to edit it.
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us the CREATE definition of the stored procedure and let us know what version of dbForge you are using?
You can reply straight to our support system at supportATdevartDOTcom
-
there is a BUG on the tool
When you reverse engineer a table with a column defined like this
tdate timestamp NOT NULL DEFAULT date(CURRENTTIMESTAMP) ON UPDATE CURRENTTIMESTAMP
after any change in the table, unrelated, you write the same column as
tdate timestamp NOT NULL DEFAULT 'date(CURRENTTIMESTAMP)' ON UPDATE CURRENTTIMESTAMP
which is wrong, the quotes cannot be there. The modification fails.1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us the CREATE definition of the table and specify what version of dbForge Studio for MySQL you are using?
You can reply straight to our support system at supportATdevartDOTcom
-
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
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
-
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
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.
-
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.
…1 vote
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 .
-
The wildcard characters “%” and “_” can be used in the Host and Db columns of either table. These have the same meaning as for pattern-match
Granting privileges has issues if the database name contains an underscore.
If the database privileges have been defined on the mysql command line or in pma myadmin the underscores are escaped so that an exact match of the database name applies.
eg.
GRANT select on
my\_db.* TO 'user'@'host'DbForge does not escape the _ character and creates a new privilege:
GRANT INSERT on
my_db.* TO 'user'@'host'If the 'my_db' escaped SELECT privilege is present then the INSERT privilege created by dbForge is ignored.
The underscores in database and host names should be escaped out by dbForge when it…
1 vote
- Don't see your idea?