IIS 7 & IIS 8
PHP 5.3.8 Problems
Last post Jan 30, 2012 11:13 AM by HCamper
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
SQLSRV modules for Drupal 7.x-1.1
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.
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
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
Sep 17, 2011 10:32 PM|LINK
Have you reverted back
or made progress ?
Sep 26, 2011 02:51 PM|LINK
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.
Sep 26, 2011 03:08 PM|LINK
No problem @@.
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
Oct 03, 2011 03:43 PM|LINK
Hello @ xxrsdsdk209,
Open a new thread your have problems with php code and the SQL PHP Driver.
Oct 04, 2011 11:55 AM|LINK
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
Oct 05, 2011 02:13 AM|LINK