php 5 and mysql failure

#1

I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the kind
SELECT * FROM table WHERE id IN ('set of ids');
Although I'm sure the connection to the database is ok, I sometimes
get an error of this kind:
*Warning*: mysql_fetch_object(): supplied argument is not a valid
MySQL result resource in ...
This does not happen every time i run the script, only sometimes.
If I echo the query, copy and paste in phpmyadmin, or if I perform the
same query in a script that does only the query without the rest it
works!
After troubleshooting this issue I noticed that it usually failed when
I had a big set of ids (positive response from more than one server).
This means that the script used a bigger amount of memory and probably
more resources, but I did not get an "out of memory error", I got the
one described bfore.
My question is, is there any kind of limit somewhere in php5 or in
mysql?
Thanks for help

Laura

#2

On Mon, 05 May 2008 09:50:10 +0200, Caffeneide <mooomo (AT) gmail (DOT) com> wrote:

Quote:

I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the kind
SELECT * FROM table WHERE id IN ('set of ids');
Although I'm sure the connection to the database is ok, I sometimes
get an error of this kind:
*Warning*: mysql_fetch_object(): supplied argument is not a valid
MySQL result resource in ...

$result = mysql_query(....);
if(!$result) echo mysql_error(); will tell you what is wrong.

Quote:

This does not happen every time i run the script, only sometimes.
If I echo the query, copy and paste in phpmyadmin, or if I perform the
same query in a script that does only the query without the rest it
works!

Usually that means something that you can't see in HTML, look at the
_source_ of the created page for the correct query.

Quote:

After troubleshooting this issue I noticed that it usually failed when
I had a big set of ids (positive response from more than one server).
This means that the script used a bigger amount of memory and probably
more resources, but I did not get an "out of memory error", I got the
one described bfore.
My question is, is there any kind of limit somewhere in php5 or in
mysql?

Yes, lots & lots of different limits, consult their manuals.
--
Rik Wasmus

#3

On Mon, 05 May 2008 09:56:39 +0200, Rik Wasmus
<luiheidsgoeroe (AT) hotmail (DOT) com> wrote:

Quote:

On Mon, 05 May 2008 09:50:10 +0200, Caffeneide <mooomo (AT) gmail (DOT) com> wrote:

I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the kind
SELECT * FROM table WHERE id IN ('set of ids');
Although I'm sure the connection to the database is ok, I sometimes
get an error of this kind:
*Warning*: mysql_fetch_object(): supplied argument is not a valid
MySQL result resource in ...

$result = mysql_query(....);
if(!$result) echo mysql_error(); will tell you what is wrong.

From comp.lang.php:

Quote:

This is the error logged: 2006: MySQL
server has gone away

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

Most likely, set max_allowed_packet higher.
--
Rik Wasmus

#4

On 6 Mag, 09:00, "Rik Wasmus" <luiheidsgoe... (AT) hotmail (DOT) com> wrote:

Quote:

On Mon, 05 May 2008 09:56:39 +0200, Rik Wasmus

luiheidsgoe... (AT) hotmail (DOT) com> wrote:
On Mon, 05 May 2008 09:50:10 +0200, Caffeneide <moo... (AT) gmail (DOT) com> wrote:

I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the kind
SELECT * FROM table WHERE id IN ('set of ids');
Although I'm sure the connection to the database is ok, I sometimes
get an error of this kind:
*Warning*: mysql_fetch_object(): supplied argument is not a valid
MySQL result resource in ...

$result = mysql_query(....);
if(!$result) echo mysql_error(); will tell you what is wrong.

From comp.lang.php:

This is the error logged: 2006: MySQL
server has gone away

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

Most likely, set max_allowed_packet higher.
--
Rik Wasmus

It seems I resolved the problem setting "wait_timeout" higher...it's
ok?? thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

php 5 and mysql failure

comp.databases.mysql comp.databases.mysql

php 5 and mysql failure - 05-05-2008 , 02:50 AM

Re: php 5 and mysql failure - 05-05-2008 , 02:56 AM

Re: php 5 and mysql failure - 05-06-2008 , 02:00 AM

Re: php 5 and mysql failure - 05-06-2008 , 02:48 AM