I also have a problem with custom blocks on my home page CMS after 6788. The CMS page uses a slider, which is on the backwards incompatible list because of the old router config. I used supee-6788-toolbox:
I can see the custom block in the permission_block
table.
| block_id | block_name | is_allowed |
+----------+----------------------+------------+
| 1 | core/template | 1 |
| 2 | catalog/product_new | 1 |
| 3 | customslider/default | 1 |
The config.xml
uses the
<admin>
<routers>
<adminhtml>
<args>
<modules>
<customslideradmin before="Mage_Adminhtml">Custom_Customslider_Adminhtml</customslideradmin>
</modules>
</args>
</adminhtml>
</routers>
Now the home page is blank. When I remove the custom slider the other blocks load ok. There is only one telltale sign for the blank screen, in var/log/exception.log
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax
SELECT `main_table`.* FROM `m_customslider_banner` AS `main_table`
LEFT JOIN `m_customslider_value` AS `status`
ON main_table.banner_id = status.banner_id
AND status.store_id = 2 AND status.attribute_code = 'status'
WHERE (`customslider_id` = '2')
AND (`IF(status`.`value IS NULL, main_table`.`status, status`.`value)` = '0')
AND (`start_time` <= '2015-10-28') AND (`end_time` >= '2015-10-28')
Is there another reason that the patch would have caused this?