Thanks much for your help working through these.
I am using postgresql. If I navigate to my subscription tab (/user/1/subscriptions/node), and click on pages/threads, I now get the following:
PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "c.cid" must appear in the GROUP BY clause or be used in an aggregate function: SELECT c.* FROM {comment} c WHERE (c.nid IN (SELECT CAST(s.value AS decimal) AS value FROM {subscriptions} s WHERE (s.module = :db_condition_placeholder_0) AND (s.field = :db_condition_placeholder_1) AND (s.recipient_uid = :db_condition_placeholder_2) )) AND (c.uid = :db_condition_placeholder_3) GROUP BY c.nid; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => nid [:db_condition_placeholder_2] => 1 [:db_condition_placeholder_3] => 1 ) in _subscriptions_content_node_form() (line 186 of /mypath/modules/subscriptions/subscriptions_content.admin.inc).
Comments
Comment #1
salvisProgressing ("Postgressing"?) slowly...
Pushed to the -dev version (give it up to 12h to be repackaged), thanks.
Marking fixed because committed, but as usual, please let us know if it actually helped.
Comment #2
seattlehimay commentedYep, helped! Thanks much. I'll let you know if/when the next gotcha shows up. Much appreciated.
Comment #3
salvisCould you take a look at #1348764: PostgreSQL: PDOexception error when creating or saving nodes? Seems like you should encounter that sooner or later...
Comment #4
seattlehimay commentedAh, indeed I do get that same error. I'll dig into it more tomorrow. Was there something in particular you wanted me to try? If not, I'll play with the suggestions and see if I can get rid of the "group by."
Comment #5
salvisThe issue is a bit longish. Getting it to work with distinct() would be my preferred solution and I didn't understand where that "GROUP BY" was coming from.
Let's continue the discussion in the other thread, please.