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 = ''
-- 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['fi
,@LastName = '{$this->request->data['la
,@PlaceOfWork = '{$this->request->data['co
,@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:
Post a Comment