Wednesday, 23 January 2013
  2 Replies
  4.8K Visits
0
Votes
Undo
Current Kunena, current J!MailAlerts.

Configured and tested as per other posts on this forum:

-configure kunena plugin
-add required tags in email template.
-perform a sync operation once
-Set "respect last email date" to "no" for now.
-then add new content
-try simulating for userid other than creator of content.


Simulation and cron both find eligible users but no Kunena new posts.

I have confirmed that the Kunena plugin is being run.
It is hitting line 95, with the correct "lasttime" value (no user session branch).
The main query (starting on line 106 $qry) is not returning any data.

Actual query is:
SELECT q.maxid AS id, m.time, m.thread, n.hits, q.countid AS `count`, m.subject, m.userid, m.name, m.catid, q.catname, t.message , (m.time > 1358646528) AS unread FROM (SELECT max(m.id) AS maxid, count(m.id) AS countid, c.name AS catname FROM #__kunena_messages AS m JOIN #__kunena_categories as c ON m.catid = c.id WHERE c.published = 1 AND m.hold = 0 AND m.moved = 0 GROUP BY m.thread ORDER BY maxid DESC LIMIT 5) AS q JOIN #__kunena_messages AS m ON q.maxid = m.id JOIN #__kunena_messages AS n ON m.thread = n.id JOIN #__kunena_messages_text AS t ON q.maxid = t.mesid WHERE m.catid = 1

I have not had time to check the actual database data - but it still feels like the Kenuna schema has changed?

I tried removing the where clauses for date and published/hold/move and still no data is returned. This should have yielded all posts on the forum?

Help!!!!

Chris