Table 'XXXX.UserInfo' doesn't exist

What version are you running?

The UserInfo table is an RDM table that gets deleted (actually split into two tables then deleted) when you upgrade to v14.0.x. Once that is done any version prior to v14 will fail.

If in workbench the field DatabaseVersion is higher than 122 then v14 has been installed and the database upgraded. Try running the latest v14 build and all should be ok

13.6.7.0. I am pretty sure I set the option where it only limited the use of version 13.x and below. I will install 14 and see what happens.

One of my colleagues informed me they tried 14.x and had installed it some time last week.

So, i installed 14.0.6.0. Attached is screen shot when I launch 14. Confirms I set the option to not allow version 14 to connect. So did it still get upgraded and ignored that option and now that it is upgraded is still enforcing that option? So confused.

where would I look in mysql bench to verify the "version" that is installed? I don't know much about sql database, but I can figure out where to look with the exact directions :).

With workbench, if you execute the following: SELECT DatabaseVersion FROM DatabaseInfo;
If that returns 122, you can run v13.6.7, if you get anything over 122 you must run v14.

The message you are seeing is the Version Management feature of RDM:
https://help.remotedesktopmanager.com/index.html?datasourcesettings_versionmanagement.htm

You must likely have a database version over 122 but with a Version Management specified for under v13.6.7.

If you connect, using v14 with an Admin account, the minimum/maximum warning will be ignored and you can go to Administration > Data Source Settings > Applications > Version Management and remove/fix the min/max versions.

Best regards,

returns 262...explains it.

I'm in. The colleague that installed 14 is an admin, so i see what happened.

Hi.. My company has a license for version 10. installed 14 and now I get that rdm.UserInfo doesn't exist message. I've uninstalled a number of times and deleted the Devolution program files folder, but each time I try to install, it still wants to connect to that table. The other people on my team are OK and they can connect to the database. Nothing got upgraded. I just have a new laptop and need to get the program to work. What else can i delete so it acts like it is being installed fresh. Thank you!

@dkasseb,

If you install RDM 14 and update the database, all the users in your organization that use RDM 10 would need to update to RDM 14 since the database upgrade is not backward compatible.

If you install the same version as your colleague, are you able to connect on the database?

What type of data source are you using? MySQL or MariaDB?

Best regards,

Hi Jeff,


I did not upgrade the database. I didn't want to do that and screw up the rest of my team. I am able to connect to the DB by testing the host and schema. That works. Our database is on one of our tool servers and it runs off mysql.

I have tried to get back down to version 10 or 12 like the rest of my colleagues, but somehow the system tries to connect it refers to the table that doesn't exist. I've attempted to access the data source settings, but it doesn't seem to allow me to click into it. Trying to work with the Version Management.


Thank you.

Hello,

There's maybe something wrong with your configuration file.

Is it possible to navigate to %localappdata%\Devolutions\RemoteDesktopManager and rename the RemoteDesktopManager.cfg file to RemoteDesktopManager.old.
When you will restart RDM, a new configuration file will be created. Then, go in File -> Data Sources and recreate your data source. This should allow you to go back on the database since you are using the same version as your colleagues and they are all connected as you mentioned.

Best regards,

OK. I rebuilt the data source. I can still connect and test schema successfully. But once I get out of that and switch from the LOCAL to the Remote database, it tells me NOT CONNECTED.

I checked the logs

[4/25/2019 9:55:39 AM]ERROR SILENT MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'rdm.UserInfo' doesn't exist
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& 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.ExecuteScalar()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteScalar[T](String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseSecuritySubDataSource.GetPersonalConnectionCacheID()
at A.cdfa79a50d8d9ee05c43ccbe131e60a12.c8a4466b02ef143daa0b8c2191911a2f4()
at A.cdfa79a50d8d9ee05c43ccbe131e60a12.c04069ba9ffbdd6ade44e17268f409cdb(BaseConnectionDataSource c7f28727fc7a5daa94ba08f688b2a5781)
at Devolutions.RemoteDesktopManager.Managers.OfflineManager.Save(BaseConnectionDataSource dataSource)
at A.caffdb7cd64b8f25021522cf428831983.c7e3e13f9d1a0c905aa421714e6a7ea61()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.ca4799bebd8b706f34eea94a778843b55(BaseConnectionDataSource c01af917dca3518ff73ed69848f95f91a)

Hello,

Very strange that your colleagues are able to connect properly on the same database.

Best regards,

Looks like our DB guru will have to restore a back up of the DB. He had to do this for another group's DB instance.

Hello,

Thank you for the feedback. Hope this will resolve your issue/error message.

Best regards,