|
Download -
PHP Reference -
Links -
Demo 1.8.9 RC1 -
API
License - Credits - Copying - Changelog - Documentation |
|
|
01-18-2004, 07:53 AM
|
#1 |
|
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 |
|
|
|
01-18-2004, 09:06 AM
|
#2 |
|
Head Mole
Join Date: May 2003
Posts: 2,539
|
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?
__________________
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. |
|
|
|
|
01-18-2004, 09:27 AM
|
#3 |
|
Green Mole
Join Date: Jan 2004
Posts: 8
|
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 |
|
|
|
 |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Anyone considering making PhpDig work with SQL rather than MySQL? | misterbearcom | Mod Requests | 0 | 08-10-2005 04:25 PM |
| Strange problem | gim | Troubleshooting | 1 | 05-19-2005 07:53 AM |
| strange result | franklin74 | Troubleshooting | 2 | 09-13-2004 03:18 AM |
| SQL Injection - are you save?! | Rolandks | Coding & Tutorials | 0 | 05-25-2004 06:10 AM |
| Strange Error | EdgeX | Troubleshooting | 1 | 09-24-2003 07:10 AM |
