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!

Need Urgent help WHM/Cpnel

Discussion in 'General Discussion' started by warrich, Jan 4, 2012.

  1. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Hello
    we have recently upgraded our mysql to 5.1 through WHM auto update.
    Our websites have stopped functioning at some parts, we believe it to be because of the following

    WHM shows mysql version 5.1
    Cpanel shows mysql version 4.1

    Why didnt the cpanel version performed the update, or what might have went wrong?


    someone help me how to do that
     
    #1 warrich, Jan 4, 2012
  2. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    281
    Likes Received:
    2
    Trophy Points:
    168
    I'd try

    /scripts/upcp --force

    then

    /scripts/mysqlup again , and see if that helps resolve the problem. Some logs would be helpful
     
    #2 hicom, Jan 5, 2012
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,789
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Do you notice any failures when attempting to update MySQL via the command line? You can attempt this via:

    Code:
    # /scripts/mysqlup
    If not, please consider opening a support ticket for this issue so we may check further:

    Submit A Ticket

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Jan 5, 2012
  4. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Problem is that i buy Server from That person who dont no how to Upgrade Cpanel MySql Version i posted here and find someone who can do this work for me and i will pay for that person who Upgrade my All Cpanels MySql

    Thanks in Advanced
     
    #4 warrich, Jan 5, 2012
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You are likely just cached for the cPanel account:

    Code:
    cd /home/username/.cpanel
mv mv datastore datastore.bak
    Then re-log into cPanel and it should show the correct MySQL version at that point.

    Now, the issue isn't likely that cPanel is reporting the wrong version, since it was likely just a cache. If the sites are experiencing an issue, it is more likely you have some error in your /etc/my.cnf configuration due to differences between MySQL 4.1 and MySQL 5.1 or that some tables didn't properly convert on some accounts.

    First, what is the error message you are receiving on some of the sites that aren't working? If you aren't seeing any error in a browser, what is happening in the browser to show it isn't properly working? Are you seeing any errors logged to /usr/local/apache/logs/error_log location?

    Next, are you seeing errors in /var/lib/mysql/hostname.err log location where hostname is the server's full hostname. If you aren't certain the name of the error log for MySQL, try grabbing a list of any files named .err in /var/lib/mysql to find it:

    Code:
    ls -lah /var/lib/mysql/*.err
    Tail the log on viewing the site to see any errors that might be outputting:

    Code:
    tail -fn0 /var/lib/mysql/hostname.err
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelTristan, Jan 5, 2012
  6. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    i got this Error see in Pictures

    /http://i43.tinypic.com/2cs8712.jpg
     
    #6 warrich, Jan 5, 2012
    Last edited: Jan 5, 2012
  7. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    This is the error for a site in a browser as well? Or, it is simply the PhpMyAdmin area that isn't working?

    Can you connect to MySQL in command line in root SSH?

    Code:
    mysql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelTristan, Jan 5, 2012
  8. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    i dont no anything about this thats why i come here and looking someone who can do this for me
     
    #8 warrich, Jan 5, 2012
  9. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    We can help with input on what you receive for the error, but if you are not able to run shell commands after logging in as root in SSH, then I would highly suggest hiring someone to assist with it:

    Dev & Sys Admin Services « Application Catalog
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 cPanelTristan, Jan 5, 2012
  10. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    i try to hiring someone last 1 week but i dont find anyone yet who can help me this
     
    #10 warrich, Jan 5, 2012
    Last edited: Jan 5, 2012
  11. warrich

    warrich Member

    Joined:
    Jan 4, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    i have my own 200 Web Directories and i useing phpld V2.2 on All Web Directories my Web directories working fine last 1 year but last one week i forcing these type Errors

    Fatal error: Call to a member function FetchRow() on a non-object in /home/glasgow/public_html/index.php on line 131
    Call to a member function GetAssoc() on a non-object in /home/d01/public_html/antrimdirectory.co.uk/admin/conf_payment.php on line 79
    Fatal error: Call to a member function GetAssoc() on a non-object in /home/d01/public_html/antrimdirectory.co.uk/admin/dir_links.php on line 86
    Fatal error: Call to a member function Fields() on a non-object in /home/madrid/public_html/include/functions.php on line 217
    Catchable fatal error: Object of class ADODB_mysql could not be converted to string in /home/glasgow/public_html/7nr.info/libs/adodb/adodb.inc.php on line 134
     
    #11 warrich, Jan 5, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - Need Urgent help
  1. segun_nira

    Urgent need to Recover mistakenly deleted files

    segun_nira, Jul 24, 2017, in forum: E-mail Discussion
    Replies:
    7
    Views:
    782
    24x7server
    Jul 25, 2017
  2. Amperzand

    Need to change Website Title within code

    Amperzand, May 17, 2018, in forum: General Discussion
    Replies:
    4
    Views:
    83
    Infopro
    May 17, 2018
  3. celiac101

    Is Symlink Race Condition Protection Needed on a Non-Shared Server?

    celiac101, May 17, 2018, in forum: Security
    Replies:
    4
    Views:
    121
    celiac101
    May 21, 2018
  4. Arkaic

    Check if server needs a restart via SSH?

    Arkaic, May 17, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    86
    cPanelLauren
    May 18, 2018
  5. RoboticPuppies

    Need advice about malware on server

    RoboticPuppies, Apr 30, 2018, in forum: Security
    Replies:
    8
    Views:
    168
    RoboticPuppies
    May 3, 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