You have a CW server that is currently on an older version of ConnectWise Automate and during your upgrade path you receive a failure during the patching of Automate. The error message: Incorrect information in file: .\labtech\microsoftnoncompliantpatchcounts.frm’

So how to fix this?

You will need to log into your Automate servers desktop and launch SQLYog or connect to server via SQLYog or MYSQL Workbench over the local network. Now before you do anything you should backup your Automate server and/or SQL databases so that you can restore back to an operational level if things go south. You should of done this prior to starting any upgrade of Automate so you should be safe to continue with fix.

Now that your connected you should be able to see the list of databases on your Automate server like the image above. If you do not already have one, create a new database called test. Next open the test database and select the Tables sub item, right click and select to Create Table. Call the new table microsoftnoncompliantpatchcounts, it can have just one column that should default to numerical column and private key, save the table. Now exit the SQL editor your using.

Next, it’s time to stop the LabMySQL services on the Automate server. Copy the file %programdata%\mysql\mysql server 5.6\data\test\microsoftnoncompliantpatchcounts.frm to %programdata%\mysql\mysql server 5.6\data\labtech\microsoftnoncompliantpatchcounts.frm and overwrite the existing file that is there. Now restart the LabMySQL Service and log back into the SQL services using SQLYog or MYSQL Workbench.

In your SQL editor open a clean query window by selecting the database you want (labtech) and then selecting new query window button. In the new query window and paste or type the following SQL command DROP TABLE IF EXISTS microsoftnoncompliantpatchcounts; The results returned should be 1 queries executed, 1 success, 0 errors, 0 warnings.

Now go execute the failing ConnectWise Automate patch and see if it now succeeds?

 

Everytime you try to run the Windows Updater you always get the message  “Windows can’t update important files and services while the system is using them.  Save any open files and restart the computer, and try to check for new updates.“   This is caused by a Registry Key that has not been removed after a previous update.

There is… Continue reading

Tagged with:
 

How to display hidden device drivers in Windows Device Manager

On February 1, 2012, in How-to, by Cubert aka (Cube Dweller)

Ever wanted to find that other ethernet device that was pulled from you system but don’t see it anymore in Microsoft  Windows Device Manager? What about a pesky AOL adapter driver or some other non existant device that you want to get rid of?

In order to show hidden devices:

 

  1. Right click My Computer and Select Properties
  2. Click Advanced tab
  3. Click Environment Variables
Tagged with:
 

[How To] – Patching Standalone vSphere 5 ESXi Hosts

On January 6, 2012, in How-to, by Cubert aka (Cube Dweller)

So you have a standalone ESXi host or 2 that needs to be patched with the latest updates coming out of VMWare and you do not have a VCenter or are otherwise using the VMWare Update Manager. Here is the basic steps to get you updated and all patched up.

 

 Here are the steps to getting your… Continue reading

Tagged with:
 

[Solved]-Windows Easy Transfer Won’t Connect Between Systems Across The Network

On September 28, 2011, in How-to, by Cubert aka (Cube Dweller)

How to get your Windows Easy Transfer to work over the Network.

This is a very common issue, I seem to hit the never ending “Trying to Connect” cycle of death on just about every other time I use Windows Easy Transfer. It doesn’t matter if your doing a transfer from XP to 7 or from 7 to 7, I’ve seen it time and time again.

I foung the… Continue reading

Tagged with:
 
Protected post.
Tagged with:
 

How-to : Pass a username and password to Windows shutdown.exe command.

On July 29, 2011, in How-to, by Cubert aka (Cube Dweller)

Here was my scenario I found myself in not to long ago. I have an Active Directory domain with a server outside of the domain in it’s own workgroup. It used different credentials for the administrator account then what the domain uses. One day it stopped responding to RDP and several control programs we have on it so we needed to do a reboot.

No problems right? just type… Continue reading

Tagged with:
 

How-to : Setup GoDaddy SSL on Tomcat using a Public Certificate

On July 28, 2011, in How-to, by Cubert aka (Cube Dweller)

Hello again,

Today I will be walking you through the process of setting up your Tomcat installation to use a public SSL certificate. I will be using examples from my Ubuntu 11 box but this will work with any linux based Tomcat install.  We should have you up and running in just a few minutes, here is what we… Continue reading

Tagged with:
 

How-to: Setup Ubuntu and PHP to use MSSQL Microsoft SQL Server

On July 21, 2011, in How-to, by Cubert aka (Cube Dweller)

It is easier to get PHP on Ubuntu to connect to MSSQL than it is to get PHP on Windows.

 

I would not normally believe such a thing until I tried to setup a pre-existing install of PHP on Windows missing any MSSQL extensions. Looking through Google to find information was less than quick and I found myself wanting to go back to my old faithful Ubuntu server… Continue reading

Tagged with:
 

Increasing MS Exchange 2010 message size limits

On July 13, 2011, in How-to, by Cubert aka (Cube Dweller)

There’s a few places you must go to change this and that is in global settings under Organization Configurations as well as the HUB Transport connectors under Server Configuration.

To modify the global settings go to the following menu areas inside you Exchange Management Console. 
Organization Configuration->Hub Transport->Global Settings tab->Properties of Transport Settings
 

Here you can adjust your… Continue reading