Bug #7301 Updated: Error in msql_result: reproducible

ID: 7301 Updated by: zeev Reported By: afan.remove_this_spamguard@jeo.net Old Status: Duplicate Status: Closed Bug Type: mSQL related Operating System: RedHat Linux 6.1 PHP Version: 4.0.3pl1 New Comment: Fixed in the CVS Previous Comments: ------------------------------------------------------------------------ [2000-12-12 18:28:49] sniper@php.net This is duplicate of #6827. --Jani ------------------------------------------------------------------------ [2000-10-20 13:22:25] afan.remove_this_spamguard@jeo.net I pared down the code and the data to the minium while still getting the crash. Below is the code and the msqldump. I think it is the NULL that is causing the problem and not a blank entry. Code: --------------------------- <pre> <? $database = "foobar"; $sql ="SELECT * FROM events WHERE ev_day='18-Oct-2000' ORDER BY typ, srttm"; $result = msql($database,$sql); $num_rows = msql_numrows($result); $i = 0; while ($i < $num_rows) { $aff = msql_result($result,$i,"aff"); $sql_info = "SELECT show_provider_info,provider_serial_id FROM Providers where user_name = '$aff' LIMIT 1"; echo "DEBUG: $sql_info: $num_rows<br>"; $result_info = msql($database,$sql_info); echo "DEBUG_result: $result_info<br>"; $show_info = msql_result($result_info,0,"show_provider_info") ; $this_provider = msql_result($result_info,0,"provider_serial_id") ; echo msql_error(); echo "DEBUG: '$show_info', '$this_provider', '$aff'<br>\n"; if ($i == 1) { //In this demo there are 3 entries exit; //If it gets to the third($i=2) the } //program crashes w/out fail. if ($show_info == 1) { //CRASHES HERE echo "HI"; } $i++; } ?> </pre> ------ ------------------------------------------- Data in database: ---- # # mSQL Dump # Host: localhost Database: foobar #-------------------------------------------------------- # # Table structure for table 'events' # DROP TABLE events \g CREATE TABLE events ( id CHAR(31), ev_day DATE, srttm CHAR(8), endtm CHAR(8), group_id INT, typ CHAR(25), aff CHAR(30), title CHAR(30), descr CHAR(200) ) \g # # Dumping data for table 'events' # INSERT INTO events VALUES ('940868200264760','18-Oct-2000','12:00 pm','1:00 pm',2,'Lunch','Slovak','Learn At Lunch','learn blah blah')\g INSERT INTO events VALUES ('96463942510743346','18-Oct-2000','','',2,'Other Event','Celebration Belle','Big Band Cruises','blah blah')\g INSERT INTO events VALUES ('965228863119070','18-Oct-2000','','',2,'Other Event','Celebration Belle','Daylong Cruise','blah blah')\g # # Table structure for table 'Providers' # DROP TABLE Providers \g CREATE TABLE Providers ( provider_serial_id INT, user_name CHAR(30), provider_password CHAR(14), provider_group_id INT, provider_email CHAR(35), permissions INT, provider_address1 CHAR(30), provider_address2 CHAR(30), provider_city CHAR(20), provider_state CHAR(2), provider_zip CHAR(10), provider_phone CHAR(12), provider_url CHAR(33), provider_info CHAR(200), show_provider_info INT ) \g CREATE UNIQUE INDEX idx_provider_id ON Providers ( provider_serial_id, user_name ) \g CREATE SEQUENCE ON Providers STEP 1 VALUE 208 \g # # Dumping data for table 'Providers' # INSERT INTO Providers VALUES (53,'Slovak','erased3',2,'',NULL,'','','','','','','','',0)\g INSERT INTO Providers VALUES (172,'Celebration Belle','erased4',2,'xxx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)\g ------- ------------------------------------------------------------------------ [2000-10-17 23:25:45] afan.remove_this_spamguard@jeo.net A piece of code worked perfectly with PHP3/Apache1.3.9/msql-2..11 I tried it with PHP4/Apache_1.3.14/msql-2.0.11 and got sporadic crashes - I found out that: IF a) You have an msql database with a value in a row blank, e.g. ('asdf',1,'',,...) AND b) you have a SELECT * statement $sql="SELECT * from table where ... ORDER BY ..." $result = msql($DB,$sql) while ($row = msql_fetch_row($result) ) { .... } AND c) the FIRST row returned contains a value that is blank THEN when php hits the msql_fetch_row($result) line, PHP returns nothing and gives an error in the log file like: child pid 9346 exit signal Segmentation Fault HOWEVER, if the first row returned does not have a blank element in the row, then it seems to work ok. ---- I tried variations with msql_result(), msql_connect, and msql_pconnect as well but all gave me the same problem. ----- Relevent facts?: In running "make" I get gcc .... -I/usr/local/Hughes/include .... -c php_msql.c -fPIC -DPIC -o php_msql.lo php_msql.c:189 warning: int format, long int (arg 4) php_msql.c:191 warning: int format, long int (arg 4) php_msql.c:196 warning: int format, long int (arg 4) php_msql.c:198 warning: int format, long int (arg 4) I used the stock php.ini.dist file Thanks in advance - PHP is great! Afan Ottenheimer ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=7301&edit=1