"Invalid argument supplied for foreach()", Privatemsg incompatibility

salvis,

again, thanks for the help on this, and I've finally got round to doing this.

Privatemsg has been reverted and mail_edit has been installed - this did not make the bug go away.

I've also tried to revert subscriptions back to last stable version (1.9) which now gives the error:

user warning: Unknown column 's.stype' in 'field list' query: SELECT td.tid, td.name, n.nid, n.title, s.stype, s.sid FROM ((subscriptions s LEFT JOIN node n ON n.nid = s.sid) LEFT JOIN term_node tn ON tn.nid = s.sid) LEFT JOIN term_data td ON td.tid = tn.tid WHERE n.status = 1 AND s.uid = 1 AND s.stype = 'node' in /home/********/public_html/portal/includes/database.mysql.inc on line 172.
user warning: Unknown column 's.stype' in 'field list' query: SELECT u.uid, u.name, s.stype, s.sid FROM (subscriptions s LEFT JOIN users u ON u.uid = s.sid) WHERE u.status = 1 AND s.uid = 1 AND s.stype = 'blog' in /home/********/public_html/portal/includes/database.mysql.inc on line 172.
user warning: Unknown column 's.uid' in 'where clause' query: SELECT td.tid, td.name FROM subscriptions s INNER JOIN term_data td ON td.tid = s.sid WHERE s.uid = 1 AND s.stype = 'taxa' in /home/********/public_html/portal/includes/database.mysql.inc on line 172.

on all pages :(.

Very grateful if you have any other suggestions on what could be going wrong. I'm happy to use beta test software (it's a development site after all) and do whatever is necessary to chase down the bugs.

Thanks for your continued support,
Gareth

Will do with Subscriptions - probably should have done this to start with.

Can I infer from your mail then that No version of PrivateMsg (reverted back to a 1.9? build) is actually working?
Can you recomend an alternative?

Gareth

Thanks.

Will have to go to subscriptions 2.0 (as recomnded by you, needed for my forum subscriptions) and investigate a different Private Message solution for the time being :(

I hope we can get a stable 5.x version before 6.x comes through!

Thanks again,

Gareth

I've removed Subscriptions, PrivateMsg and Mail_Edit.

I've resintalled the latest version of Subscriptions (2.0b7) and mail_edit.

On reinstalling subscriptions (the first time this is ticked on in the admin/bulid/modules/ I get the following error:

user warning: Unknown column 'DRUPAL_AUTHENTICATED_RID' in 'field list' query: INSERT INTO subscriptions_user (uid, digest, send_interval, send_updates, send_comments) VALUES(-DRUPAL_AUTHENTICATED_RID, 0, 1, 0, 0) in /home/********/public_html/portal/includes/database.mysql.inc on line 172.

I get no errors in trying to alter the subscriptions module permissions

Now, adding a new comment to an article I get the error:

user warning: Column 'send_comments' in where clause is ambiguous query: INSERT INTO subscriptions_queue (uid, name, mail, language, module, field, value, author_uid, send_interval, digest, last_sent, load_function, load_args) SELECT u.uid, u.name, u.mail, u.language, s.module, s.field, s.value, s.author_uid, s.send_interval, su.digest, su.last_sent, 'subscriptions_content_comment_load', '20' FROM subscriptions s INNER JOIN subscriptions_user su ON s.recipient_uid = su.uid INNER JOIN users u USING(uid) WHERE s.module = 'node' AND s.field = 'nid' AND s.author_uid IN (1, -1) AND send_comments = 1 AND s.value = '9' AND s.recipient_uid != 1 in /home/********/public_html/portal/includes/database.mysql.inc on line 172.
user warning: Column 'send_comments' in where clause is ambiguous query: INSERT INTO subscriptions_queue (uid, name, mail, language, module, field, value, author_uid, send_interval, digest, last_sent, load_function, load_args) SELECT u.uid, u.name, u.mail, u.language, s.module, s.field, s.value, s.author_uid, s.send_interval, su.digest, su.last_sent, 'subscriptions_content_comment_load', '20' FROM subscriptions s INNER JOIN subscriptions_user su ON s.recipient_uid = su.uid INNER JOIN users u USING(uid) WHERE s.module = 'node' AND s.field = 'type' AND s.author_uid IN (1, -1) AND send_comments = 1 AND s.value = 'story' AND s.recipient_uid != 1 in /home/********/public_html/portal/includes/database.mysql.inc on line 172.
user warning: Column 'send_comments' in where clause is ambiguous query: INSERT INTO subscriptions_queue (uid, name, mail, language, module, field, value, author_uid, send_interval, digest, last_sent, load_function, load_args) SELECT u.uid, u.name, u.mail, u.language, s.module, s.field, s.value, s.author_uid, s.send_interval, su.digest, su.last_sent, 'subscriptions_content_comment_load', '20' FROM subscriptions s INNER JOIN subscriptions_user su ON s.recipient_uid = su.uid INNER JOIN users u USING(uid) INNER JOIN term_node t ON s.value = t.tid WHERE s.module = 'node' AND s.field = 'tid' AND s.author_uid IN (1, -1) AND t.nid = 9 AND send_comments = 1 AND s.recipient_uid != 1 in /home/********/public_html/portal/includes/database.mysql.inc on line 172.

I realise I've probably buggered my database with all this faffing, but I would have thought/hoped unistalling these modules would have restored the tables :(

Nevertheless, 2.0b7 is clearly unhappy in my installation. I hope this information is of use to you in fixing the issues.

For now, I am disabling subscriptions and turning PrivateMessage back on instead (was previosuly conflicting).

As before, willing to do anything I can in helping to test this module/make it stable. Grateful if you could let me know when there are more changes to test

Thanks,
Gareth