I have xampp installed on XP SP3. PHP 5.2.8, MySQL 5.1.30, Yii 1.0.7
I installed Yii and went to the /demo/blog directory to try it out. I updated the db array in config/main.php to have the proper settings for the MySQL. I created a new db and put in the sql file in the data folder.
I know it’s mostly working because if I type the dbname in wrong I get the error:
CDbConnection failed to open the DB connection: SQLSTATE  Unknown database ‘yii_bloga’
And it writes to the application.log file.
The problem is, if all the db info is properly entered, it times out. I get the server error:
"The connection was reset
The connection to the server was reset while the page was loading."
Nothing it written to application.log, no php errors.
I have a number of instances of CI installed and they’re running fine so I don’t believe it’s a MySQL issue.
The hangman and hello demo’s work fine. The phonebook demo gives a flash error “Data Communications Error: HTTP Request Error”
I tried both 127.0.0.1 and localhost.
This is my first attempt with Yii. What can I do to track down the issue?
Replacing the libmysql.dll with the lastest from php-5.2-win32-VC6-x86-latest.zip seemed to do the trick
I am using XAMPP 1.7.0. Seems php goes from 5.2.8 -> 5.2.9 in 1.7.1, I don’t know if it has the newer libmysql.dll bundled with it or not.
I’d guess it was something with the PDO interfacing with mysql since PHPMyAdmin was working and all the other apps that were working didn’t use PDO. Strange that it was the libmysql.dll though and not the php_pdo_mysql.dll
I wonder what was different between the Yii requirements page passing it, and the application running that caused the issue.
I’m just happy it works, I don’t think I would have found that obscurity on my own.