Hi!
I noticed that I get some DB errors while browsing Asgard trash or
executing purge_deleted from various tables:
Processing class org_routamc_positioning_location
( ! ) Warning: (pid:11452): QUERY FAILED: Unknown column
'org_routamc_positioning_location.country' in 'field list'
/usr/share/php/midcom/lib/midcom/exec/purge_deleted.php on line 33
Processing class org_routamc_positioning_country
( ! ) Warning: (pid:11452): QUERY FAILED: Table
'midgard.org_routamc_positioning_country' doesn't exist
Processing class org_openpsa_expense
( ! ) Warning: (pid:11452): QUERY FAILED: Unknown column
'org_openpsa_expense.revision' in 'field list'
Processing class org_openpsa_deliverable
( ! ) Warning: (pid:11452): QUERY FAILED: Unknown column
'org_openpsa_deliverable.target' in 'field list'
Processing class org_openpsa_document_link_organization
( ! ) Warning: (pid:11452): QUERY FAILED: Table
'midgard.org_openpsa_document_link' doesn't exist
Processing class org_openpsa_products_businessarea
( ! ) Warning: (pid:11452): QUERY FAILED: Unknown column
'org_openpsa_products_businessarea.created' in 'field list'
Processing class org_openpsa_products_businessarea_member
( ! ) Warning: (pid:11452): QUERY FAILED: Unknown column
'org_openpsa_products_businessarea_member.created'
The database in question was just updated from 2.6 running on a
different server, where none of the components in question where
installed (so the tables are all empty and so far unused). I ran
datagard update multiple times and have TableCreate and TableUpdate set
to true in the config file, but this doesn't fix those problems.
In this particular database, I can live without those tables, but I
still wonder why some columns/tables apparently didn't get created. Also
I wonder if the missing columns should be added to the database or
removed from the XML schema.
Bye,
Andreas
_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user
