Debian Bug report logs -
#552089
php5-mysql: failed to call stored procedure via mysql_query function
Reported by: Alexey Popoudin <neo.obninsk@gmail.com>
Date: Fri, 23 Oct 2009 09:39:02 UTC
Severity: normal
Found in version php5/5.2.6.dfsg.1-1+lenny3
Fixed in version 5.3.3-7
Done: Ondřej Surý <ondrej@sury.org>
Bug is archived. No further changes may be made.
Toggle useless messages
Report forwarded
to debian-bugs-dist@lists.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#552089; Package php5-mysql.
(Fri, 23 Oct 2009 09:39:05 GMT) (full text, mbox, link).
Acknowledgement sent
to Alexey Popoudin <neo.obninsk@gmail.com>:
New Bug report received and forwarded. Copy sent to Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
(Fri, 23 Oct 2009 09:39:05 GMT) (full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
Package: php5-mysql
Version: 5.2.6.dfsg.1-1+lenny3
Severity: normal
PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cgi-fcgi) (built: Apr 26 2009 22:11:16)
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
Create php file with content below and follow steps in it.
<?php
/* 1. Create test_proc procedure, using mysql utility, or by any other way.
* 2. Run this php code.
* 3. It should print current date and time.
* 4. But it print this:
* PROCEDURE mysql.test_proc can't return a result set in the given context
* ----
* To create test_proc you can use this commands:
mysql -p -u root mysql
* Will ask for root password here.
DELIMITER //
CREATE PROCEDURE test_proc () SELECT NOW();//
* To remove procedure use:
DROP PROCEDURE test_proc//
*/
// This not work:
$db_link_identifier = mysql_pconnect('127.0.0.1', 'root', '15fp731')
or die('connect failed: '.mysql_error());
mysql_select_db('mysql')
or die('select database failed: '.mysql_error());
$query_result =
mysql_query('CALL test_proc;')
//mysql_query('SELECT NOW();')
or die('query failed: '.mysql_error());
$result = mysql_result($query_result, 0)
or die('no result');
echo($result);
// This work:
/*
$mysqli = mysqli_init()
or die('mysqli_init failed');
$mysqli->real_connect('127.0.0.1', 'root', '15fp731', 'mysql')
or die('connect failed: '.mysqli_connect_error());
$mysqli->real_query ("CALL test_proc();")
or die('query failed: '.$mysqli->error);
$mysqli_result = $mysqli->store_result()
or die('store result failed: '.$mysqli->error);
$row = $mysqli_result->fetch_row()
or die('no result');
echo($row[0]);
*/
?>
-- System Information:
Debian Release: 5.0.3
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages php5-mysql depends on:
ii libc6 2.7-18 GNU C Library: Shared libraries
ii libmysqlclient15of 5.0.51a-24+lenny2 MySQL database client library
ii php5-cgi [phpapi-2 5.2.6.dfsg.1-1+lenny3 server-side, HTML-embedded scripti
ii php5-common 5.2.6.dfsg.1-1+lenny3 Common files for packages built fr
php5-mysql recommends no packages.
php5-mysql suggests no packages.
-- no debconf information
Reply sent
to Ondřej Surý <ondrej@sury.org>:
You have taken responsibility.
(Wed, 27 Apr 2011 08:34:01 GMT) (full text, mbox, link).
Notification sent
to Alexey Popoudin <neo.obninsk@gmail.com>:
Bug acknowledged by developer.
(Wed, 27 Apr 2011 08:34:02 GMT) (full text, mbox, link).
Message #10 received at 552089-done@bugs.debian.org (full text, mbox, reply):
Version: 5.3.3-7
Hi,
since lenny is oldstable it will not get any updates now (except
security)[1], I am closing all segfault bugs filled against php5 in
lenny. (This is kind of saying that we don't care much about php5 in
lenny anymore).
If you believe the bug is still there, please provide evidence[2] and
a (preferably complete) test case with up-to-date squeeze (and/or
testing or unstable) version of php5 and reopen the bug.
O.
1. http://wiki.debian.org/PHP#Notes_on_PHP_and_security
2. Install php5-dbg and provide backtrace:
http://bugs.php.net/bugs-generating-backtrace.php
--
Ondřej Surý <ondrej@sury.org>
Bug archived.
Request was from Debbugs Internal Request <owner@bugs.debian.org>
to internal_control@bugs.debian.org.
(Thu, 26 May 2011 07:41:38 GMT) (full text, mbox, link).
Send a report that this bug log contains spam.
Debian bug tracking system administrator <owner@bugs.debian.org>.
Last modified:
Sun Jul 2 01:14:27 2023;
Machine Name:
bembo
Debian Bug tracking system
Debbugs is free software and licensed under the terms of the GNU
Public License version 2. The current version can be obtained
from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham,
1997,2003 nCipher Corporation Ltd,
1994-97 Ian Jackson,
2005-2017 Don Armstrong, and many other contributors.