I installed the SQLSRV drivers for PHP but it looks like they are the same version I already had. It did not make a difference. I am somewhat convinced it may be a problem related to the SQL in some way, as it seems only pages that perform database operations
seem to be the ones generating the 500 error...
I am not sure what you mean by the blog or CMS install guide/program, but I know my application pool settings are correct and I pretty much ruled out file permissions by using the SysInternals process monitor tool. There are no problems with permissions
on the SQL server either.
Again, I feel it's worth noting that if I revert PHP back to 5.3.6, everything works. At this point.. it just doesn't seem like it could be a configuration problem. It really looks like there must be a genuine problem with PHP 5.3.7+ and some combination
of the following:
SQLSRV VC09 driver for PHP 2.0.1
Drupal 7.6+
SQLSRV modules for Drupal 7.x-1.1
IIS 7.5
Windows Server 2008 R2 SP1 64-bit
Microsoft SQL 2008 SP2 64-bit
Is anyone out there using the same combination of software, I wonder?
I think I will try uninstalling everything and rebuilding the Drupal enviroment from scratch to see if I end up with the same problem.
Sorry, I was out for the past week or so. I haven't had a chance to work on this much more since then, but will probably be trying to rebuild everything later this week.
I am having a very similar problem. Exact same error message, though the version of MSVCR90.dll is slightly different. Same exception code. Some other background. Only the fault event log entry , nothing in the php error log. I previously had setup Drupal 6
with mysql and all was (and is working so long as I change extensions in php.ini). What I'm trying to do is setup Drupal 7 with Sql Server so I can fit all this in with the rest of our Windows environment. I was able to install drupal 7 to mysql on this box
so I really think the problem is in the sqlsrv PHP driver. I have duplicated this problem on Vista 64bit and Windows 7 64 bit. The install succeeds up to a point, not always exactly the same point based on running my sql server trace, and fails with a message
about unable to set named parameters. I have the latest php, the lastest sql server php driver from MS, the lastest version of drupal and the latest version of the drupal sqlsrv database module. I commented out the portion of the drupal install that was failing,
inserting registry files in the drupal database, and the install proceeds farther and then fails the same way. I am going to try the ODBC driver this morning and see if I get a different result.
Here is the full error. Version of MSVCR90 is listed. My computer is fully patched. I also looked at the blog you mentioned, but so far haven't found any clues. Thanks for the link to the sql server driver forum, I'll check in there as well. Log Name: Application
Source: Application Error Date: 10/4/2011 6:22:37 AM Event ID: 1000 Task Category: (100) Level: Error Keywords: Classic User: N/A Computer: ASUS-LT Description: Faulting application name: php-cgi.exe, version: 5.3.8.0, time stamp: 0x4e537f4b Faulting module
name: MSVCR90.dll, version: 9.0.30729.6161, time stamp: 0x4dace5b9 Exception code: 0xc0000005 Fault offset: 0x0003ae7a Faulting process id: 0x8bc Faulting application start time: 0x01cc8287613cdae8 Faulting application path: C:\Program Files (x86)\PHP\php-cgi.exe
Faulting module path: C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll Report Id: 29979694-ee7b-11e0-afe1-00235421655d
Kalio
12 Posts
Re: PHP 5.3.8 Problems
Sep 12, 2011 02:42 PM|LINK
I installed the SQLSRV drivers for PHP but it looks like they are the same version I already had. It did not make a difference. I am somewhat convinced it may be a problem related to the SQL in some way, as it seems only pages that perform database operations seem to be the ones generating the 500 error...
I am not sure what you mean by the blog or CMS install guide/program, but I know my application pool settings are correct and I pretty much ruled out file permissions by using the SysInternals process monitor tool. There are no problems with permissions on the SQL server either.
Again, I feel it's worth noting that if I revert PHP back to 5.3.6, everything works. At this point.. it just doesn't seem like it could be a configuration problem. It really looks like there must be a genuine problem with PHP 5.3.7+ and some combination of the following:
SQLSRV VC09 driver for PHP 2.0.1
Drupal 7.6+
SQLSRV modules for Drupal 7.x-1.1
IIS 7.5
Windows Server 2008 R2 SP1 64-bit
Microsoft SQL 2008 SP2 64-bit
Is anyone out there using the same combination of software, I wonder?
I think I will try uninstalling everything and rebuilding the Drupal enviroment from scratch to see if I end up with the same problem.
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Sep 12, 2011 03:10 PM|LINK
Ok, So the SQL PHP Driver is ok.
The pages for database may be the problem agreed and maybe plugins libaries ro others that are part of the directories.
What I suspect is the seperate permissions for Folders File NTFS Systems permissions in the Drupal Site are a problem.
You can check using Windows Explorer and the Security Tab.
If you use IIS Manager then with Content View instead of Features View.
Sorry for the generic reference CMS / Blog Drupal http://drupal.org/documentation/install guide.
The Web Platform suggested guide for Drupal http://learn.iis.net/page.aspx/505/install-drupal-on-iis/ on IIS Server.
Yes This "Again, I feel it's worth noting that if I revert PHP back to 5.3.6" is "everything works". is true.
If you decide to move on or revert:
You should leave the PHP version 5.3.8 install as it it is working.
Since you have the PHP Manager you can switch to the PHP 5.3.6 version as needed.
You could start with a fresh archive or install of the Drupal and see if that works.
Thank you sticking through this it is time consuming and fustrating.:D
Martin
Community Member Award 2011
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Sep 17, 2011 10:32 PM|LINK
Hi Kalio,
Have you reverted back
or made progress ?
Martin
Community Member Award 2011
Kalio
12 Posts
Re: PHP 5.3.8 Problems
Sep 26, 2011 02:51 PM|LINK
Hi Martin,
Sorry, I was out for the past week or so. I haven't had a chance to work on this much more since then, but will probably be trying to rebuild everything later this week.
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Sep 26, 2011 03:08 PM|LINK
Hi,
No problem @@.
Martin
Community Member Award 2011
xxrsdsdk209
2 Posts
Re: PHP 5.3.8 Problems
Oct 03, 2011 03:05 PM|LINK
I've got the same problem, only difference I see is that we are trying to connect to MS SQL 2005 but still getting
Fatal error: Undefined class constant 'SQLSRV_ATTR_DIRECT_QUERY' in E:\inetpub\wwwroot\cprint\dev\includes\database\sqlsrv\database.inc on line 59
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Oct 03, 2011 03:43 PM|LINK
Hello @ xxrsdsdk209,
Open a new thread your have problems with php code and the SQL PHP Driver.
Martin
Community Member Award 2011
panmanphil
3 Posts
Re: PHP 5.3.8 Problems
Oct 04, 2011 11:55 AM|LINK
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Oct 04, 2011 03:47 PM|LINK
Hi @ panmanphil,
Exact same error post the information.
What version of the Visual Studio run time installer for the "MSVCR90.dll" you have updates and security patches ?
Same Exception code post the information.
Nothing in php-error.log that is good.
You have this " fails with a message about unable to set named parameters" you should check
Brian Swans Blog for use of the PHP Sql Server driver for parameters.
Have you checked the SQL Server PHP driver Forum http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/3b38a360-047c-4b31-8531-6978d328f73d .
Martin
Community Member Award 2011
panmanphil
3 Posts
Re: PHP 5.3.8 Problems
Oct 05, 2011 02:13 AM|LINK