• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Database error after update from 9 to 10

N

Nabilk

Guest
after updating plesk to 10, none of the site can connect to the MySQL database.
when i login to webadmin this error shows
"Your PHP MySQL library version 5.0.90 differs from your MySQL server version 5.1.49. This may cause unpredictable behavior"
and
"The additional features for working with linked tables have been deactivated. To find out why click here."
when i click here it shows me

$cfg['Servers'][$i]['pmadb'] ... OK
$cfg['Servers'][$i]['relation'] ... OK
General relation features: Enabled

$cfg['Servers'][$i]['table_info'] ... OK
Display Features: Enabled

$cfg['Servers'][$i]['table_coords'] ... OK
$cfg['Servers'][$i]['pdf_pages'] ... OK
Creation of PDFs: Enabled

$cfg['Servers'][$i]['column_info'] ... OK
Displaying Column Comments: Enabled
Browser transformation: Enabled

$cfg['Servers'][$i]['bookmarktable'] ... OK
Bookmarked SQL query: Enabled

$cfg['Servers'][$i]['history'] ... OK
SQL history: Enabled

$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled

$cfg['Servers'][$i]['tracking'] ... OK
Tracking: Enabled

the $cfg['Servers'][$i]['designer_coords'] ... not OK

how can i fix this?


System info :
General
CPU AuthenticAMD, AMD Athlon(tm) 64 Processor 3800+
Version Parallels Plesk Panel v10.0.1_build109101029.18 os_CentOS 5
OS Linux 2.6.18-194.11.1.el5
Memory 3.83 GB
 
This warning is caused by the fact that version of mysql and mysqlclient installed on the server does not match. You can check it with

rpm -qa | grep mysql

and compare versions of mysqlclient and mysql. It is recommended that you upgrade mysqlclient to version 5.1.49 or downgrade mysql to version 5.0.90.
 
Contact support team if you are not familiar with Linux rpm package system.
 
Back
Top