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!

Table corruption with MySQL4

Discussion in 'General Discussion' started by sparek-3, Jul 21, 2003.

  1. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,772
    Likes Received:
    119
    Trophy Points:
    343
    cPanel Access Level:
    Root Administrator
    We have users complaining of table corruption since the MySQL was updated to version 4. We recompiled PHP to use the newer MySQL client API and that seemed to fix a lot of the problems. However, we have clients that are using CGI scripts and complaining of table corruption. Specifically the Ikonboard forum script, the CGI version. Does anyone know what might be causing the corruption, or how to fix this problem? The MySQL Client API is 4.0.13, but this is for PHP and does not really affect CGI and perl scripts.

    cPanel.net Support Ticket Number:
     
    #1 sparek-3, Jul 21, 2003
  2. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    166
    Users should check to make sure that their version of Ikonboard is up to date and compatible with the new version of MySQL.

    You may also want to verify that the scripts have enough time to execute and that either the scripts or the MySQL processes aren't being killed off because of extended execution times.

    Perhaps while you're in it, take a look at the file system to make sure it's in good shape as well.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 ciphervendor, Jul 21, 2003
  3. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,772
    Likes Received:
    119
    Trophy Points:
    343
    cPanel Access Level:
    Root Administrator
    You may also want to verify that the scripts have enough time to execute and that either the scripts or the MySQL processes aren't being killed off because of extended execution times.

    How would you go about checking this?

    cPanel.net Support Ticket Number:
     
    #3 sparek-3, Jul 21, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Table corruption MySQL4
  1. kernow

    SOLVED [CPANEL-22320] Table mysql/innodb_index_stats has length mismatch

    kernow, Nov 11, 2018 at 11:58 AM, in forum: Database Discussion
    Replies:
    5
    Views:
    67
    kernow
    Nov 13, 2018 at 2:13 AM
  2. Uchechukwu Onochie

    PHP is not seeing MySQL database user table

    Uchechukwu Onochie, Nov 11, 2018 at 4:24 AM, in forum: Database Discussion
    Replies:
    1
    Views:
    50
    cPanelLauren
    Nov 13, 2018 at 9:05 AM
  3. Gareth-AWD

    SOLVED PHPMyAdmin Truncate Table bug

    Gareth-AWD, Nov 7, 2018 at 3:52 AM, in forum: Database Discussion
    Replies:
    4
    Views:
    80
    Gareth-AWD
    Nov 9, 2018 at 8:00 AM
  4. daemoncesar

    cPanel & WHM has determined that the following database tables are corrupt

    daemoncesar, Oct 9, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    90
    cPanelLauren
    Oct 9, 2018
  5. Heena

    Incorrect key file for table try to repair it error

    Heena, Oct 9, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    92
    cPanelLauren
    Oct 10, 2018

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.
    Accept Learn More...
    Dismiss Notice