Comment 6 for bug 933781

Revision history for this message
Stuart Longland (redhatter) wrote :

I found this when migrating an OpenERP 6.0 database to 6.1. Long story short, the administration dashboard hardcodes a couple of IDs when the "board" module is initialised. Not sure why, but for some reason the IDs get created in the table ir_act_client, but the corresponding actions get missed in ir_actions.

I fixed it with the following SQL:

        -- Fix up ir.action.client actions: see https://bugs.launchpad.net/openerp-web/+bug/933781 --
        INSERT INTO ir_actions (
                id, name, type
        ) SELECT id,
                        name,
                        type
                FROM ir_act_client
                WHERE id NOT IN ( SELECT id
                                        FROM ir_actions
                                        WHERE type='ir.actions.client'
                );