Warning: mysql_fetch_array():

[Marc]

I cannot seem to find a solution to get those errors out of my chat.
I have been trying several days to make this work but nothing helps.
Please look into this and update my code if possible.
thanks.....
Marc

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/chat/inc/clearing.inc.php on line 5

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/chat/inc/clearing.inc.php on line 19
You have an error in your SQL syntax near 'and m.id = r.creator_id and ((m.user_rights = 0) or (r.private_partner_id' at line 2
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/chat/inc/clearing.inc.php on line 45

 	$query = "select id from ".$db_table_prefix."rooms where last_activity < ".time()." - $user_timeout";
	$rst = mysql_query($query);
	$wh = "";
	while($row = mysql_fetch_array($rst))
	{
		$wh .= $row["id"].", ";
	}
	if($wh)
	{
		$wh = substr($wh, 0, -2);
		$query = "delete from ".$db_table_prefix."room_members where user_id in ($wh)";
		mysql_query($query);
	}

$query = "select id from ".$db_table_prefix."chat_messages where message_time < ".time()." - $message_expiration_time";
$rst = mysql_query($query);
$wh = "";
while($row = mysql_fetch_array($rst))
{
	$wh .= $row["id"].", ";
}
if($wh)
{
	$wh = substr($wh, 0, -2);
	$query = "delete from ".$db_table_prefix."recipients where message_id in ($wh)";
	mysql_query($query);
	$query = "delete from ".$db_table_prefix."chat_messages where id in ($wh)";
	mysql_query($query);
}

if($auto_delete_admins_rooms)
{
	$query = "select id from ".$db_table_prefix."rooms where last_activity < ".time()." - $room_expiration_time";
}
else
{
	$query = "select r.id from ".$db_table_prefix."rooms r, ".$db_table_prefix."members m 
				where r.last_activity < ".time()." - $room_expiration_time and
						m.id = r.creator_id and ((m.user_rights = ".$user_permissions["users"].") or (r.private_partner_id > 0))";
}
$rst = mysql_query($query);
echo mysql_error();
$wh = "";
while($row = mysql_fetch_array($rst))
{
	$wh .= $row["id"].", ";
}
if($wh)
{
	$wh = substr($wh, 0, -2);  

[ir4z0r]

your query doesn't return sth, I guess your table is empty?
then mysql_query() returns false instead of a resource

solution:

$rst = mysql_query....
if ($rst)
{
while...
}

your sql-error:
you probably should use more brackets around
(r.last_activity < ( ".time()." - $room_expiration_time))
for example

[xblue]

Marc, once again: these errors mean that your queries failed, and you should use mysql_error() and post the error if necessary.

mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);

[Marc]

By replacing the line in ¨

mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);

it comes up with :

Error: You have an error in your SQL syntax near '' at line 1 in query: select id from dt_rooms where last_activity < 1048348751 -

This is line 1

	$query = "select id from ".$db_table_prefix."rooms where last_activity < ".time()." - $user_timeout";

Thanks

[ir4z0r]

why calculating via mysql? use php-calc instead:

$query = "select id from ".$db_table_prefix."rooms where last_activity < ". (time() - $user_timeout);

[Marc]

Great thanks !
I got some errors out by using the info you gave me.
Still got one error with this one at line 45.
You have an error in your SQL syntax near 'and m.id = r.creator_id and ((m.user_rights = 0) or (r.private_partner_id' at line 2
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/chat/inc/clearing.inc.php on line 45

can you rewrite it please?
I'm a complete newbie on this and this was the only way i could come up with doing this

	        $query = "select r.id from ".$db_table_prefix."rooms r, ".$db_table_prefix."members m 
                    where r.last_activity < ".time()." - $room_expiration_time and 
                            m.id = r.creator_id and ((m.user_rights = ".$user_permissions["users"].") or (r.private_partner_id > 0))";  

[ir4z0r]

okay, second error seems to be produced by the first, so let's
try to fix it
I'm not that experienced with adv. queries, but give this a try:

$query = "select r.id from ".$db_table_prefix."rooms r, ".$db_table_prefix."members m 
                    where (r.last_activity < ". (time() -  $room_expiration_time)  . ") and 
                            (m.id = r.creator_id) and ((m.user_rights = ".$user_permissions['users'].") or (r.private_partner_id > 0))";

[Marc]

Woooohoo, ;-)) Fantastic !!

This one is working !!!
Thanks for all the help you gave me !

[Marc]

Just when i thought it was finished, a new error occured on another page
:-(
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site67/fst/var/www/html/chat/buddy_list.php on line 75

 <?php
	$count = "0";  

	while ($contact_list = mysql_fetch_row ($query)){

//changed
		$query = "select room_id from ".$db_table_prefix."room_members where user_id = ".$contact_list[" 1 "];
		$rslt = mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);
		$rec_room = mysql_fetch_array($rst);
?> 

[ir4z0r]

you are using
mysql_fetch_row ($query)
in the second line, what is supposed to be in $query? You can't
get data without making a query 😕

you are using $query twice for different contents

$contact_list['1']; is probably better than $contact_list[" 1 "];

[Marc]

Sorry, the wrong code was posted ....
Tried the ['1'] wihout any luck

<?php
    $count = "0";  

    while ($contact_list = mysql_fetch_row ($rst)){

//changed
        $query = "select room_id from ".$db_table_prefix."room_members where user_id = ".$contact_list['1'];
        $rslt = mysql_query($query) or die("Error: ".mysql_error()." in query: ".$query);
        $rec_room = mysql_fetch_array($rst);
?>

[ir4z0r]

same problem, either you posted an unfortunate code snippet or
you missed sth completely 😕

<?php
    $count = "0";  

    while ($contact_list = mysql_fetch_row ($rst)){

can not work cause $rst is not specified in the first loop, that's
why mysql_fetch_array() reports an error

(btw u r using $rst instead of $rslt in your inner loop)