Ah - I've figured it out. Follow the README that came in the tarball which will help you setup a CGI::Wiki database. Wiki::Toolkit is the newer version, and the www.connotea.org/code page has already been updated to mention it, but the 1.8 beta tarball code is not updated to use it, so you'll have to use CGI::Wiki for now.
Martin Ganguly, Arindam wrote: > Hey Martin, > Wiki-toolkit version 0.74 > And no fulltext indexing in the search tables. > > > -arindam > -----Original Message----- > From: Martin Flack [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 04, 2007 3:26 PM > To: Ganguly, Arindam > Cc: [email protected] > Subject: Re: [Connotea-code-devel] FW: connotea install complete...but > still some errors > > Ganguly, Arindam wrote: >> undef error - DBD::mysql::st execute failed: Unknown column 'node' in >> 'where clause' [for Statement "SELECT metadata_type, metadata_value > FROM >> metadata WHERE node='User:aganguly' AND version='0'"] at >> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52. >> >> Issue with the wiki-tookkit? > > Yes, what version do you have? This should tell you: > perl -MWiki::Toolkit -e 'print $Wiki::Toolkit::VERSION, "\n"' > > Note that we don't use CGI::Wiki anymore. > >> user aganguly (1) requests /search?q=tag bringing load to with db at >> 1196729034 >> >> undef error - DBD::mysql::st execute failed: Can't find FULLTEXT index >> matching the column list [for Statement "SELECT ub.user_bookmark_id, > [snip] > > I think this might be a bug in the schema in that particular tarball. > > You should have a main database with InnoDB tables, and if you want > search to work, a secondary database with MyISAM tables replicating from > > the first one. DBI_SEARCH in the config indicates the secondary one. > > The schema for the secondary database should be created from the schema > for the primary database with this command: > perl sql/mkschema_search < sql/schema.sql > > If that output does not contain FULLTEXT lines like this, then there is > a problem, and I'll have to help: > perl sql/mkschema_search < sql/schema.sql | grep FULLTEXT > ,FULLTEXT INDEX `name_ft` (`firstname`, `forename`, `lastname`) > ,FULLTEXT INDEX `url_ft` (`url`) > ,FULLTEXT INDEX `title_ft` (`title`) > ,FULLTEXT INDEX `title_ft` (`title`) > ,FULLTEXT INDEX `entry_ft` (`entry`) > ,FULLTEXT INDEX `name_ft` (`name`) > ,FULLTEXT INDEX `description_ft` (`description`) > ,FULLTEXT INDEX `name_ft` (`name`) > ,FULLTEXT INDEX `medline_ta_ft` (`medline_ta`) > ,FULLTEXT INDEX `name_ft` (`name`) > ,FULLTEXT INDEX `title_ft` (`title`) > ,FULLTEXT INDEX `description_ft` (`description`) > > Martin ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Connotea-code-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/connotea-code-devel
