In the 5.x version of CiviCRM Subscribe there is a subscribe block. However, the equivalent block in 6.x does not work, since it relies on a table, {civicrm_subscribe_form}, which the install routine does not create.

I recommend not using the block in the 6.x version until this issue is resolved. It will be resolved prior to the release of 6.x-1.0.

Note that this may also have implications for the upgrade path from 5.x->6.x of the module, but I'm not sure if anyone has done one yet.

To fix this, I'll need to create the proper array for hook_schema() to install the civicrm_subscribe_form table if it doesn't already exist, and create an update routine for people on earlier versions of the module for 6.x, but testing to make sure that they don't already have the table.

Patches are welcome, of course :)

Comments

EvanDonovan’s picture

Title: CiviCRM Subscribe block does not work - queries non-existent table » 6.x CiviCRM Subscribe block does not work - queries non-existent table
EvanDonovan’s picture

StatusFileSize
new0 bytes

This patch should fix the issue. Am going to commit to dev, and mark this fixed.

Reopen if there are further issues.

EvanDonovan’s picture

StatusFileSize
new6.69 KB

Wrong patch, sorry. This one is it.

Note that this patch contains an update routine, so it will create the necessary table.

The table is not actually used in the block code anymore, however, so this is not a full fix. There will be a followup issue before the next beta (but not today).

EvanDonovan’s picture

Status: Active » Fixed

Fixed in dev. You can either apply this patch, or upgrade to dev, and the subscribe block should work. If it does not, please re-open this issue, and I will re-title it according to the remaining problems.

You must run update.php after applying the patch.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.