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,675
    Likes Received:
    84
    Trophy Points:
    328
    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,675
    Likes Received:
    84
    Trophy Points:
    328
    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. carolainn

    Update is blocked because RPM database is unstable

    carolainn, Jul 13, 2018 at 9:41 AM, in forum: Database Discussion
    Replies:
    1
    Views:
    36
    cPanelLauren
    Jul 13, 2018 at 9:49 AM
  2. discostrings

    SOLVED Switching to LTS from version 70 STABLE

    discostrings, Jun 30, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    88
    cPanelLauren
    Jul 4, 2018
  3. David_spm

    Persistent bot/brute-force attack, iptables not working

    David_spm, Jun 12, 2018, in forum: Security
    Replies:
    16
    Views:
    205
    cPanelLauren
    Jun 20, 2018
  4. cPanelBenny

    cPanel & WHM Version 70 now in STABLE

    cPanelBenny, Jun 6, 2018, in forum: cPanel Announcements
    Replies:
    0
    Views:
    1,937
    cPanelBenny
    Jun 6, 2018
  5. Andy Maskell

    In Progress [CPANEL-20644] Backup failure - SQLITE_ERROR (no such table: backup_paths)

    Andy Maskell, May 25, 2018, in forum: Data Protection
    Replies:
    8
    Views:
    496
    cPanelMichael
    May 31, 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