search

demianturner / sgl-docs-tickets-migration-test

0 stars 0 forks source link

Admin and User Menu Blocks - Setting the Id Field #1658

Closed demianturner closed 11 years ago

demianturner commented 11 years ago

The admin and user navigation blocks are defined in block/data/data.default.my.sql (see below).

The insert statements for the block_assignment and block_role seem to be wrong, although it seem to work. The first field in both those tables is block_id which is an FK to the block table. I would assume that the code for say block_role should be:

{{{ -- admin menu SELECT @blockIdAdmin := block_id FROM block WHERE title = 'Admin menu'; INSERT INTO block_role VALUES (@blockIdAdmin, 1); }}}

demianturner commented 11 years ago

[demian] Hi Michael

Thanks for patch, applied in bugfix. Patch was invalid, btw, please create all patches from Seagull root (or at least modules dir) - it's a PITA to have to paste changes in line-by-line