Re: [Connotea-discuss] Connotea installation problem

[Mustansar M. <mus...@ri...>]

FULLTEXT KEY `url_ft` (`url`) is missing


and for Wiki::Tooklkit I created the DB using the setupdb script. I 
notice that column name is node_id instead of node...



I was wondering of there is any latest version  a bit more streamlined 
version of connotea sitting in some publicly accessible svn/cvs repository.
Thanks,
Mustansar
Martin Flack wrote:
>
> 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
>
>


-- 
Mustansar  Mehmood
Educational Sys Dev/Integrator
Academic & Research Computing
Rice University
Houston Texas

Phone: (713)348 2523
Fax:   (713)348 6099