Need Urgent help WHM/Cpnel

[warrich]

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

 

[hicom]

I'd try

/scripts/upcp --force

then

/scripts/mysqlup again , and see if that helps resolve the problem. Some logs would be helpful

 

[cPanelMichael]

Hello

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

# /scripts/mysqlup

If not, please consider opening a support ticket for this issue so we may check further:

Submit A Ticket

Thank you.

 

[warrich]

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

 

[cPanelTristan]

You are likely just cached for the cPanel account:

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:

ls -lah /var/lib/mysql/*.err

Tail the log on viewing the site to see any errors that might be outputting:

tail -fn0 /var/lib/mysql/hostname.err

 

[warrich]

i got this Error see in Pictures

/http://i43.tinypic.com/2cs8712.jpg

 

[cPanelTristan]

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?

mysql

 

[warrich]

i dont no anything about this thats why i come here and looking someone who can do this for me

 

[cPanelTristan]

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

 

[warrich]

i try to hiring someone last 1 week but i dont find anyone yet who can help me this

 

[warrich]

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