PhpDig.net

PhpDig.net (http://www.phpdig.net/forum/index.php)
-   Troubleshooting (http://www.phpdig.net/forum/forumdisplay.php?f=22)
-   -   Num_page zero length (http://www.phpdig.net/forum/showthread.php?t=2256)

Dave A 11-16-2005 02:12 AM

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?

Charter 11-18-2005 02: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 02: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 03: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. :eek:


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

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