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.

OSCommerce and Cpanel Updates

Discussion in 'General Discussion' started by maverick, Aug 12, 2003.

  1. maverick

    maverick Well-Known Member

    Joined:
    Jan 6, 2003
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    We've had a customer observe that the whoisonline database of OScommerce gets broken each time Cpanel gets updated. From what he's been able to understand from the OScommerce forums, all servers with CPanel, MySQL4 and php4.3.x are affected by this issue. Somebody there had posted a kludge that patches the problem (http://www.forums.oscommerce.com/viewtopic.php?t=44756),
    however, the solution is not exactly ideal. The problem supposedly originates from CPanel not closing open databases before running the update??

    Are other people experiencing this problem or is there something I can do to fix this? (apart from rolling back to MySql3/php4.2.x which I'm no not wanting to do).

    Any input appreciated. Thanks.

    Mav.

    cPanel.net Support Ticket Number:
     
  2. cbwass

    cbwass Well-Known Member

    Joined:
    Mar 29, 2002
    Messages:
    148
    Likes Received:
    0
    Trophy Points:
    16
    Below is a sugestion from Cpanel support, I don't know if this works yet as the error appears every 5 to 10 days, time will tell. (recompiled yesterday).
    ----------------------------
    Quote Cpanel:
    Try recompiling apache/php with easyapache using the system mysql
    module rather than the regular mysql module. (it's all in option 6 of
    easyapache)

    It may not work, but it sure is worth a try.
    -----------------------------

    cPanel.net Support Ticket Number:
     
  3. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    That's probably the best solution--the one cPanel offered you. Check a php info page to ensure that the MySQL client is 4.x and you may want to run repair on the database(s) just so you're starting with a fresh slate.

    cPanel.net Support Ticket Number:
     
  4. maverick

    maverick Well-Known Member

    Joined:
    Jan 6, 2003
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for the input.. I'll give it a go and post back to let everyone know how it goes.

    Mav.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page