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

[Brian <Bri...@co...>]

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)