PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Troubleshooting

Reply
 
Thread Tools
Old 09-27-2004, 01:43 AM   #1
AllKnightAccess
Green Mole
 
Join Date: Sep 2004
Posts: 25
Unhappy mysql errors and warnings

trying to run "clean index", i get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../admin/cleanup_engine.php on line 60

trying to update a site, i get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /.../admin/update.php on line 138

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /.../admin/update.php on line 140

and i am unable to login to update at all.
AllKnightAccess is offline   Reply With Quote
Old 09-30-2004, 10:37 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Using a fresh install?
__________________
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.
Charter is offline   Reply With Quote
Old 09-30-2004, 12:24 PM   #3
AllKnightAccess
Green Mole
 
Join Date: Sep 2004
Posts: 25
Yes. It was a fresh install.
AllKnightAccess is offline   Reply With Quote
Old 09-30-2004, 12:32 PM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Never had those errors with a fresh install. Can you provide any further details?
__________________
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.
Charter is offline   Reply With Quote
Old 09-30-2004, 02:15 PM   #5
AllKnightAccess
Green Mole
 
Join Date: Sep 2004
Posts: 25
What kind of info would be helpful in particular?
AllKnightAccess is offline   Reply With Quote
Old 10-11-2004, 04:19 AM   #6
AllKnightAccess
Green Mole
 
Join Date: Sep 2004
Posts: 25
Exclamation

adding mysql_error() to the code, I get this message:

'nuke_phpdig_spider.spider_id' isn't in GROUP BY

what does that mean? Is the code really incorrect?

Should the query be

GROUP BY path, spider_id

instead of

GROUP BY path ?

Last edited by AllKnightAccess; 10-11-2004 at 04:28 AM.
AllKnightAccess is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spidering errors Dave A Troubleshooting 1 01-20-2006 04:31 AM
errors during installation of phpdig-1.8.8-rc1 liquidice Troubleshooting 1 04-02-2005 10:17 PM
404 errors petritur Troubleshooting 1 07-13-2004 11:56 AM
Install errors under Xitami Orb Script Installation 4 05-09-2004 10:56 AM
Segmentation Fault / errors parsing unknown Troubleshooting 8 04-11-2004 01:42 PM


All times are GMT -8. The time now is 08:11 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.