Topic: Automatic Newsletter for SMF2

[HoverClub]

I have removed your mod because you are ignoring my error report.

Hi,

I have installed this mod to my site. It introduced 15 errors on hxxp:validator.w3.org/check?uri=yoursitehere.com [nonactive]
Can you update your mod to complain with w3 validator?

Thanks!

I didn't ignore it - if you had installed the updated mod a couple of months ago you would have found that the validator warnings (not errors) had been fixed (not detailed in the change log as they weren't errors or function fixes/additions).  If it still throws errors then you should look to your theme (which you didn't even specify!).

[kenso]

Hi just tried to install your mod but we get this error, is there a fix?

Table '_forum.smf_gallery_cat' doesn't exist
File: /home/xxxxxxx/public_html/Sources/ManageSettings.php
Line: 2103

ozfarmer(dot)com(dot)au

using SMF 2.0.4 | SMF © 2013, Simple Machines
SimplePortal 2.3.5 © 2008-2012, SimplePortal

[TheListener]

Kenso do you use the SMF Gallery mod?

Also the way you typed out the forums address was a waste of time.

Look at your signature.

 

[Arantor]

Well, the mod looks like it tries to check for the gallery and if present does some stuff - which suggests at one point the gallery was installed but is not any more. But the gallery didn't clean up after itself.

The best way to fix that is to go to the smf_settings table, look for an entry called gallery_max_filesize and remove it.

[kenso]

I did use Gallery Mod once but I cannot find any reference to it in the DB. Maybe re install Gall Mod? And the xxx thing was just habit 

[Arantor]

-sigh-

If you go into the smf_settings table, you will find a reference to the gallery, as I have outlined, as indicated by the mod.

You can reinstall the gallery but the fact that you uninstalled it means you're not using it and that you would be better served by removing the entry mentioned.

[kenso]

Thanks for the reply, I have been into PhpMyAdmin / smf_settings to look for the gallery file you recommended but I cannot find any instance of it.

[Arantor]

It's not a file. It's a row in the smf_settings table. You went through every single entry (there are typically *hundreds*)?

[kenso]

Sorry I did mean line. Well I only searched the first 300 didn't realize there was more. I found some lines after downloading it as a CSV into excell. Just remove gallery_max_filesize?

gallery_max_height
gallery_max_width
gallery_max_filesize
gallery_who_viewing
gallery_commentchoice
gallery_shop_picadd
gallery_shop_commentadd
gallery_set_showcode_bbc_image
gallery_set_showcode_directlink
gallery_set_showcode_htmllink
gallery_set_images_per_page
gallery_set_images_per_row
gallery_thumb_width
gallery_thumb_height

[kenso]

Cool that fixed it!  Thanks for your help!

[Arantor]

All of those can go if you're not using the gallery, though only gallery_max_filesize actually *needs* to go.

[kenso]

I Have it set now and it seems to be working fine. One last thing how would I put the subscribe button in this area (pictured) on the home page?

[HoverClub]

You'd need to add a simple portal PHP code block to the top centre position on the page - the block PHP code is included in this mod package (download the latest version).

The new version also fixes the detection of SMF Gallery discussed above.

[bidouilleur]

hello Hoverclub

just installed the new version and found a little typo (see attached) NEWSLETTER

also I intend to use it on a french board so I did some translating but one variable is playing on me, no clue where to set it so it displays date in french (also see attached)

thanks for your insight

[HoverClub]

Thanks - I noticed the typo ten minutes after uploading the new version  .  It's only in the Admin config so I'll correct it at the next update.

It uses the PHP date() function - this will also be changed at the next update.

[Gryzor]

Ok, here's an interesting problem:

Every time I send out a newsletter I get a couple of emails back saying that delivery failed for some accounts (two or three); all of them are in Russia and sound like spammers. The interesting thing is, there are NO users with those addresses in my db (I have checked both by the forum's search function and by looking in the db tables). Any ideas?

[HoverClub]

I assume you allow guests to subscribe?  If so, that's why you can't find forum users with those email addresses - you'll find the email addresses for all subscribers (registered users and guests) in the table hcb_newsletter.  Spammers shouldn't get anything useful from a newsletter.

[Gryzor]

Ahhh good idea, will check it out! Thanks

[Cat McFarlane]

Hiya Hoverclub 

Awesome mod, but doesn't seem to be sending out newsletters.
 
Using latest version of smf and mod.
Installed fine.
Using Fresh Looks theme.
All options selected fine, and able to preview, after suggested change in order to be visible.
20 have subscribed, through click box at top of forum page.

Checked all settings throughout admin section and can't see why it isn't sending out ... no errors showing in log.

Thanks, Cat

[HoverClub]

Check Admin->Maintenance->Scheduled Tasks->Task Log for Newsletter entries. 
Check Admin->Maintenance->Mail->Enable Mail Queue is set
Check Admin->Maintenance->Mail->Browse Queue and check there aren't more than a handful of messages in the queue.