Re: [Connotea-discuss] Connotea installation problem

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

Mustansar Mehmood wrote:
> yes I do have two databases;
> here is the list I have there
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | bibliotech         |
> | bibliotech_search  |
> | clicks             |
> | conwiki            |
> | mysql              |
> | test               |
> +--------------------+

Can you compare the bibliotech_search.bookmark table to your database. 
Note the FULLTEXT KEY and the ENGINE.

mysql> use bibliotech_search;
Database changed

mysql> show create table bookmark \G
*************************** 1. row ***************************
        Table: bookmark
Create Table: CREATE TABLE `bookmark` (
   `bookmark_id` int(7) unsigned NOT NULL auto_increment,
   `url` varchar(255) NOT NULL default '',
   `hash` varchar(32) NOT NULL default '',
   `article` int(7) unsigned NOT NULL,
   `first_user` int(7) unsigned default NULL,
   `citation` int(7) unsigned default NULL,
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `updated` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`bookmark_id`),
   UNIQUE KEY `url_idx` (`url`),
   KEY `hash_idx` (`hash`),
   KEY `citation_idx` (`citation`),
   KEY `first_user_idx` (`first_user`),
   FULLTEXT KEY `url_ft` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

> And there is another error
> 
> user mustansar (1) requests /user/mustansar bringing load to 1 with db 
> at 1234223876
> 
> http://staff-64-mud48-037.rice.edu//user/mustansar
> 
> 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:mustansar' AND version='0'"] at 
> /usr/local/lib/perl5/site_perl/5.10.0/DBIx/ContextualFetch.pm line 52.
> 
> btw here is my output for perl wiki
> perl -MWiki::Toolkit -e 'print $Wiki::Toolkit::VERSION, "\n"'
> 0.77
> seems like schema's out of synch with the code

Did you create the wiki database with the Wiki::Toolkit 0.77 module? 
i.e. by running wiki-toolkit-setupdb that comes with it?

Martin