The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql Character Error - Driving me CRAZY!

Discussion in 'General Discussion' started by alrock, Nov 27, 2004.

  1. alrock

    alrock Active Member

    Joined:
    May 31, 2004
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    I have had serious issues with Mysql for a few weeks.

    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.

    No, here's where the funky stuff comes in.

    During Cpanel backups, I see this error over and over again:

    Grabbing mysql dbs...DBD::mysql::st 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::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 686.
    DBD::mysql::st 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::st 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?
     
  2. sawbuck

    sawbuck Well-Known Member

    Joined:
    Jan 18, 2004
    Messages:
    1,367
    Likes Received:
    5
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Contact Chirpy on this forum.
     
  3. alrock

    alrock Active Member

    Joined:
    May 31, 2004
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    I will do that. Thank you!
     
Loading...

Share This Page