#12029 [Com]: "--with-apxs" can cause the error "MySQL: Unable to save result set in"

[sietzepost at streetwisedd dot nl]

ID: 12029
Comment by: sietzepost at streetwisedd dot nl
Reported By: root at byone dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.0.6 and 4.1.0RC3
New Comment:

I have the same problem. The strange thing is, I have PHP Version
4.3.3, compiled by gentoo portage. It worked fone for a couple of days,
and now, out of the blue, is generates these same errors. I have plenty
of dispace however, and have had plenty all the time. Does anyone have
another solution?


Previous Comments:
------------------------------------------------------------------------

[2003-04-01 03:24:30] nick at nickjoyce dot com

I had the same problem but found that mysql did not have enough disk
space to alter its files. Altering the quota fixed the problem.

------------------------------------------------------------------------

[2002-07-09 10:24:03] levi at tamisoft dot com

I found the same problem with:
mysql 3.23.51
php 4.1.2 later 4.2.1
roxen

I found a possible way to resolv it.
Use like this:

$query="INSERT INTO test.test SET str=\"a test\"";
@mysql_query($query);
if (mysql_error()) {echo "Some error occured!";exit();}

And this way you won't get the warning.
The only thing is that you cannot use the returned value itself
directly, you have to use mysql_error() to see if everything went ok.

PLZ let me know if it's not ok. It is working for me fine.

------------------------------------------------------------------------

[2002-01-23 10:48:20] [email]mrobinso@php.net[/email]

Apache is installed with mod_log_mysql and mod_auth-mysql,
and php is installed with the built-in clients.

[url]http://www.php.net/manual/en/faq.databases.php#AEN73271[/url]

Please reopen with a url to a phpinfo() call if problem
persists.

------------------------------------------------------------------------

[2002-01-23 09:29:40] [email]mrobinso@php.net[/email]

[email]rami@eduix.com[/email], can you post a page with phpinfo() on
it somewhere so I can have a look please.

I've never had any problems with mysql and pgsql
co-existing with php.

------------------------------------------------------------------------

[2002-01-23 04:48:46] rami at eduix dot com

I'm pretty sure these unable to save result set are due to pgsql and
mysql co-existence in self-compiled php. Our service worked well
without problems for 8 months with only mysql compiled in, but php
started complaining this immediately when we compiled the pgsql in
also. So this looks like a true bug allright.

------------------------------------------------------------------------

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
[url]http://bugs.php.net/12029[/url]

--
Edit this bug report at [url]http://bugs.php.net/?id=12029&edit=1[/url]

[sietzepost at streetwisedd dot nl]

ID: 12029
Comment by: sietzepost at streetwisedd dot nl
Reported By: root at byone dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Linux
PHP Version: 4.0.6 and 4.1.0RC3
New Comment:

Please read Bug #16906, wich is a follow up. The problem is not
PHP-related, but a MySQL table/key corruption. Running myisamchk should
resolve it.


Previous Comments:
------------------------------------------------------------------------

[2003-10-03 04:27:38] sietzepost at streetwisedd dot nl

I have the same problem. The strange thing is, I have PHP Version
4.3.3, compiled by gentoo portage. It worked fone for a couple of days,
and now, out of the blue, is generates these same errors. I have plenty
of dispace however, and have had plenty all the time. Does anyone have
another solution?

------------------------------------------------------------------------

[2003-04-01 03:24:30] nick at nickjoyce dot com

I had the same problem but found that mysql did not have enough disk
space to alter its files. Altering the quota fixed the problem.

------------------------------------------------------------------------

[2002-07-09 10:24:03] levi at tamisoft dot com

I found the same problem with:
mysql 3.23.51
php 4.1.2 later 4.2.1
roxen

I found a possible way to resolv it.
Use like this:

$query="INSERT INTO test.test SET str=\"a test\"";
@mysql_query($query);
if (mysql_error()) {echo "Some error occured!";exit();}

And this way you won't get the warning.
The only thing is that you cannot use the returned value itself
directly, you have to use mysql_error() to see if everything went ok.

PLZ let me know if it's not ok. It is working for me fine.

------------------------------------------------------------------------

[2002-01-23 10:48:20] [email]mrobinso@php.net[/email]

Apache is installed with mod_log_mysql and mod_auth-mysql,
and php is installed with the built-in clients.

[url]http://www.php.net/manual/en/faq.databases.php#AEN73271[/url]

Please reopen with a url to a phpinfo() call if problem
persists.

------------------------------------------------------------------------

[2002-01-23 09:29:40] [email]mrobinso@php.net[/email]

[email]rami@eduix.com[/email], can you post a page with phpinfo() on
it somewhere so I can have a look please.

I've never had any problems with mysql and pgsql
co-existing with php.

------------------------------------------------------------------------

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
[url]http://bugs.php.net/12029[/url]

--
Edit this bug report at [url]http://bugs.php.net/?id=12029&edit=1[/url]