Devart Forums

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!

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

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.

================================================================
| 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 |
----------------------------------------------------------------

Thank you for the reply.

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

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.