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

salvis’s picture

Status: Active » Fixed

Progressing ("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.

seattlehimay’s picture

Yep, helped! Thanks much. I'll let you know if/when the next gotcha shows up. Much appreciated.

salvis’s picture

Could you take a look at #1348764: PostgreSQL: PDOexception error when creating or saving nodes? Seems like you should encounter that sooner or later...

seattlehimay’s picture

Ah, 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."

salvis’s picture

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

Status: Fixed » Closed (fixed)

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