Hello,
I installed UdmSearch 3.0.13 on our FreeBSD Apache/1.3.6
PHP/3.0.11 Webserver using a MySQL 3.22.25 Database.
I used the minimal.conf from
http://mysearch.udm.net/doc/samples/minimal.conf ,
changed my DB settings and changed to DBMode to multi.
The indexer runs fine but when I search for certain words I only get
the URLs, no additional Texts or Site-Titles even when "Output
format:" is "long".
The appereance somehow does not change.
Can anyone of you tell me what I am making wrong?
Maybe I've the wrong Column types. After using create.txt to create
the MySQL tables, the indexer still asked for certain fields that were
not existing, so I had to add them by hand.
Dump shemes of the table follow below. - If this is the problem, would
someone mind telling me where I could find the correct Create-
syntax for the various tables?
thanks for your help
Franz
affix:
******
CREATE TABLE affix (
flag char(1) NOT NULL,
type char(1) NOT NULL,.
mask varchar(32) NOT NULL,
find varchar(32) NOT NUL.L,
repl varchar(32) NOT NULL,
docsize mediumint(8) unsigned DEFAULT '0' NOT NULL,
lang char(3) NOT NULL,
KEY key1 (flag)
);
dict - dict32:
***************
CREATE TABLE dict (
url_id int(11) DEFAULT '0' NOT NULL,
word varchar(63) NOT NULL,
intag tinyint(4) DEFAULT '0' NOT NULL,
docsize mediumint(9) DEFAULT '0' NOT NULL,
word_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
KEY url_id (url_id),
KEY word_url (word, url_id)
);
robots:
********
CREATE TABLE robots (
hostinfo varchar(127) NOT NULL,
path varchar(127) NOT NULL
);
spell:
*******
CREATE TABLE spell (
word varchar(64) NOT NULL,
flag varchar(32) NOT NULL,
docsize mediumint(9) DEFAULT '0' NOT NULL,
KEY key1 (word)
);
stopword:
***********
CREATE TABLE stopword (
word varchar(64) NOT NULL,
lang char(3) NOT NULL,
PRIMARY KEY (word)
);
url:
****
CREATE TABLE url (
rec_id int(11) DEFAULT '0' NOT NULL auto_increment,
status int(11) DEFAULT '0' NOT NULL,
url varchar(128) NOT NULL,
content_type varchar(32) NOT NULL,
last_modified varchar(32) NOT NULL,
title varchar(128) NOT NULL,
text varchar(255) NOT NULL,
size int(11) DEFAULT '0' NOT NULL,
indexed tinyint(4) DEFAULT '0' NOT NULL,
last_index_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
next_index_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
referrer int(11) DEFAULT '0' NOT NULL,
tag int(11) DEFAULT '0' NOT NULL,
hops int(11) DEFAULT '0' NOT NULL,
keywords varchar(255) NOT NULL,
description varchar(100) NOT NULL,
crc varchar(33) NOT NULL,
docsize mediumint(9) DEFAULT '0' NOT NULL,
txt varchar(200) NOT NULL,
lang char(3) NOT NULL,
PRIMARY KEY (rec_id),
UNIQUE url (url),
KEY key_crc (crc)
);
--
Franz Graf - Webdesign
FutureByte GmbH - Net Development Equipment
http://www.futurebyte.net
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]
