Spider error: mysql_num_rows(): supplied argument is not ...

Bug Reporting and Feature Suggestions /Improvements go here.

Moderator: pgolovko

Spider error: mysql_num_rows(): supplied argument is not ...

Postby Brian294 » 01/07/2007 7:37 am

I was spidering this site:
http://www.thebookeryonline.com/

and as it made it's way through the pages, I got this error. It's probably an issue with a malformed URL on their part.

Code: Select all
Parable Christian Stores - Your Bible bookstore for Christian books, Bibles, music and Bible studies
http://www.thebookeryonline.com/parable/\ (PR0, Recip: NO)

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/brian294/public_html/dir/admin/spider.php on line 29
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Parable Christian Stores - Your Bible bookstore for Christian books, Bibles, mus' at line 1
Brian294
 
Posts: 79
Joined: 12/03/2006 12:08 am


Postby pgolovko » 01/07/2007 10:00 am

Try to reindex that URL again, see if you get same errors for the same URLs. Your server might have been overloaded at that time with multiple database queries. Were you running more than one or two spiders at the same time? I've noticed a similar problem when you try to index many URLs with multiple spiders at the same time you get database server overloaded.
__________________
Best regards,
Pavel Golovko
User avatar
pgolovko
 
Posts: 494
Joined: 03/25/2006 1:23 am
Location: Somewhere on planet Earth ....


Return to Bug Reporting

Who is online

Users browsing this forum: No registered users and 0 guests

cron