Php/mysql error

resolva · 07-02-2005, 12:59 PM

Hello everyone; just posting because i have an error on my website that i cant get rid of:

What does this error mean and how can i get rid of it?

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xcs/public_html/functions/challengeforfeit.php on line 178

Porte · 07-02-2005, 01:04 PM

Please open this page and get the code around that line, or we could not know where the problem reside. Also make sure that all tables correctly exist in database.

resolva · 07-02-2005, 01:33 PM

ok here is where in the code i think it is...

//NEXT 2 FUNCTIONS DELETES AND AWARDS WINS FOR UNRESPONDED OR UNFINALIZED CHALLENGES

LINE 178 - function check_unrespondedchallenges(){

$challengeladders=mysql_query("SELECT id,respondhours,finalizehours FROM ladders WHERE challenge='1'");

while(list($id,$respondhours,$finalizehours)=mysql _fetch_row($challengeladders)){

$laterespond=date("Y-m-d H:i:s",time()-60*60*$respondhours);

$latefinalize=date("Y-m-d H:i:s",time()-60*60*$finalizehours);

$challengeinfo=mysql_query("SELECT challid,challenger,challenged,ladderid,challengerr ank,challengedrank,respondedby,finalizedby FROM challenges WHERE

ladderid='$id' AND respondedby='0' AND finalizedby='0' AND challengedtime < '$laterespond' OR

ladderid='$id' AND respondedby > '0' AND finalizedby='0' AND respondedtime < '$latefinalize'");

while(list($challid,$challenger,$challenged,$ladde rid,$challengerrank,$challengedrank,$respondedby,$ finalizedby)=mysql_fetch_row($challengeinfo)){

PoorDoggie · 07-02-2005, 02:10 PM

do you have anything in your table?

resolva · 07-02-2005, 02:26 PM

I have many db tables. but i dont know what the table should be called?

What should it be called in the table/db?

xlusive · 07-02-2005, 02:42 PM

upload your file
and rename it to

file1.phps

and then post the url

deadserious · 07-02-2005, 03:03 PM

You might also want to try using mysql_error() to see if it spits out any more detailed errors.

Example:

PHP Code:

  $challengeladders = mysql_query("SELECT id,respondhours,finalizehours FROM ladders WHERE challenge='1'") or die (mysql_error ());

PoorDoggie · 07-02-2005, 03:50 PM

open, in php_my_admin, the table "ladders" in browse mode. Is there any data in there? That could be your problem. It was the same error for me, when I didn't have anything in my table!

resolva · 07-02-2005, 05:13 PM

Still no luck, the mysql_error didnt give me anymore information

here is the link with the actually script on anyway for you to have a look at

Code

Thank You

val539 · 07-03-2005, 01:11 AM

i add 8 lines
u shoud readd the lines u removed
Regards

PoorDoggie · 07-03-2005, 01:40 AM

Quote:

Originally Posted by resolva

Still no luck, the mysql_error didnt give me anymore information

here is the link with the actually script on anyway for you to have a look at

Code

Thank You

did you check your table? I am not being funny, I had that exact same error when I was trying to read from an empty table. If there was something wrong with your syntax then the mysql error would be saying that "there is somethign wrong with your syntax". If it was a mistype then you would have a php error, and not a mysql error.

val539 · 07-03-2005, 01:47 AM

sorry i change the post because for any reason
the code is changed

PHP Code:

      $numbers_challengeladders=array(); //line Valerie

    $numbers_challengeladders=@mysql_fetch_row($challengeladders); //line Valerie

    if (count($numbers_challengeladders)>0) { //line Valerie

challengeladders BECOMES challe ngeladders, in 2nd line, (bug vbulletin )
see the attachment file it's better
Regards

resolva · 07-03-2005, 07:31 AM

Thanx for all your help

Got rid of the error, thanx again

PoorDoggie · 07-03-2005, 07:41 AM

good!

what was wrong?

07-02-2005, 12:59 PM	#1 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 115 31.00 NP$ (Donate)	Php/mysql error Hello everyone; just posting because i have an error on my website that i cant get rid of: What does this error mean and how can i get rid of it? Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xcs/public_html/functions/challengeforfeit.php on line 178

07-02-2005, 01:04 PM	#2 (permalink)
Porte Senior Member Join Date: May 2005 Location: Somewhere on earth! Posts: 3,528 21.30 NP$ (Donate)	Please open this page and get the code around that line, or we could not know where the problem reside. Also make sure that all tables correctly exist in database. __________________ Custom WordPress theme design. Top notch free WordPress themes Custom Theme Design

07-02-2005, 02:10 PM	#4 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	do you have anything in your table? __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

07-02-2005, 02:42 PM	#6 (permalink)
xlusive Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 964 101.50 NP$ (Donate)	upload your file and rename it to file1.phps and then post the url __________________ Online Dragonball Game

07-02-2005, 03:03 PM	#7 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	You might also want to try using mysql_error() to see if it spits out any more detailed errors. Example: PHP Code: `$challengeladders = mysql_query("SELECT id,respondhours,finalizehours FROM ladders WHERE challenge='1'") or die (mysql_error ());`

07-02-2005, 01:33 PM	#3 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 115 31.00 NP$ (Donate)	ok here is where in the code i think it is... //NEXT 2 FUNCTIONS DELETES AND AWARDS WINS FOR UNRESPONDED OR UNFINALIZED CHALLENGES LINE 178 - function check_unrespondedchallenges(){ $challengeladders=mysql_query("SELECT id,respondhours,finalizehours FROM ladders WHERE challenge='1'"); while(list($id,$respondhours,$finalizehours)=mysql _fetch_row($challengeladders)){ $laterespond=date("Y-m-d H:i:s",time()-6060$respondhours); $latefinalize=date("Y-m-d H:i:s",time()-6060$finalizehours); $challengeinfo=mysql_query("SELECT challid,challenger,challenged,ladderid,challengerr ank,challengedrank,respondedby,finalizedby FROM challenges WHERE ladderid='$id' AND respondedby='0' AND finalizedby='0' AND challengedtime < '$laterespond' OR ladderid='$id' AND respondedby > '0' AND finalizedby='0' AND respondedtime < '$latefinalize'"); while(list($challid,$challenger,$challenged,$ladde rid,$challengerrank,$challengedrank,$respondedby,$ finalizedby)=mysql_fetch_row($challengeinfo)){

07-02-2005, 02:26 PM	#5 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 115 31.00 NP$ (Donate)	I have many db tables. but i dont know what the table should be called? What should it be called in the table/db?

07-02-2005, 03:50 PM	#8 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	open, in php_my_admin, the table "ladders" in browse mode. Is there any data in there? That could be your problem. It was the same error for me, when I didn't have anything in my table! __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

07-02-2005, 05:13 PM	#9 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 115 31.00 NP$ (Donate)	Still no luck, the mysql_error didnt give me anymore information here is the link with the actually script on anyway for you to have a look at Code Thank You

07-03-2005, 01:47 AM	#12 (permalink)
val539 New Member Join Date: Jul 2005 Posts: 8 12.00 NP$ (Donate)	sorry i change the post because for any reason the code is changed PHP Code: `$numbers_challengeladders=array(); //line Valerie $numbers_challengeladders=@mysql_fetch_row($challengeladders); //line Valerie if (count($numbers_challengeladders)>0) { //line Valerie` challengeladders BECOMES challe ngeladders, in 2nd line, (bug vbulletin ) see the attachment file it's better Regards Last edited by val539; 07-03-2005 at 01:54 AM.

07-03-2005, 07:31 AM	#13 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 115 31.00 NP$ (Donate)	Thanx for all your help Got rid of the error, thanx again

07-03-2005, 07:41 AM	#14 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	good! what was wrong? __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parse error: parse error, unexpected $	efriese	Programming	4	06-28-2005 04:55 AM
NP error message	redhippo	The Break Room	2	02-08-2005 04:07 AM
Custom Error Pages - HELM & FrontPage together on Windows Server?	Cosmos75	Web Design Discussion	2	08-03-2004 01:43 PM
NameCheap, again. [ An error occured ]	Darren	Domain Name Discussion	1	05-31-2004 07:33 PM