DbForge Studio 6.1.98 Beta Error

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

DbForge Studio 6.1.98 Beta Error

Post by idem84 » Fri 20 Dec 2013 16:23

Previous version of dbforge works ok in MariaDb server hosted in debian/linux
Using DbForge Beta 6.1.98 with MariaDb hosted in windows works ok
Exception throws only in MariaDb server hosted in debian/linux (DbForge Beta 6.1.98) [MariaDB Galera 5.5.33a and Debian Wheezy]
How to reproduce
Expanding in database explorer only shows "Table" and "UDFs" items...
Trying expanding "Tables" throws exception i cant view neither sp´s functions tables, etc.

=========================
General
=========================
Application: dbForge Studio for MySQL
Product: Devart dbForge Studio Beta for MySQL
Product Edition: Professional
Product Locale: English
Assembly: dbforgemysql, Version=6.1.98.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio Beta for MySQL\dbforgemysql.exe
Global cache: False
Framework: 2.0.50727.7905

=========================
Exception Information
=========================
Message: IndexOutOfRange
Source: Devart.DbForge.Data.MySql
TargetSite: Int32 GetOrdinal(System.String)
HelpLink:
Type: System.IndexOutOfRangeException
Place: 1
Stack:
at Devart.Common.DbDataReaderBase.GetOrdinal(String name)
at Devart.DbForge.DbObjects.MySql.MySqlTable.InitializeFromReader(IDataReader reader, Boolean isReaderComplex)
at Devart.DbForge.DbObjects.DbDatabase.InternalCreateObjects[TDbObject](TDbObject tempObject, ao0 createParams, b getObjectHandler, a refreshTempObjectHandler, Boolean objectSupportsEquals)
at Devart.DbForge.DbObjects.MySql.MySqlDatabase.CreateSchemaObjects(ao0 createParams)
at Devart.DbForge.DbObjects.DbObject.InternalCreateSchemaObjects(ao0 createParams)
at Devart.DbForge.DbObjects.DbObject.InternalCreateSchemaObjects(String groupName, IDataReader reader, IList list, Boolean force, IAsyncOperation asyncOperation, Boolean IsReaderComplex, Boolean cacheObjects)
at Devart.DbForge.DbObjects.MySql.MySqlDatabase.i.a(IDataReader A_0)
at Devart.DbForge.DbObjects.DbObject.GetSchemaInfo(IDbObject dbObject, String sqlText, IDbCommandExtension command, IAsyncOperation asyncOperation, ReaderReadDelegate readerMethod)
at Devart.DbForge.DbObjects.MySql.MySqlDatabase.CreateTables(IList list, IDbCommandExtension command, Boolean force, SchemaType schemaType, IAsyncOperation asyncOperation, Boolean isReaderComplex)
at Devart.DbForge.DbObjects.MySql.MySqlDatabase.g(IList A_0, IDbCommandExtension A_1, Boolean A_2, SchemaType A_3, IAsyncOperation A_4)
at bml.a(IDbCommandExtension A_0, Boolean A_1, SchemaType A_2, IAsyncOperation A_3)
at bml.CreateChildren(IList list, IDbCommandExtension command, Boolean force, SchemaType schemaType, IAsyncOperation asyncOperation)
at qy.CreateChildren(IDbCommandExtension command, IContainerObject parentObject, Boolean force, SchemaType schemaType, IAsyncOperation asyncOperation)
at a56.DoCreateChildren(Object nodeObject, Boolean force, IAsyncOperation asyncOperation)
at a56.CreateChildren(Object nodeObject, Boolean force, IAsyncOperation asyncOperation)
at Devart.Shell.Utils.HierarchyBase.a(INode A_0, Boolean A_1, Boolean A_2, HierarchyErrorAction& A_3)
at Devart.Shell.Utils.CreateChildrenOperation.DoWork()
at Devart.Shell.Utils.AsyncOperation.c()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)


Thanks in advance!
Last edited by idem84 on Thu 26 Dec 2013 21:58, edited 2 times in total.

alexa

Re: DbForge Studio 6.1.98 Beta Error

Post by alexa » Mon 23 Dec 2013 15:21

We are currently investigating this issue and will answer you as soon as possible.

alexa

Re: DbForge Studio 6.1.98 Beta Error

Post by alexa » Tue 24 Dec 2013 10:33

Could you please help us some more in investigating this issue and send is the result of the following query:

SELECT COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'COLUMNS';

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you via e-mail.

idem84
Posts: 51
Joined: Thu 04 Apr 2013 19:12

Re: DbForge Studio 6.1.98 Beta Error

Post by idem84 » Tue 24 Dec 2013 16:51

================================================================
| COLUMN_NAME | CHARACTER_SET_NAME | COLLATION_NAME |
================================================================
| TABLE_CATALOG | utf8 | utf8_general_ci |
----------------------------------------------------------------
| TABLE_SCHEMA | utf8 | utf8_general_ci |
----------------------------------------------------------------
| TABLE_NAME | utf8 | utf8_general_ci |
----------------------------------------------------------------
| COLUMN_NAME | utf8 | utf8_general_ci |
----------------------------------------------------------------
| ORDINAL_POSITION | null | null |
----------------------------------------------------------------
| COLUMN_DEFAULT | utf8 | utf8_general_ci |
----------------------------------------------------------------
| IS_NULLABLE | utf8 | utf8_general_ci |
----------------------------------------------------------------
| DATA_TYPE | utf8 | utf8_general_ci |
----------------------------------------------------------------
|CHARACTER_MAXIMUM_LE| null | null |
| NGTH | | |
----------------------------------------------------------------
|CHARACTER_OCTET_LENG| null | null |
| TH | | |
----------------------------------------------------------------
| NUMERIC_PRECISION | null | null |
----------------------------------------------------------------
| NUMERIC_SCALE | null | null |
----------------------------------------------------------------
| DATETIME_PRECISION | null | null |
----------------------------------------------------------------
| CHARACTER_SET_NAME | utf8 | utf8_general_ci |
----------------------------------------------------------------
| COLLATION_NAME | utf8 | utf8_general_ci |
----------------------------------------------------------------
| COLUMN_TYPE | utf8 | utf8_general_ci |
----------------------------------------------------------------
| COLUMN_KEY | utf8 | utf8_general_ci |
----------------------------------------------------------------
| EXTRA | utf8 | utf8_general_ci |
----------------------------------------------------------------
| PRIVILEGES | utf8 | utf8_general_ci |
----------------------------------------------------------------
| COLUMN_COMMENT | utf8 | utf8_general_ci |
----------------------------------------------------------------

alexa

Re: DbForge Studio 6.1.98 Beta Error

Post by alexa » Wed 25 Dec 2013 09:18

Thank you for the reply.

We are currently investigating this issue and will answer you as soon as possible.

alexa

Re: DbForge Studio 6.1.98 Beta Error

Post by alexa » Thu 23 Jan 2014 17:49

We would like to let you know that the release of dbForge Studio for MySQL, v6.1, where the issue you reported is fixed, is already available for downloading
http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

Post Reply