- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Name: victor
Subject: ServerTable
Indexer show this error message when I configure a ServerTable
../sbin/indexer -av6
{sql.c:632} Query: SELECT rec_id,url,tag,category,command,weight,ordre FROM
server2 WHERE enabled=1 AND parent=0 ORDER BY ordre
SQL-server message: Unsupported SQL database type
/usr/local/dpsearch/etc/indexer.conf:18: Unsupported SQL database type
Create table structure is:
CREATE TABLE `server2` (
`rec_id` int(11) NOT NULL default '0',
`enabled` int(11) NOT NULL default '0',
`url` blob NOT NULL,
`tag` text NOT NULL,
`category` int(11) NOT NULL default '0',
`command` char(1) NOT NULL default 'S',
`ordre` int(11) NOT NULL default '0',
`parent` int(11) NOT NULL default '0',
`weight` float NOT NULL default '1',
`pop_weight` float NOT NULL default '0',
PRIMARY KEY (`rec_id`),
UNIQUE KEY `srv_url` (`url`(255)),
KEY `srv_ordre` (`ordre`),
KEY `srv_parent` (`parent`),
KEY `srv_command` (`command`),
KEY `srv_tag` (`tag`(255)),
KEY `srv_category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
What is the problem?. The sql sentence is correct.
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Read the full topic here:
http://www.dataparksearch.org/cgi-bin/simpleforum.cgi?fid=02;post=
