Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
In file subscription.module
line 129
the table name "subscription_channels" in the SQL-statement lacks curly braces and thus brakes on installations using table name prefixes.
Comments
Comment #1
nelbrecht CreditAttribution: nelbrecht commentedI should have tested before posting: My http://site/drupal/cron.php was also broken and in subscription.module I put backticks around the identifier "condition" to get it working. Like in line 273 I now have:
$result = db_query("SELECT s.*,c.name,c.id FROM {subscription_subscriptions} s LEFT JOIN {subscription_channels} c ON s.cid=c.cid WHERE c.daily\
=%d ORDER BY uid, cid, object, `condition`", $digest);
This might be due to my MySQL, and - yes - there are more places to check. I went through all to get it work.