n01

Hi,

I ran the above query successfully and then tried the update again - it worked! I've sent the working schema version for your inspection if you need it

Many thanks for the great support

Niels

Email sent - thanks

What's the best way for me to get this info to you? The forum will butcher the data, and the send schema to support text field in RDM isnt big enough for all the data to be posted

Regards

Niels

Hi,

Tried the update again. Still failed but this time on a different table:

MySql.Data.MySqlClient.MySqlException (0x80004005): Can't create table 'RDMGR.SessionRecording' (errno: 150)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection dbConnection)

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)

I've emailed the schema again

Regards

Niels

Hi,

The first of the 3 alter tables gives me the following error:

/* SQL Error (1005): Can't create table 'RDMGR.#sql-57e_194b' (errno: 150) Foreign key constraint is incorrectly formed */

The last two run without issue

For clarity, this is the alter table statement that fails:

alter table `ConnectionState` add

CONSTRAINT `FK_ConnectionState_ConnectionID`

FOREIGN KEY (`ConnectionID`)

REFERENCES `Connections` (`ID`)

ON DELETE CASCADE

ON UPDATE NO ACTION;

Regards

Niels Jensen

Email sent. I added "Attn: Stefane" into the body.

Thanks

Niels

Hi,

I checked the schema - the default is set correctly (RDMGR).

When I run the query:

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA,'.',TABLE_NAME, ' ENGINE = InnoDB;')

FROM information_schema.TABLES

WHERE ENGINE='MyISAM' AND TABLE_SCHEMA = database();

I get no results.

When I check the default storage engine using:

select @@default_storage_engine;

It returns InnoDB, so it seems that's already set. I've also updated to 14.0.1.0 but the upgrade is still not working and returning

MySql.Data.MySqlClient.MySqlException (0x80004005): Can't create table 'RDMGR.ConnectionState' (errno: 150)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection dbConnection)

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)

Regards

Niels Jensen

Hi,

I've emailed the schema using the RDM 'Email schema to support' button as requested - there was no input box for subject, so I included "Attn: Stefane" in the message body along with a reference to this forum post

I'm leaving the office for the day now so will be unable to respond until 09:00 GMT+1

Many thanks

Hello,

I kind of hijacked someone else's thread with an issue I was seeing, and so I thought it might be best to create a standalone thread with my particular issue:

After installing v14, I am prompted to update the database, when I try, I get the following error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Can't create table 'RDMGR.ConnectionState' (errno: 150)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection dbConnection)

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)

Any tips on what could be causing this?

I've tried to do the update as my own user (SYSDB global privileges) as well as the MySQL DB root user account

Hi,

I'm seeing this same issue... I have to double click on the data source in the sources window which opens a sepearate connection detail window that lets me do the update. But when I do, I get the following error anyway:

MySql.Data.MySqlClient.MySqlException (0x80004005): Can't create table 'RDMGR.ConnectionState' (errno: 150)

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbConnection dbConnection)

at Devolutions.RemoteDesktopManager.Business.DataSources.MySQLConnectionDataSource.ExecuteScript(String script, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)

Any tips on what could be causing this?

I've tried to do the update as my own user (SYSDB global Privileges) as well as the DB root user account