ID: 11765
Updated by: mfischer
Reported By: [EMAIL PROTECTED]
Old Status: Open
Status: Bogus
Bug Type: MySQL related
Operating System: redhat-6.2
PHP Version: 4.0.6
New Comment:
Bogusified in favour of #12029.
Please only respond to #12029!
Bogus
Previous Comments:
------------------------------------------------------------------------
[2001-07-03 21:37:52] [EMAIL PROTECTED]
I upgraded to mysql-3.23.39 and recompiled php-4.0.6 but nothing changed.
------------------------------------------------------------------------
[2001-06-28 21:25:12] [EMAIL PROTECTED]
BTW : This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to
4.0.6
------------------------------------------------------------------------
[2001-06-28 21:21:26] [EMAIL PROTECTED]
Yes I use Use mysql_query() / mysql_select_db() instead of mysql_db_query().
Both mysql_errno() and mysql_error() return NOTHING.
The query was successful exectued by mysql.(I can find the query reselt in mysql
database)
But why php generated an error?
------------------------------------------------------------------------
[2001-06-28 13:16:05] [EMAIL PROTECTED]
Try adding this lines after each mysql function:
echo mysql_errno().": ".mysql_error()."<BR>";
This way you should get the reason why it doesn't work.
And FYI: Use mysql_query() / mysql_select_db()
instead of mysql_db_query().
--Jani
------------------------------------------------------------------------
[2001-06-27 23:37:47] [EMAIL PROTECTED]
The script(error.php) is :
<?
$db_acc_user = "root";
$db_acc_passwd = "password";
$db = "pacc";
$sql = "INSERT INTO type (name, quota, pc, cn, office) VALUES ('Howard', '10', '1',
'0', '1')";
mysql_connect("localhost",$db_pacc_user,$db_pacc_passwd);
mysql_db_query($db,$sql);
mysql_close();
?>
The result in browser is:
Warning: MySQL: Unable to save result set in /home/0/admin/error.php on line 7
But I just found that NO error in command line
root@localhost # php ./error.php
X-Powered-By: PHP/4.0.6
Content-type: text/html
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/?id=11765
Edit this bug report at http://bugs.php.net/?id=11765&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
