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 <[EMAIL PROTECTED]> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/connotea-code-devel
