Hi, I have recently moved from one RedHat Server to a different one and I have come across a problem which I can't resolve. Given that there is evidence that other users have experienced a similar problem I thought I'd create a post here as somewhere to store the solution if one is found.
I have taken an application built in the Zend Framework from the old server to the new one. It was working fine on the old server so this is a configuration problem rather than a problem with the code or SQL. Its definatley not a problem with the FrameWork but it may be useful to document a solution for others who are looking to start using the Framework. Basically when interacting with the database on the new server I receive the following exception exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2036 On researching this error I found this URL which seems to diagnose the problem and illustrates that other users have exoerience the same problem: http://paradigma.pt/ja/slog/index.php/2006/10/pdo_mysql_ubuntu_error_fixed.html It looks as though pdo_mysql on my server is compiled for mysql client 4.1 and i had mysql client 5.0.27. Unfortunatley I am unable to follow the steps listed to solve the problem because it is aimed at user of Ubuntu rather than RedHat. Here are the steps I have tried so far 1. Use pear to install the extension # pecl install pdo # pecl install pdo_mysql This did not solve the problem which isn't a suprise because www.php.net lists that pdo_mysql only supports MySQL 3.x/4.x. As such I uninstalled these extensions using pear 2. I then downloaded the package from pecl.php.net, used phpize and then configured and installed the extensions # wget http://pecl.php.net/get/PDO-1.0.3.tgz # tar zxvf PDO-1.0.3.tgz # cd PDO-1.0.3 # phpize # ./configure # make # make install I did the same for the PDO_MYSQL-1.0.2 package. This still did not solve the problem. I have added the extensions to the php.ini file and restarted apache [EMAIL PROTECTED] sam]# cat /etc/php.ini | grep pdo extension=pdo.so extension=pdo_mysql.so Given that PDO is listed in phpinfo() I shouldn't have to recompile PHP once installing the extensions should I? phpinfo() lists the following for PDO PDO PDO support: enabled PDO drivers: mysql, odbc, pgsql, sqlite pdo_mysql PDO Driver for MySQL, client library version 5.0.27 Has anyone had a similar problem? Can anyone suggest steps to take to get my ZendFramework application working again? Cheers, Sam -- View this message in context: http://www.nabble.com/PDOException-with-message-SQLSTATE-HY000-%3A-General-error%3A-2036-tf3239563s16154.html#a9004609 Sent from the Zend Framework mailing list archive at Nabble.com.
