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,743
    Likes Received:
    110
    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,743
    Likes Received:
    110
    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. jwhitesell

    Unroutable address

    jwhitesell, Sep 17, 2018 at 6:25 PM, in forum: E-mail Discussion
    Replies:
    2
    Views:
    25
    cPanelLauren
    Sep 18, 2018 at 11:21 AM
  2. gizmo80

    Turn off Strict_trans_tables for one account?

    gizmo80, Sep 6, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    53
    cPanelLauren
    Sep 11, 2018
  3. darkshifty

    Failed to download pear/HTTP_OAuth within preferred state "stable"

    darkshifty, Sep 5, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    38
    cPanelLauren
    Sep 5, 2018
  4. cPanelBenny

    cPanel & WHM Version 74 to STABLE

    cPanelBenny, Sep 4, 2018, in forum: cPanel Announcements
    Replies:
    0
    Views:
    103
    cPanelBenny
    Sep 4, 2018
  5. Hugo Aguiar

    Resolving services that are running outdated executables

    Hugo Aguiar, Aug 22, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    82
    cPanelLauren
    Aug 23, 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