PDA

View Full Version : Strange SQL error


drjohnchadwick
01-18-2004, 06:53 AM
:confused: I have seen something similar in the trouble shooting section, but nothing like this. Phpdig seems to be working for the most part, but I have started to get the following error message when I go to the admin page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\phpdig\admin\index.php on line 39

The database status show nothing in the temporary table. Not even zero. Just blank.

Now, when I run the job to spider and update sites I get the following message:


C:\Program Files\Apache Group\Apache2\htdocs\phpdig\admin>c:\php\php.exe spider.
php http://www.dol.state.nm.us
X-Powered-By: PHP/4.3.2
Content-type:text/html; Charset=iso-8859-1

Spidering in progress...
-----------------------------
SITE : http://www.dol.state.nm.us/
Exclude paths :
- @NONE@
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in <b>C:\Program Files\Apache Group\Apache2\htdocs\phpdig\admin\spider
.php</b> on line <b>254</b><br />
<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in <b>C:\Program Files\Apache Group\Apache2\htdocs\phpdig\admin\spider
.php</b> on line <b>548</b><br />
<br />
<b>Warning</b>: mysql_free_result(): supplied argument is not a valid MySQL res
ult resource in <b>C:\Program Files\Apache Group\Apache2\htdocs\phpdig\admin\spi
der.php</b> on line <b>549</b><br />
No link in temporary table
links found : 0
...Was recently indexed
Optimizing tables...
Indexing complete !

Any ideas on this one?

Thanks,

John

Charter
01-18-2004, 08:06 AM
Hi. It looks like something on the site being crawled is breaking the query. Is it crawling http://www.dol.state.nm.us/ that these errors appear? What version of PhpDig are you running?

drjohnchadwick
01-18-2004, 08:27 AM
It looks like I got it figured out. Something corrupted tempspider SQL database table. I had used the www.dol.state.nm.us site as an example. I suspect something broke the temporary table during a recent crawl.

Long story short, I went into the database and repaired the table using the phpmyadmin interface. Everything seems to be happy and content now.

I am using PhpDig 1.6.5.

John