IIS 7, php and fastcgi

It all started with this:
HTTP Error 500.0 - Internal Server Error
C:\Program Files (x86)\PHP\v5.3\php-cgi.exe - The FastCGI process exited unexpectedly

And Faulting application name: php-cgi.exe, version:, time stamp: 0x4e537f4b
Faulting module name: MSVCR90.dll, version: 9.0.30729.4940, time stamp: 0x4ca2ef57
Exception code: 0xc0000005
Fault offset: 0x0003aefe
Faulting process id: 0xcbc
Faulting application start time: 0x01ccba9ed76d7828
Faulting application path: C:\Program Files (x86)\PHP\v5.3\php-cgi.exe
Faulting module path: C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
Report Id: 158dd077-2692-11e1-9344-000c29f76d8e

1. Opened up permissions for the iusr account on web.config as recommended by MS

2. Checked Event Viewer and saw this:

3. Googled and found this:

4. Which led me to this

5. Which then got me thinking about how the hell you apply a patch:

6. And I downloaded this:

7. Except it didn't work with the --binary switch, I got "**** cannot read binary data from tty on this platform'

8. So I opened the patch file and added this code to database.inc, replacing

'/^RELEASE SAVEPOINT (.*)$/' => 'SELECT 1 /* $0 */',

9. Which led to an error in menu.inc
SELECT TOP(1) * FROM {menu_router} WHERE path IN () ORDER BY fit DESC; Array ( ) in menu_get_item() (line 445 of

10. So I went through and did it all again after deleting the db tables (the install configuration will error out if it finds the tables have already been created.)

11. And I got this message:
SQLSTATE[23000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'registry_pkey'. Cannot insert duplicate key in object 'dbo.registry'.

12. Googled it, found people with the same problem but no fix.

13. Threw my hands up and said fuck it.

14. Looking for new Open Source CMS platform that works and allows me to skip steps during the install process :D.

Moral of the story: Jesus Christ Drupal is a pain in the ass and I'm ditching it for another CMS platform. Way too buggy and the install file is crap and won't let you skip steps (yes the db is already created.)

Windows 2008 server R2 SP1
SQL Server 2008
Commerce Guys Drupal

(Also if you plan on coming here going "HERP STOP USING IIS/MSSQL" I don't want to hear it. I'm not building another damned server because the Commerce Guys Drupal install doesn't work with a pretty typical config, thanks. I'm also starting to think Drupal is just buggy. I spent most of the day dealing with the regular Drupal package yesterday and couldn't get it to work then either. But I'll take any help. For now I'm scrapping the whole thing. At least I learned how to set up the php handlers in IIS :))

Edit: After my ranting I thought I'd give the Acquia install a go. Perfect, took 5 minutes.


Enoch Zembecowicz said...

I'm not SQL expert, but as I understand it a primary key is a primary key be it on Postgres, MSSQL, or Oracle.

Criminally Vulgar said...
This comment has been removed by the author.