php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #32400 MSSQL Error ignoring
Submitted: 2005-03-21 21:01 UTC Modified: 2005-07-28 02:28 UTC
From: davidc at densi dot com Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.3.10 OS: Debian Testing
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: davidc at densi dot com
New email:
PHP Version: OS:

 

 [2005-03-21 21:01 UTC] davidc at densi dot com 
Description:
------------
This is a simple bug that I can fix in the mssql query but I believe that this should be ignored automaticly by PHP. Basicly, I run this specific sql query and it outputs an Unknown Error. Then I go to query analyzer and the query works. But there's null values warnings. I can't use any @ to ignore the error, it doesn't *ignore* it. I can run any other queries in my php scripts and they work fine.

Reproduce code:
---------------
http://undernetlinuxnewbie.org/pastebin/view.php?id=126

which works but I get this:

Warning: Null value is eliminated by an aggregate or other SET operation.

Expected result:
----------------
Sales    NAME    LineDate       Incoming   Outgoing   Area
12       David   Mar 21, 2005   16         13         QC
04       Rob     Mar 21, 2004   12         28         ON

Actual result:
--------------
PHP:
Query error!

Error message: DB Error: unknown error


MSSQL:
Query Outputs the good result.
but this in the warnings:

Warning: Null value is eliminated by an aggregate or other SET operation.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-03-21 22:37 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
 [2005-03-22 17:48 UTC] davidc at densi dot com 
We are not compiling anything from the sources, we are using apt-get and debian packages, also, it's the newest packages(Apache/2.0.53 (Debian GNU/Linux) PHP/4.3.10-9).

I might just make a patch and submit it if there's nothing about that yet. Let me know. Thanks
 [2005-03-22 18:30 UTC] sniper@php.net 
We do not support any patched sources (debian has several unsupported changes in their PHP) or any distributions binaries.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 19 21:01:30 2024 UTC