View Single Post
Old 01-18-2004, 06:53 AM   #1
drjohnchadwick
Green Mole
 
Join Date: Jan 2004
Posts: 8
Strange SQL error

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
drjohnchadwick is offline   Reply With Quote