Monday, December 9, 2013

CakePHP v2.4.3 / PHP 5.5.3 Crashing on IIS 8.5 Windows 2008 R2

Having an issue where I'm using PHP 5.5.3 Crashing on IIS 8.5 Windows 2008 R2 using the php_pdo_sqlsrv_55_nts.dll and cakePHP v2.4.3

This problem does not occur outside of CakePHP

Driving me crazy and can't figure out whats going on.  There is no specific error generated fro this.  Someone mentioned to place int he SP SET NOCOUNT ON  but it already has that setting.

{
    "code": 500,
    "url": "\/test\/process",
    "name": "SQLSTATE[IMSSP]: The active result for the query contains no fields.",
    "error": {
        "errorInfo": [
            "IMSSP",
            -15,
            "The active result for the query contains no fields."
        ]
    }
}

Below is an example of what causes the 500

    DECLARE @RC int 
    DECLARE @CustomerID varchar(15) 
    DECLARE @FirstName varchar(50) 
    DECLARE @LastName varchar(50) 
    DECLARE @PlaceOfWork varchar(100) 
    DECLARE @Active bit 
    DECLARE @NoActivityStatement bit 
    DECLARE @CustomerClassID varchar(15) 
    DECLARE @CustomerType tinyint 
    DECLARE @PenaltyType varchar(15) 
    DECLARE @CollectionExempt bit 
    DECLARE @ZoneID varchar(15) 
    DECLARE @Source tinyint 

    EXECUTE @RC = [dbo].[test_spCreate] 
       @CustomerID = '{$nextCustomerID}'
      ,@FirstName = '{$this->request->data['first_name']}'
      ,@LastName = '{$this->request->data['last_name']}'
      ,@PlaceOfWork = '{$this->request->data['company']}'
      ,@Active = '1'
      ,@NoActivityStatement = '0'
      ,@CustomerClassID = 'COMMERCIAL'
      ,@CustomerType = '2'
      ,@PenaltyType = ''
      ,@CollectionExempt = '0'
      ,@ZoneID = ''
      ,@Source = ''

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

No comments: