Re: [Connotea-code-devel] FW: connotea install complete...but still some errors

[Martin F. <ma...@ne...>]

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