Re: php 5 and mysql failure

On Mon, 05 May 2008 09:32:02 +0200, Caffeneide <mooomo@xxxxxxxxx> wrote:

On Apr 30, 5:38 pm, Jerry Stuckle <jstuck...@xxxxxxxxxxxxx> wrote:
Caffeneide 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 ...
> 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 before.
> My question is, is there any kind of limit somewhere in php5 or in
> mysql (version 5)?
> Thanks for help,

> YEHUDI GARRETT

It's possible you're running into a limit, but it's quite large.

The "supplied argument is not a valid MySQL result resource" indicates
your mysql_query() returned false, probably. You should ALWAYS check
the result of mysql_query(), and if it fails, log the error (you really
don't want to display those errors to your users, do you?). Or, on a
development system, display the error.


thanks. the query is correct because only sometimes I got this
error...

I'd say: the (building of the) query is incorrect because sometimes you get an error. How are you building it?

but the way on which I got this error seems to be completely
random...the number of ids I returned is quite variable but it's
around some (one-two-three) hundreds

In the small hundreds should be a piece of cake for any database, so that's probably not an issue. (Well, at least not on the MySQL side of things).

And last but not least: when echoing out a query to check it's results another way (phpMyAdmin, command line) always copy the _source_, and never just what's in a browser window.
--
Rik Wasmus
.

Relevant Pages

  • Re: php 5 and mysql failure
    ... MySQL result resource in ... ... If I echo the query, copy and paste in phpmyadmin, or if I perform the ... I had a big set of ids. ... Your error indicates mysql_queryreturned false. ...
    (comp.lang.php)
  • Re: php 5 and mysql failure
    ... servers to retrieve a set of ids and after I do a query to mysql of ... MySQL result resource in ... ... If I echo the query, copy and paste in phpmyadmin, or if I perform the ... I had a big set of ids. ...
    (comp.lang.php)
  • Re: user defined variables in a query
    ... in a simple query in informix sql. ... I would like to parametrize a query defining the parameters at the ... I know that you can do it with an spl or with a script but I ... I know that it is possible in mysql (http://dev.mysql.com/doc/refman/ ...
    (comp.databases.informix)
  • Re: php 5 and mysql failure
    ... servers to retrieve a set of ids and after I do a query to mysql of ... MySQL result resource in ... ... If I echo the query, copy and paste in phpmyadmin, or if I perform the ... I had a big set of ids. ...
    (comp.lang.php)
  • php 5 and mysql failure
    ... servers to retrieve a set of ids and after I do a query to mysql of ... This does not happen every time i run the script, ... If I echo the query, copy and paste in phpmyadmin, or if I perform the ... I had a big set of ids. ...
    (comp.lang.php)