This looks like a great module, but I get this error when entering inbox:

user warning: Invalid use of group function query: SELECT MAX(pmi.mid) as id, pmi.thread_id, pm.subject, pmi.author, pmi.timestamp, MAX(pmi.new) as new FROM pm_message pm INNER JOIN pm_index pmi ON pm.mid = pmi.mid WHERE (pmi.recipient = 1) GROUP BY pmi.thread_id ORDER BY pmi.new desc, MAX(pmi.mid) DESC in /home/www/thewebsite.net/drupal/modules/privatemsg/privatemsg.module on line 248.

And PM's don't get sent. I've activated these modules: Private messages, Messaging, Messaging Privatemsg. Running on Drupal 6.4 and using Messaging 6.x-1.0

What could fix this?

Comments

TSNetwork’s picture

TSNetwork commented
Priority: Normal » Critical

Some help? I really need this module...

TSNetwork’s picture

TSNetwork commented

This problem still appears with the new versions of Messaging. Any help?

jose reyero’s picture

jose reyero commented
Priority: Critical » Normal
Status: Active » Postponed

This won't fix until we get some usable API from privatmsg side, which seems is taking ages #288183: Provide api function for other modules to send messages.

(If not ready when we put out a new stable Messaging release we'll have to drop privatemsg support at that point)

jose reyero’s picture

jose reyero commented
Title: Invalid use of group function query: SELECT MAX(pmi.mid) as id ...... ERROR » Integration with Privatemsg not up to date
berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Postponed » Active

The api patch has now been added to privatemsg (finally :) )

Please look at http://drupal.org/node/369399 for a documentation on how to use the message sending functions.

sanluca’s picture

sanluca commented

excuse but ultimately this issue is resolved?
thanks

jose reyero’s picture

jose reyero commented
Status: Active » Fixed

Updated following that api documentation, let me know whether it works.

Status: Fixed » Closed (fixed)

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