Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysql update failed, now apache also down---

Discussion in 'Database Discussion' started by vindsl, Jul 30, 2010.

  1. vindsl

    vindsl Registered

    Jul 30, 2010
    Likes Received:
    Trophy Points:
    (Happy sysadmin day btw!)

    I tried to update Mysql from 4.0 to 5.1 via WHM but i got the following error near the start of the process:

    'ERROR: 1136 Column count doesn't match value count at row 1
    071126 20:49:18 [ERROR] Aborting '

    And the update failed, and also i think the process tried to recompile apache and PHP because i cant start/restart httpd either.

    If i try to recompile Apache, i get the following error:

    Fetching (0)....@
    checkyum version 20.5
    checkyum version 20.5
    !! Package system can not be repaired automatically !!


    Apache Restart Output:
    Syntax error on line 9 of /usr/local/apache/conf/php.conf:
    Cannot load /usr/local/apache/libexec/ into server: /usr/lib/ version `libmysqlclient_14' not found (required by /usr/local/apache/libexec/
    /etc/init.d/httpd start: httpd could not be started

    So both daemons are unresponsive now,
    I tried mysqlup --force.. still the same..

    anyone halp? =)
    is there a way to really really force a apache and mysql reinstall? seems both of them are broken now :/
    #1 vindsl, Jul 30, 2010
    Last edited: Jul 30, 2010
  2. jeffmonte

    jeffmonte Member

    Jul 28, 2010
    Likes Received:
    Trophy Points:
    I have had a same situation, I just made a backup of mysql databases.

    cp -rp /var/lib/mysql /var/lib/mysql.back

    Then I just moved the actual mysql directory to some other dir.

    cd /var/lib

    Then mv mysql mysql.bk

    Then I just ran /scripts/mysqlup --force

    As the way, it just fixed up.

    Then I just copied the databases to the actual mysql dir.

    I assume the issue is with the mysql database in which the tables are not being allowed to get altered.

    Try this as this is one of my strategy...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice