Num_page zero length

Dave A · 11-16-2005, 03:12 AM

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?

Charter · 11-18-2005, 03:24 AM

Where are you getting...

Code:

Site_id num_page
16 0
37 0
597 0
778 0
4151 0
5143 0
10342 0

Dave A · 11-18-2005, 03:49 AM

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.

Charter · 11-18-2005, 04:37 AM

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.

11-16-2005, 03:12 AM	#1
Dave A Purple Mole 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?

11-18-2005, 03:24 AM	#2
Charter Head Mole 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.

11-18-2005, 04:37 AM	#4
Charter Head Mole 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
URL Length	LepNinja	Troubleshooting	0	10-20-2006 07:18 AM
URL Length	LepNinja	How-to Forum	0	10-06-2006 08:03 AM
zero length files!	Dave A	Troubleshooting	0	01-10-2006 02:09 AM
Chunk Size and Summary Length	vispa	How-to Forum	1	02-26-2005 08:01 PM
Can I limit the page title length, that gets saved?	Wayne McBryde	How-to Forum	1	01-11-2004 02:19 PM

11-18-2005, 03:49 AM	#3
Dave A Purple Mole 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.