PDA

View Full Version : I got a warning, please help


David J Harmon
09-28-2003, 07: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, 09:51 PM
Does the cron job stop the search engine from working???

David

jirving
09-29-2003, 09: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, 03:45 PM
Hi. Line 917 of PhpDig 1.6.2 robot_functions.php is the following:

$nbre_mots[$token] = 1;

Did you happen to change anything in that file?

David J Harmon
09-29-2003, 03:59 PM
I think when I use the cron job I did something wrong it wipe out my db

Charter
09-29-2003, 04: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, 05:36 PM
how many url (host) or keywords will this program hold??? I planning on making it big, I mean really big...