I'm receiving the following error:

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '1175986633' AND emailDate < '1176073033' AND options & 16 LIMIT;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Tuesday, May 8th 2007 @ 06:57:13 PM
Script : http://www.--/admincp/cronadmin.php?...cron&cronid=21
Referrer : http://www.--/admincp/cronadmin.php?do=modify
IP Address : --
Username : --
Classname : vb_database

I cannot find where to make the options. It does not appear in the vb options menu

If installed correctly, it does. You may need to refresh your ACP.

I just wanted to say that this is an awesome mod!

Would it maybe be possible making the email text language-specific? We are using two main languages on our board and now we can only send out the email in just one language. :)

it will be something i would consider adding when i get round to making the next version.

i just installed the addon
will it work automaticly?
and what is the best values for the settings that dont affect the server

thanx alot

Read the instructions. There are some settings you will probably need to change.

Which version did you install? 1.09 or 1.11?

*installed, thanks!

any idea on flood control so I dont get blacklisted?

WoW good idea of getting back the old members. Nice hack, Installed it.

i installed
1.11

Thank you

Will give it a go :)

Install

work great!!!!!!!

I've been looking for something like this. Thanks a lot.

*Installed*

Now i just hope my emails get threw to the members and not there spam box. lol

Thanx for the great mod :)

Thanks, that would be great! I'll keep an eye on the changes here ;)

It's working great!! Thanks!!

dont hold your breath though! I'm working so much right now i dont have time to work on the fun stuff

I down loaded 1.11 on vb 3.65. I set up a test group and put my test User in and ran this manually. I got "464 inactive users found, emailed test" perfect! I then switched it to User Group 2 for Registered Users and ran it again expecting it to email the 464 and instead I got "no inactive users found" HUH? It was working....should I uninstall and install 1.09?

Okay, I uninstalled 1.11 and installed 1.09 and it has sent off the first 5 emails. I just hope they aren't all HTML'd and funky. But if it gets some people back then cool!

uninstalled sorry.

last night the host turned my site off, because this script was hammering the server, also and this is strange over the last few days i hadn't been recieving any email for this particular address and now i've uninstalled this the email has returned.

can someone tell me where I can check in the cp as to how many emails were sent etc?

which version were you using, and by "hammering" what do they mean?

it sends out a daily email with a report (ver 1.11) and you can also view the cron logs

how do i view cron logs?

Admin CP | Scheduled Tasks | Scheduled Task Logs

Selective Inactive User Reminder Emails from the drop-down box.

Also, what were your settings for the options for this add-on?

Hello! I have 1.11 installed and I get this when I look at log "...but their email address was invalid". But their emails are valid! What's the problem?

I set the usergroup number to a Test Usergroup with only one user.. Run the Cron Job and get more than 6.000 users!

I was trying to run the cron job with that particular test-usergroup, but it didn't found the user. So i checked "Inactivity based on last post" to yes, run the cronjob and found those +6.000 users [but they aren't on that usergroup!]

What's wrong?

it just uses the vbulletin's internal email checking api. it just runs through that before attempting to send an email so it does not error on sending.

Thanks. Appreciated. :)

installed, do I HAVE to add a cron job manually?

OK, I know now ;)

No. It should have been done automatically with the product import.

I just installed and did a manual test. It seems to be working properly, but the email that was sent to my test account went into my spam mailbox. I'm sure there are a lot of variables to this stuff, but is there anything that can be done to minimize the chances of these emails being treated as spam?

Thanks,

Andrew

I can confirm raven3d's issue. I have had to disable the cron because the product sent out the entire inactive list at the same time (well it took about 4 hours for it to get through the 500 or so Inactive members) - verified via the cron log.

My mail batch is set up to 10 emails at a time and the log is showing the emails from the hack going out one right after the other.

I attached the first three pages of the cron log -- there are over20 more pages following these with mail going out one right after the other.


I hope this issue can be resolved as it can be a very beneficial tool to the board.

Same here, i tried this hack and it sent all the emails at once.
My host does not allow hundreds of emails at once so bounced them to my catch all.

I assume that those of you reporting this issue are using version 1.10 or version 1.11.

I strongly recommend that you uninstall that version and install version 1.09 instead.

According to the developer's notes above:

"Update 1.1.0 - Changed the way that emails are sent out by adding the emails to vbulletin's mail queue"

So isn't this working properly? Any comments from the developer?

I've installed this, but it's currently set up for testing with the admin group only. I have over 400 inactive members, so I want to make sure it's working properly before I use it with registered members.

Thanks,

Andrew

Prior to version 1.10, emails were sent out in batches with a configurable batch size using a cron job. Starting with version 1.10, all emails were added to the vBulletin mail queue. I think with a mod like this, that's a mistake, and certainly it seems to have caused a number of problems for different forum installations - that's why version 1.09 is still available for download. The author, Chris, is working on the bugs in 1.11 as he gets time but my advice is to consider version 1.10 and 1.11 as Beta versions, with 1.09 as the latest stable release.

i can understand that emails will be sent out regular with the latest version, and tbh i think 1.09 is the better option.

i really wish i had more time to work on this, and when i do ill start from 1.09 and scrap later versions.

I have now installed v1.09 and it's working great. :up: