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

go to bug id or search bugs for

Bug #19734 PHP crashes on the REAL data type in a MSSQL query
Submitted: 2002-10-03 06:34 UTC Modified: 2002-12-31 01:00 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:2 (100.0%)
Same OS:1 (50.0%)
From: andrew at fpef dot co dot za Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 4.2.3 OS: Windows XP
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: andrew at fpef dot co dot za
New email:
PHP Version: OS:

 

 [2002-10-03 06:34 UTC] andrew at fpef dot co dot za 
I have a table of several thousand rows in a MSSQL database called amfull. Tried to query this:

SELECT Distance FROM journeys WHERE VehicleBoxNo='44000601'

PHP bombed out on me. Got the XP error "PHP.EXE has generated errors"

So i played around a bit and discovered that if I did the following it prevented PHP from bombing out.

SELECT TOP 100 Distance FROM journeys WHERE VehicleBoxNo='44000601'

Unfortunately all this does is limit the number of rows to 100 which, in some cases, is very limiting.

Any suggestions?

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-03 07:50 UTC] kalowsky@php.net 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.
 [2002-10-03 13:08 UTC] andrew at fpef dot co dot za 
Had a further look into the problem and it seems to have to do with the 'REAL' data type. When i changed the data type from REAL to FLOAT in the Microsoft SQL server 7.0 database things worked again...

The problem comes with PHP.EXE crashing when it encounters this type of data. Don't know if the REAL type is dissallowed. Tried to provide as much information as i could give this time....
 [2002-12-08 10:33 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip
 [2002-12-31 01:00 UTC] php-bugs at lists dot php dot net 
No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 26 14:01:29 2024 UTC