blog demo timeout

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[42000] [1049] 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 and localhost.

This is my first attempt with Yii. What can I do to track down the issue?

Hi. Have you tried ‘requirements’? If yes, what does this say?


Name Result Required By Memo

PHP version Passed Yii Framework PHP 5.1.0 or higher is required.

$_SERVER variable Passed Yii Framework

Reflection extension Passed Yii Framework

PCRE extension Passed Yii Framework

SPL extension Passed Yii Framework

DOM extension Passed CWsdlGenerator

PDO extension Passed All DB-related classes

PDO SQLite extension Failed All DB-related classes This is required if you are using SQLite database.

PDO MySQL extension Passed All DB-related classes This is required if you are using MySQL database.

PDO PostgreSQL extension Failed All DB-related classes This is required if you are using PostgreSQL database.

Memcache extension Failed CMemCache

APC extension Failed CApcCache

Mcrypt extension Passed CSecurityManager This is required by encrypt and decrypt methods.

SOAP extension Passed CWebService, CWebServiceAction

GD extension Passed CCaptchaAction

Is APC required for the blog?

Actually, when I try to load the blog demo, Apache will crash and restart once or twice, followed by the "The connection was reset" error in FF.

In the apache error log it says:

[Wed Aug 05 02:04:16 2009] [notice] Parent: child process exited with status 3221225477 – Restarting.

each time it restarts. The libmysql.dll is in my system32 dir.

What about Yii is making it crash? My other web apps and frameworks are doing fine. How can I disable what’s causing it?

I’ve tried disabling Zend Optimizer and enabling APC but still no…


Maybe problem with pdo extension, create simple script to test pdo extension.

Are you use last xampp ( version 1.7.1) ?

Look at

Both lines look good if you want to use MySQL.

Nope, disabling APC just slows yii down, I think.

Well, it might be an error related to the db, though I do not know the reason because I have never experienced such a situation…


Replacing the libmysql.dll with the lastest from 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.