FastCGI Error on IIS

Hi mattster42, last week I had a lot of the same error messages you mention. Took me days with install/reinstall but finally had it to work on a config that looks like yours (Win2003, IIS6, PHP5.3.3, MySQL 5.1.49).

The tips I can give you:
Read this page carefully and follow the steps for configuring FastCGI: http://learn.iis.net/page.aspx/248/configuring-the-fastcgi-extension-for-iis-60/
I had to create the MySQL database manually, the setup program wasn’t able to identify the possible collations. Just create an empty database and process the MODx setup if you run into this too
Read the PHP.INI file and see which settings you really need to change when using IIS
Check the FCGIEXT.INI file in your Windows\System32\inetsrv directory for the correct settings pointing to your php-cgi.exe
It might be that MODx cannot handle a database with a figure in the name. This is not confirmed but for me some problems seemed to be gone when I no longer used a database with a name holding a number in it
I also downloaded php_browscap.ini from http://browsers.garykeith.com/downloads.asp and added an entry in PHP.INI

Maybe one of the tips will help you and prevent you from loosing as much hairs on this as I did!
Kind regards,
Maurits, The Netherlands

Great, I’ll give this a shot.

By the way, what extensions are you using with PHP 5.3.3?

With Evo, I’ve used numbers (and at times only numbers) in database names many times with no problems.

I’m getting this error on Wampserver2.0 (mysql client version is 5.0.5-dev-081106). From apache error log ...

[Tue Sep 07 16:46:17 2010] [error] [client 127.0.0.1] PHP Warning: PDO::query() [<a href=’pdo.query’>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ’modx.modx_access_actions’ doesn’t exist in D:\\modx\\core\\xpdo\\xpdo.class.php on line 1796, referer: http://localhost:8081/setup/index.php?action=summary
[Tue Sep 07 16:46:17 2010] [error] [client 127.0.0.1] PHP Warning: PDO::query() [<a href=’pdo.query’>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ’modx.modx_access_actiondom’ doesn’t exist in D:\\modx\\core\\xpdo\\xpdo.class.php on line 1796, referer: http://localhost:8081/setup/index.php?action=summary
[Tue Sep 07 16:46:17 2010] [error] [client 127.0.0.1] PHP Warning: PDO::query() [<a href=’pdo.query’>pdo.query</a>]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ’modx.modx_access_context’ doesn’t exist in D:\\modx\\core\\xpdo\\xpdo.class.php on line 1796, referer: http://localhost:8081/setup/index.php?action=summary

.....and so on for a number of different tables.

Setup ran fine. But when I try to login to the manager, I just get a blank white screen.

The setup apparently did not run fine, as it cannot find the tables. Sure sounds like an issue with the pdo_mysql.default_socket value as described in the documentation for troubleshooting installation.

The tables are there in the database. It shows in the mysql shell. They even have data. I get the same error in xampplite 1.7.3 too.

Update: Those errors are logged during installation (but there are no errors are warnings in the browser during installation) and not while trying to access manager. While trying to access manager, no errors are displayed/logged.

Quote from: csmanoj at Sep 08, 2010, 04:55 AM

The tables are there in the database. It shows in the mysql shell. They even have data. I get the same error in xampplite 1.7.3 too.

Update: Those errors are logged during installation (but there are no errors are warnings in the browser during installation) and not while trying to access manager. While trying to access manager, no errors are displayed/logged.

Did you look in c:\Windows\Temp\php_error.log ? Or wherever you might have error_log configured in your php.ini?