MSQL - Error and Serious Problem
It all started after an OS reload and a fresh install of Cpanel. I am sure you all must know by now that lately there have been bad mirrors during the install, resulting in incomplete installations. This DID initially happen to me.
After steps were taken to remove the bad mirrors and force Cpanel to locate new ones, I still had Mysql issues. The first one was the issue with the .sock that seems to be so popular. That issue was solved rather quickly.
Now, here's where the funky stuff comes in.
During Cpanel backups, I see this error over and over again:
Grabbing mysql dbs...DBD::mysql:
t execute failed: Character set '#83' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file at /usr/local/cpanel/Cpanel/Mysql.pm line 685.DBD::mysql:
t fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 686.DBD::mysql:
t execute failed: Character set '#83' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file at /usr/local/cpanel/Cpanel/Mysql.pm line 693.DBD::mysql:
t fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 694.Done
This "character set" error is also preventing an install of SiteZen Site Builder from completing.
We tried removing mysql and then and recompiling from RPM's and the problem persists. In fact, now I have even more serious problems. When users access phpmyadmin, they can see, and modify, ALL other users databases.
This is a very serious issue and so far I have not found anyone who can fix these problems. I had my former admin try, as well as the admin company I now use.
I am desperate now.
Does anybody know what causes these errors and how to fix them? Can anybody recommend someone I can hire to deal with it?
