Thanks for the help thus far. Now I have a problem with the php front
end. It is looking for a table that is not in the database.
SELECT flag,lang,mask,find,repl FROM affix WHERE type='s'
Warning: PostgresSQL query failed: ERROR: affix: Table does not exist. in
db_func.inc on line 120
Warning: 0 is not a PostgresSQL result index in db_func.inc on line 82
An error occured!
Query error: SELECT flag,lang,mask,find,repl FROM affix WHERE type='s'
ERROR: affix: Table does not exist.
If you look at the create.txt script in the create/pgsql/ directory you
will see that there is no affix table.
DROP table "url";
DROP table "dict";
DROP table "robots";
DROP table "stopword";
DROP SEQUENCE next_url_id;
CREATE SEQUENCE next_url_id;
CREATE TABLE "url" (
"rec_id" int4 DEFAULT nextval('next_url_id') PRIMARY KEY,
"status" int4 NOT NULL DEFAULT 0,
"url" character varying(128) NOT NULL,
"content_type" character varying(48) NOT NULL DEFAULT '',
"last_modified" character varying(32) NOT NULL DEFAULT '',
"title" character varying(128) NOT NULL DEFAULT '',
"txt" character varying(255) NOT NULL DEFAULT '',
"docsize" int4 NOT NULL DEFAULT 0,
"last_index_time" int4 NOT NULL,
"next_index_time" int4 NOT NULL,
"referrer" int4 NOT NULL DEFAULT 0,
"tag" int4 NOT NULL DEFAULT 0,
"hops" int4 NOT NULL DEFAULT 0,
"keywords" character varying(255) NOT NULL DEFAULT '',
"description" character varying(100) NOT NULL DEFAULT '',
"crc" character varying(33) NOT NULL DEFAULT '',
"lang" character varying(2) NOT NULL DEFAULT ' ');
CREATE TABLE "dict" (
"url_id" int4 NOT NULL,
"word" character varying(32) NOT NULL,
"intag" int4 NOT NULL);
CREATE TABLE "robots" (
"hostinfo" character varying(127) NOT NULL,
"path" character varying(127) NOT NULL);
CREATE TABLE stopword (
word character varying(32) NOT NULL DEFAULT '',
lang char(2) DEFAULT '' NOT NULL,
PRIMARY KEY (word, lang)
);
CREATE INDEX "dict_word" on "dict" using btree ( "word" );
CREATE INDEX "dict_url" on "dict" using btree ( "url_id" );
CREATE UNIQUE INDEX "url_url" on "url" using btree (
"url" "varchar_ops" );
CREATE INDEX "url_crc" on "url" using btree ( "crc" "varchar_ops" );
What am I doing wrong?
--
Craig Woodford NETCo-op Ltd.
Internet Programmer http://www.netc.net.au
[EMAIL PROTECTED] +61 3 5722 2563
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
