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.

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,384
    Likes Received:
    23
    Trophy Points:
    38
    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:
     
  2. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    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:
     
  3. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,384
    Likes Received:
    23
    Trophy Points:
    38
    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:
     
Loading...

Share This Page