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) ------------------------------------------------------------------------- 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
