MODS.DB9.DK

[The Grinch]

I installed the Mass PM mod after I installed Attachment Mod 2.3.8. Now when I send out a Mass PM, the reciever gets the following error when the go to check their PM's:

Could not get attachment informations for specific posts

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'LIMIT 1' at line 3

SELECT attach_id FROM phpbb2_attachments WHERE privmsgs_id = LIMIT 1

Line : 489
File : /var/www/public_html/forum/attach_mod/includes/functions_attach.php

Has anyone had success running the two together? What would I need to change to make it work?

I also noticed a spelling error under Profile:

Notify on mass PM:
Send an email for PM sendt by admin/mod to the usergroups you belong to

...probably should read

Notify on mass PM:
Send an email for PMs sent by admin/mod to the usergroups you belong to

[Niels]

yes, I have also seen this my self - to correct this:

in attach_mod/includes/function_attach.php
[FIND]

Code: Select all

   $sql = 'SELECT attach_id
   FROM ' . ATTACHMENTS_TABLE . '
   WHERE ' . $sql_id . ' = ' . $post_id . ' LIMIT 1';

[REPLACE WITH]

Code: Select all

   $sql = 'SELECT attach_id
   FROM ' . ATTACHMENTS_TABLE . '
   WHERE ' . $sql_id . ' = "' . $post_id . '" LIMIT 1';

thnaks for reporting the spell error, I will correct this

[The Grinch]

Thank you. I will give it another try shortly.

[The Grinch]

That did the trick! Thanks.

I ended up running into that empty PM box issue. I was glad to see the fix was already posted. Thank you for this mod.

[mbressman]

I ended up running into that empty PM box issue. I was glad to see the fix was already posted. Thank you for this mod.

What's the empty PM box issue? And where can I find the fix in case I run into this?

Thanks!

[The Grinch]

I believe it was a bug fix for this mod. If you installed the latest version, you probably won't run into it.