Module: Recent Messages

First, sorry for barging in with yet another support request... I am currently wrapping this up to launch my forum and after solving the previous new count issue, I have an intermittent one with this module : it works and then I get errors.

Maybe this has to do with the fact that I have only one post after deleting about 10 test post (then I rebuilt everything for database integrity, then I purged the cache), but I get this error :

Quote

Phorum Database Error
Sorry, a Phorum database error occurred.
The administrator of this forum has been
notified by email about the error.
Please try again later!

You can see this here :
[forums.modxcms.fr]

Here is what event logging tells me :

Message:

Database error: Key 'recent_threads' doesn't exist in table 'phorum_messages' (1176): SELECT *
FROM phorum_messages
USE INDEX (recent_threads)
WHERE status=2 AND forum_id IN (1,8,7,4,12,3,9,5,11,10) AND moved = 0 AND parent_id = 0 ORDER BY message_id DESC LIMIT 11


Back trace:

Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysqli.php:171
----
Function phorum_db_interact called at
{path to Phorum}/include/db/mysql.php:734
----
Function phorum_db_get_recent_messages called at
{path to Phorum}/mods/recent_messages/recent_messages.php:110
----
Function phorum_mod_recent_messages_addon called
----
Function call_user_func called at
{path to Phorum}/common.php:993
----
Function phorum_hook called at
{path to Phorum}/addon.php:137

I'll keep tabs on this when users start posting, see if it disappears for good, but thought I'd ask if there was anything documented about that.

that post will help you [www.phorum.org]

---

Thomas Seifert

Thanks a lot Thomas (wow fast support guys !), that fixed it !

Thanks for this good module.
Do you think it's easy to modify the code in order to have the same display than in the list of messages from a forum (like [www.phorum.org] for example) in particular with the moderation column and the number of pages for a thread?
Manu?

It shouldn't be too hard to add moderation links there, so I'm willing to look into that. The total number of pages it a bad idea, since it is very heavy on the database. To know how many pages you will have, you will have to let the database server run over the full messages table for each page to count the total number of messages. That will be really slow and sluggish on a bigger forum.

---

Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce

As a small note, Recent Messages does not play very well with the Classic template. The results are displayed in a table well enough, but without any shading, border or any other styling.

--
Niels Callesoe

Basic Phorum user.

I know. I never wrote a "classic" specific template. Only one for "emerald". If anyone want to sumit one for the classic template, then feel free to do so. I'd happily add it to the package.

---

Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce

I did a bit of thinking and work on showing moderation links in the recent messages and I decided that it is not a sane thing to do. Care has to be taken for example to make the links only show up for messages in forums for which the user has moderation rights (since users could be mod for only one forum). That's just a little technicality. Worse is the fact that the recent messages list shows a mixture of messages that are either thread starters or reply messages. The delete function would do different things for these. In one case it would delete a single message, but in the other case a full thread. There are some more things that I think would confuse moderators, so I decided to not implement moderation for Recent Messages.

---

Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce

I uploaded version 2.0.13 of the module. This release adds support for using the Readable Dates module as the date formatter. A settings screen was added for the module, which can be used to enable or disable the Readable Dates support.

---

Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce

Hello :)

I just try to update it and it get me a fatal error in public and mod settings page.
I look "recent_message.php" and it call :

require_once("./mods/recent_messages/defaults.php");

problem : i don't have defaults.php in the module directory.

Mickael
my Phorum