Php/mysql error

resolva · 07-02-2005, 01: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, 02: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, 02: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'");

????: NamePros.com http://www.namepros.com/programming/103631-php-mysql-error.html
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, 03:10 PM

do you have anything in your table?

resolva · 07-02-2005, 03: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?

aween · 07-02-2005, 03:42 PM

upload your file
and rename it to

file1.phps

and then post the url

deadserious · 07-02-2005, 04: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 ()); 

????: NamePros.com http://www.namepros.com/showthread.php?t=103631

PoorDoggie · 07-02-2005, 04: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, 06: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, 02:11 AM

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

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

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, 02: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

????: NamePros.com http://www.namepros.com/showthread.php?t=103631
    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, 08:31 AM

Thanx for all your help

Got rid of the error, thanx again

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

good!

what was wrong?

07-02-2005, 01:59 PM	THREAD STARTER #1 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 159	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, 02:04 PM	#2 (permalink)
Porte Senior Member Join Date: May 2005 Location: I'm right here Posts: 3,526	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. __________________ WP Theme Developer Your One-stop for Premium Magazine/CMS WordPress Themes Deluxe Themes

07-02-2005, 03:42 PM	#6 (permalink)
aween Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 967	upload your file and rename it to file1.phps and then post the url __________________ aween web development

07-02-2005, 04:03 PM	#7 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,255	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 ()); ????: NamePros.com http://www.namepros.com/showthread.php?t=103631`

07-03-2005, 02:47 AM	#12 (permalink)
val539 New Member Join Date: Jul 2005 Posts: 8	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 ????: NamePros.com http://www.namepros.com/showthread.php?t=103631 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 02:54 AM.

07-02-2005, 02:33 PM	THREAD STARTER #3 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 159	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'"); ????: NamePros.com http://www.namepros.com/programming/103631-php-mysql-error.html 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, 03:10 PM	#4 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	do you have anything in your table?

07-02-2005, 03:26 PM	THREAD STARTER #5 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 159	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, 04:50 PM	#8 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	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!

07-02-2005, 06:13 PM	THREAD STARTER #9 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 159	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, 08:31 AM	THREAD STARTER #13 (permalink)
resolva NamePros Member Join Date: Apr 2005 Location: England Posts: 159	Thanx for all your help Got rid of the error, thanx again

07-03-2005, 08:41 AM	#14 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	good! what was wrong?

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 05:55 AM
NP error message	redhippo	The Break Room	2	02-08-2005 05:07 AM
Custom Error Pages - HELM & FrontPage together on Windows Server?	Cosmos75	Web Design Discussion	2	08-03-2004 02:43 PM
NameCheap, again. [ An error occured ]	Darren	Domain Name Discussion	1	05-31-2004 08:33 PM