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

nelbrecht’s picture

nelbrecht commented

I 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.