Re: [Connotea-code-devel] 'node' renamed to 'node_id' ?

[Alexander D. <doc...@gm...>]

I am getting at least some of your messages, Brian.

Thank you for the work, and the sharing.

..alex...

On Thu, Sep 25, 2008 at 2:53 PM, Brian <Bri...@co...> wrote:

> My last paste was supposed to be the output of 'desc meatadata', which
> simply reveals the existence of 'node_id'.
>
>
>
> On Thu, Sep 25, 2008 at 12:52 PM, Brian <Bri...@co...> wrote:
>
> > I am getting the following error when I try to look at a user library:
> >
> > Error exception report:
> >
> > user test (1) requests /user/test bringing load to 1 with db at
> 1222290807
> >
> > 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 52.
> >
> >
> > I can recreate this in mysql:
> >
> > mysql> use conwiki;
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> >
> > Database changed
> > mysql> show tables;
> > +-------------------+
> > | Tables_in_conwiki |
> > +-------------------+
> > | content           |
> > | internal_links    |
> > | metadata          |
> > | node              |
> >
> > | schema_info       |
> > +-------------------+
> > 5 rows in set (0.00 sec)
> >
> > mysql> SELECT metadata_type, metadata_value FROM metadata WHERE
> node='User:test' AND version='0';
> > ERROR 1054 (42S22): Unknown column 'node' in 'where clause'
> >
> > As you can see there is no 'node' column, but there is a 'node_id'
> column:
> >
> > mysql> use conwiki;
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> >
> > Database changed
> > mysql> show tables;
> > +-------------------+
> > | Tables_in_conwiki |
> > +-------------------+
> > | content           |
> > | internal_links    |
> > | metadata          |
> > | node              |
> >
> > | schema_info       |
> > +-------------------+
> > 5 rows in set (0.00 sec)
> >
> > mysql> SELECT metadata_type, metadata_value FROM metadata WHERE
> node='User:test' AND version='0';
> > ERROR 1054 (42S22): Unknown column 'node' in 'where clause'
> >
> >
> > Yet another serious bug in Connotea Code...? I see that none of my
> messages
> > to these lists are being let through moderation...a shame.
> >
> >
> > --
> > (Not sent from my iPhone)
> >
>
>
>
> --
> (Not sent from my iPhone)
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Connotea-code-devel mailing list
> Con...@li...
> https://lists.sourceforge.net/lists/listinfo/connotea-code-devel
>



-- 
..alex...
doc...@gm...

Alexander DeLuca, M.D., MPH
Senior Consultant, Pain Relief Network
http://www.painreliefnetwork.org/
http://www.doctordeluca.com/wordpress/
http://www.doctordeluca.com/


- There is no medical treatment for non-problematic substance use... there
is only punishment.