PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Troubleshooting

Reply
 
Thread Tools
Old 11-16-2005, 02:12 AM   #1
Dave A
Purple Mole
 
Dave A's Avatar
 
Join Date: Aug 2004
Location: North Island New Zealand
Posts: 170
Num_page zero length

I have afew files that show
Site_id num_page
16 0
37 0
597 0
778 0
4151 0
5143 0
10342 0

plus heaps more of them!

Would it be okay to just delete them from the data base?

And what is the easiest way to find the domains indexed that don't have any pages attatched, it is hard to edit each file in the admin panel and I have tried a few things to try this but failed.

DataBase status
Hosts : 111475 Entries
Pages : 1,200,356 Entries
Index : 49,603,095 Entries
Keywords : 1955956 Entries
Temporary table : 24 Entries

So I have been developing a page ranking system based on content/word meaning/relationship of words and it is now working quite well at ranking the index of nearly fifty million pages.
When a search query is entered it first lookups variations of the word or words and then caculates the most related conent to be shown to visitors.
It add a few seconds to the search times but it isn't a worry.
I havwe aslo set up a another file that sits in the admin directory that allows Meta search engines to pass search queries to and get the results sent back to them, so I am now feeding heap of Meta search engines around the globe that take the feeds.

Heaps of regards
Dave A

Each message i write up here in the forum turns up two days later as a link from your forum to my search engine. lever how they do that?
Dave A is offline   Reply With Quote
Old 11-18-2005, 02:24 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Where are you getting...
Code:
Site_id num_page
16 0
37 0
597 0
778 0
4151 0
5143 0
10342 0
__________________
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 11-18-2005, 02:49 AM   #3
Dave A
Purple Mole
 
Dave A's Avatar
 
Join Date: Aug 2004
Location: North Island New Zealand
Posts: 170
I go in with PHPADMIN

Then go to site_page then search for num_page =0

Those results are given
I have a few files that show
Site_id num_page
16 0
37 0
597 0
778 0
4151 0
5143 0
10342 0

So I was wondering if I can delete them ?

Charter I am trying to trim the database down a little, a few domains indexed came back with zero files indexed but it was a chron job and I was looking for a quicker way of finding domains that don't contain files so that I can drop them from the listing without having to go through them one at a time.
Dave A is offline   Reply With Quote
Old 11-18-2005, 03:37 AM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Okay, thanks, the site_page table in current PhpDig is a table that lets PhpDig know information about how to index a given site. If you are seeing num_page in the site_page table, that means either you are running old code or you didn't upgrade correctly.
__________________
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
Reply

Thread Tools

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
URL Length LepNinja Troubleshooting 0 10-20-2006 06:18 AM
URL Length LepNinja How-to Forum 0 10-06-2006 07:03 AM
zero length files! Dave A Troubleshooting 0 01-10-2006 01:09 AM
Chunk Size and Summary Length vispa How-to Forum 1 02-26-2005 07:01 PM
Can I limit the page title length, that gets saved? Wayne McBryde How-to Forum 1 01-11-2004 01:19 PM


All times are GMT -8. The time now is 02:42 AM.


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