75 results found
-
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 -
Fixing database in git repo
When view contains some unicode notation for fields aka N' it shows difference over and over even after fixing.
When field contined some collation it shows difference over and over.
[ModelNumber] [varchar](50) COLLATE SQLLatin1GeneralCP1CI_AS NOT NULLPls fix it asap. I have dozen of objects showing that they have difference however they don't
3 votes -
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 voteAdminDevart (_, Devart) respondedCould 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
-
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 -
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 voteAdminDevart (_, Devart) respondedCould 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
-
I need posibility to run SQL not SQL files only.
SQL code saved in file with "config" extension cannot be executed. Can you redefine this ? I need posibility to run SQL not SQL files only.
2 votesAdminDevart (_, Devart) respondedCould you please let us know why you need this?
-
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 -
3 votesAdminDevart (_, Devart) responded
Could you please provide us a concrete example of this?
You can send a reply straight to our support system at supportATdevartDOTcom
-
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 voteAdminDevart (_, Devart) respondedPlease 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.
-
Floating Windows - why is this disabled for DB object tabs?
I'm not sure if this is a bug or if I'm just "holding it wrong" but there doesn't appear to be a way to get object editing tabs to float. Windows like the Object Viewer do (though this is disappointingly without independent minimising controls) but if I'm editing a table or a sproc then the "Float" option is disabled.
Is there a reason for this?
Ideally I think it would greatly help the product if it were possible to float windows and group floated windows into one floating tab group and if each floating object can be minimised/maximised independently of…
2 votes -
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 voteAdminDevart (_, Devart) respondedCould 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.
-
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 -
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 -
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 voteAdminDevart (_, Devart) respondedCould 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?
-
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
- Don't see your idea?