62 results found
-
When Comparing two database schemes i am facing the issue
170407 12:16:38 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.keybuffersize=16777216
readbuffersize=262144
maxusedconnections=2
maxthreads=151
threadcount=2
connectioncount=2
It is possible that mysqld could use…1 vote -
the unsubscribe link does not work as a link. Suggestion: repair it.
In your emailed advertisement the unsubscribe link does not work as a link. Suggestion: repair it.
1 voteWe have fixed this issue.
Sorry for the inconvenience.
-
encode
When checking for updates(Help | Check for Updates...), encode the Devart authentication login field. This way email addresses containing a plus(+) will not fail.
1 vote -
time fields
sice today's release, time fields appear "1.12:45:00" instead of "12:45:00"
1 voteWe would like to let you know that we have released dbForge Studio for MySQL, v7.2.50 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/studio/download.html
Thank you for your help in improving dbForge Studio for MySQL.
-
Support version 5.7.15
Dbforge studio can't connect to mysql 5.7.15.
4 votesWe would like to let you know that we have released dbForge Studio for MySQL, v7.1.20 where MySQL 5.7.15 is supported https://www.devart.com/dbforge/mysql/studio/download.html
Thank you for your help in improving dbForge Studio for MySQL.
-
When editing the build order, the changes should actually be saved to the xxx.mydev file.
when adding a new table to a project, it is added to the bottom of the build order list. If I edit the list thru the project properties > build order tab, the order changes are not persisted. I have had to edit the xxx.mydev file manually (outside of visual studio) to get the build to create the .sql file with the table listed in the right order based on foreign key dependencies.
2 votesBuild Order is detected automatically.
-
Crash when pasting text
CREATE DEFINER = 'camskpn'@'%'
PROCEDURE cams_kpn.proctest(operation int, PID int, CID int, DID int, UID int, ct varchar(50), CLID int)
BEGIN/*
operations - Properties
1 = Contract Select - PID ProjectID
2 = Doc List - CID ContractID
3 = Linked Documents - DID DocID
4 = Ball in Court - DID DocID
5 = Change Issues - DID DocID
6 = Change Sources - DID DocID
7 = Change Items - DID DocID
8 = Filters - UID UserID
9 = DocumentDetail - DID DocID
10 = DocTypes
11 = Stati
12 = Change Categories
13 = Approval Type…1 voteThis issue is fixed in version 7.2 https://www.devart.com/dbforge/mysql/studio/download.html
-
Process left in memory after program closes.
Each new run left another instance. Eat memory, lock updates. All 7.x versions, last 7.0.52.0 too.
3 votes -
Upgrade ssh connection / Can't connect on openssh > 7.0
OpenSSH 7.0 defaults to no support for diffie-hellman-group1-sha1 key
exchange.If we can't edit the config of openssh, we can't use the SSH security feature. Can you upgrade the lib and use one of the default protocol ?
0 votes -
Support for fractional datetime
since Mysql 5.6.4 (2011), there is a support for fractional datetime and timestamp.
cf. http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
select now(6) should return 2015-07-16 23:48:52.720993 (like with phpmyadmin) and not 16/07/2015 23:46:52
or better , it should return the localized version 16/07/2015 23:46:52.720993
3 votesThis can be setup as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → Formatting’ branch.
3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
5. Click ‘OK’. -
Cannot edit views if column no longer exists
If you have a view that uses/selects columns that no longer exist, you cannot open the view to edit/fix the missing columns:
View '<TABLE>.<VIEW>' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
3 votesPlease check that you are using the latest build 6.3.358 https://www.devart.com/dbforge/mysql/studio/download.html
-
replication
When you modify the database structure, e.g. delete a table in a particulary database, dbforge dont use that database, instead of that, modify directly the database information_shema, so there are problems in replication configurations.
0 votes -
Problems with Intellisense drop down box not updating
v 6.3.341
Open a SQL editor window, write a SELECT query - list the FROM tables, start to build SELECT clause.
Don't save Query - leave open in editor. Open a Table being referenced in query, and add a new field. Switch back to SQL editor. The new field doesn't appear in the Intellisense drop down (or whatever you call the drop down box - MS call it Intellisence) as you type.
I was doing this in the SELECT clause. I had also given the tables aliases in the FROM clause, if that make any difference.Many thanks.
1 vote -
Make "AS" keyword auto-select in code completion dropdown.
Most keywords seem to auto-select in the code completion dropdown as you type, with the only exception I've noticed so far being "AS" for column and table aliases (even though its the only choice in the list most of the time). Other short keywords such as "ON" and "BY" will auto-select, making it easy to type in lower case, get the suggestion dropdown, have it automatically selected for you, hit Enter to get the upper case equivalent and keep on going. With "AS" it breaks that pattern requiring you to hit down to select it in the list first.
3 votesIt’s not highlighted because this could be a part of a user-defined alias starting with AS…
Though, you can manage this with the ‘Select items in the list even if a user input is expected’ option available in the ‘Text Editor → Code Completion → List Members’ branch of the ‘Options’ window that can be invoked by selecting ‘Tools → Options…’ from the main menu.
-
When searching objects (cntrl+D,F), searching in tables data and you get a lot of results, that do not fit in result windows, a scroll bar i
When searching objects (cntrl+D,F), searching in tables data and you get a lot of results, that do not fit in result windows, a scroll bar did not show up. It needs to click on the place where it should be, only then it appears.
3 votes -
Not open some of the procedures for editing.
Not open some of the procedures, don't know what it is, but with a short name opening all the time, and long not open > ~ 40 characters (can cause). The error message "Cannot parse the source code"
3 votesWe would like to let you know that we have released a new build 6.3.339 of dbForge Studio for MySQL where the issue you reported is fixed http://www.devart.com/dbforge/mysql/studio/download.html
Thank you for your help in improving dbForge Studio for MySQL.
-
Issue with import of DATE/DATETIME fields from Excel 2007
In latest version of dbForge while importing Excel 2007 file columns formatted as a date cannot be properly recognized as dates (they are recognized by dbForge as serial numbers) and due to this cannot be properly imported to the corresponding table fields. In older versions such bug hasn't had a place.
Import date fields from Excel 2003 works fine in 6.3.330 version.BR
3 votes -
1 vote
-
Database Explorer doesn't update - 6.2.280
Under newest version (6.2.280) database explorer doesn't update, even after manually refreshing.
1 vote -
Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
This happens when the default value on a field is currenttimestamp(6) ON UPDATE currenttimestamp(6)
Example of what gets generated.
CREATE TABLE test.junkola (
Id int(11) NOT NULL AUTOINCREMENT,
RowVersion datetime(6) NOT NULL DEFAULT 'CURRENTTIMESTAMP(6)' ON UPDATE CURRENT_TIMESTAMP (6),
PRIMARY KEY (Id)
)The QUOTES around 'current_timestamp(6)' do not compile in your tool.
3 votes
- Don't see your idea?