Re: [Connotea-discuss] Apache configuration problems

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

Aha, Brian, I think the problem is simply that the Connotea Code release 
out there isn't updated for Wiki::Toolkit. We've made the change 
internally for connotea.org. The /code page is ahead of the release.

I've attached a patch that makes a minimal change to Wiki.pm to update 
it for Wiki::Toolkit.

Martin

Brian wrote:
> Apache refuses to load Bibliotech::Apache unless CGI::Wiki is installed. 
> But isn't that deprecated? I am not familiar with perl and I've spent a 
> lot of time trying to understand this problem, fyi.. The directions in 
> Connotea Code are easy to follow and I feel that I have.
> 
> The following is the last few lines of my apache error.log after trying 
> to load grey.colorado.edu/connotea <http://grey.colorado.edu/connotea> 
> without CGI::Wiki installed and with Wiki::Toolkit installed. Installing 
> CGI::Wiki fixes this problem, but I still get the aforementioned error 
> with `node' and `node_id':
> 
>     [Tue Sep 30 15:18:07 2008] [error] Can't locate CGI/Wiki.pm in @INC
>     (@INC contains: /usr/local/connotea /etc/perl
>     /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5
>     /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8
>     /usr/local/lib/site_perl . /etc/apache2) at
>     /usr/local/connotea/Bibliotech/Component/Wiki.pm line 12.\nBEGIN
>     failed--compilation aborted at
>     /usr/local/connotea/Bibliotech/Component/Wiki.pm line
>     12.\nCompilation failed in require at
>     /usr/local/connotea/Bibliotech/Component/List.pm line 20.\nBEGIN
>     failed--compilation aborted at
>     /usr/local/connotea/Bibliotech/Component/List.pm line
>     20.\nCompilation failed in require at
>     /usr/local/connotea/Bibliotech/Page.pm line 23.\nBEGIN
>     failed--compilation aborted at
>     /usr/local/connotea/Bibliotech/Page.pm line23.\nCompilation failed
>     in require at (eval 1316) line 3.\n\t...propagated at
>     /usr/share/perl/5.8/base.pm <http://base.pm> line 84.\nBEGIN
>     failed--compilation aborted at
>     /usr/local/connotea/Bibliotech/Page/Standard.pm line
>     12.\nCompilation failed in require at
>     /usr/local/connotea/Bibliotech/Apache.pm line 19.\nBEGIN
>     failed--compilation aborted at
>     /usr/local/connotea/Bibliotech/Apache.pm line 19.\nCompilation
>     failed in require at (eval 2) line 3.\n
> 
>     [Tue Sep 30 15:18:07 2008] [error] Can't load Perl module
>     Bibliotech::Apache for server grey.colorado.edu:0
>     <http://grey.colorado.edu:0>, exiting...
> 
> 
> 
> On Mon, Sep 29, 2008 at 5:24 PM, Brian <Bri...@co... 
> <mailto:Bri...@co...>> wrote:
> 
>     Martin, I made sure I have the latest Wiki::Toolkit, including
>     installing it from source myself. I used wiki-toolkit-setupdb (in
>     /usr/local on my system) to create the database each time, and it's
>     always created the `node_id' column. Where is the code that is
>     generating the query which looks for a column named `node'? I can't
>     find it..
> 
>     Error exception report:
> 
>     visitor requests /user/test bringing load to 1 with db at 1222473608
> 
>     http://grey.colorado.edu/connotea/user/test
> 
> 
>     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:test' AND version='0'"] at /usr/local/share/perl/5.8.8/DBIx/ContextualFetch.pm line 54.
> 
> 
>     Thanks much for your replies
> 
>     /Brian
> 
> 
>     On Sat, Sep 27, 2008 at 3:46 PM, Martin Flack <ma...@ne...
>     <mailto:ma...@ne...>> wrote:
> 
>         This is a Wiki::Toolkit thing. It used to be "node" back when it
>         was CGI::Wiki, and then they changed it. Is your wiki database
>         the result of running /usr/bin/wiki-toolkit-setupdb? You might
>         have upgraded it since, or should do, via CPAN, and then maybe
>         drop the wiki database and rebuild it.
> 
> 
>         Brian wrote:
> 
>             There is a specific database error that you get when you try
>             to load a user library. For example:
> 
>             http://grey.colorado.edu/connotea/user/test
> 
>             I was able to fix this in a mysql shell by replacing 'node'
>             with 'node_id'. Is that a bug?
> 
> 
> 
> 
> 
>     -- 
>     (Not sent from my iPhone)
> 
> 
> 
> 
> -- 
> (Not sent from my iPhone)