I got a warning, please help

David J Harmon · 09-28-2003, 08:34 PM

I just got this in my admin area - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jcappucc/public_html/cyberkopia/admin/robot_functions.php on line 917 - can you please help me out!!!

David

David J Harmon · 09-28-2003, 10:51 PM

Does the cron job stop the search engine from working???

David

jirving · 09-29-2003, 10:43 AM

That particular error is saying that the query didn't execute for some reason, usually because there was an error in the query. Even if there were no rows, the result set would be valid.

I've done searches while spidering the site with no errors.

Are you sure that all your tables are correctly in place? You could drill down the code and echo the query that is causing the error.

Charter · 09-29-2003, 04:45 PM

Hi. Line 917 of PhpDig 1.6.2 robot_functions.php is the following:

PHP Code:


			
$nbre_mots[$token] = 1;

Did you happen to change anything in that file?

David J Harmon · 09-29-2003, 04:59 PM

I think when I use the cron job I did something wrong it wipe out my db

Charter · 09-29-2003, 05:12 PM

Oh no...

It shouldn't have wiped your DB tables. Can you look at the tables via phpMyAdmin? What's in the spider.log file?

David J Harmon · 09-29-2003, 06:36 PM

how many url (host) or keywords will this program hold??? I planning on making it big, I mean really big...

09-28-2003, 08:34 PM	#1
David J Harmon Orange Mole Join Date: Sep 2003 Location: Corbin KY Posts: 45	I got a warning, please help I just got this in my admin area - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jcappucc/public_html/cyberkopia/admin/robot_functions.php on line 917 - can you please help me out!!! David

09-29-2003, 04:45 PM	#4
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. Line 917 of PhpDig 1.6.2 robot_functions.php is the following: PHP Code: `$nbre_mots[$token] = 1;` Did you happen to change anything in that file? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

09-29-2003, 05:12 PM	#6
Charter Head Mole Join Date: May 2003 Posts: 2,539	Oh no... It shouldn't have wiped your DB tables. Can you look at the tables via phpMyAdmin? What's in the spider.log file? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Warning: ereg_replace(): REG_EBRACK	alivin70	Troubleshooting	3	02-23-2005 09:41 AM
Warning: ereg_replace(): REG_EBRACK in .....	Jad	Troubleshooting	3	12-12-2004 12:58 AM
Warning	clearwater	Troubleshooting	1	01-02-2004 09:31 PM
Warning: .... foreach()	isto	Troubleshooting	3	12-23-2003 05:03 PM
Requested Warning	Charter	The Mole Hole	0	11-28-2003 06:14 AM

09-28-2003, 10:51 PM	#2
David J Harmon Orange Mole Join Date: Sep 2003 Location: Corbin KY Posts: 45	Does the cron job stop the search engine from working??? David

09-29-2003, 10:43 AM	#3
jirving Green Mole Join Date: Sep 2003 Posts: 10	That particular error is saying that the query didn't execute for some reason, usually because there was an error in the query. Even if there were no rows, the result set would be valid. I've done searches while spidering the site with no errors. Are you sure that all your tables are correctly in place? You could drill down the code and echo the query that is causing the error.

09-29-2003, 04:59 PM	#5
David J Harmon Orange Mole Join Date: Sep 2003 Location: Corbin KY Posts: 45	I think when I use the cron job I did something wrong it wipe out my db

09-29-2003, 06:36 PM	#7
David J Harmon Orange Mole Join Date: Sep 2003 Location: Corbin KY Posts: 45	how many url (host) or keywords will this program hold??? I planning on making it big, I mean really big...