vb.org Archive - Mini Mods - Email Reminder for inactive users

Page 35 of 71

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Mini Mods - Email Reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=237531)

Domenico

04-21-2011 08:21 AM

I get the following error when running the cron:

Code:

Database error in vBulletin 4.1.3:



Invalid SQL:

SELECT * FROM user

                   WHERE lastactivity < '1298193385' AND

                   emailDate < '1300785385' AND emailCount < '1' AND options & 16 AND usergroupid IN ('2') LIMIT 0, 3;



MySQL Error   : Unknown column 'emailDate' in 'where clause'

Error Number  : 1054

And when I want to reset the reminders I get this:

Code:

Database error in vBulletin 4.1.3:



Invalid SQL:

UPDATE user 

            SET emailDate = '0', 

                emailCount = '0';



MySQL Error   : Unknown column 'emailDate' in 'field list'

Error Number  : 1054

EDIT: Nevermind!
I figured out this had something to do with the old install (after reading the thread) so I completely uninstalled and installed again and now it's working.

TalkVirginia

04-21-2011 11:32 AM

Quote:

Originally Posted by Domenico (Post 2186930)

I get the following error when running the cron:

Code:

Database error in vBulletin 4.1.3:



Invalid SQL:

SELECT * FROM user

                   WHERE lastactivity < '1298193385' AND

                   emailDate < '1300785385' AND emailCount < '1' AND options & 16 AND usergroupid IN ('2') LIMIT 0, 3;



MySQL Error   : Unknown column 'emailDate' in 'where clause'

Error Number  : 1054

And when I want to reset the reminders I get this:

Code:

Database error in vBulletin 4.1.3:



Invalid SQL:

UPDATE user 

            SET emailDate = '0', 

                emailCount = '0';



MySQL Error   : Unknown column 'emailDate' in 'field list'

Error Number  : 1054

EDIT: Nevermind!
I figured out this had something to do with the old install (after reading the thread) so I completely uninstalled and installed again and now it's working.

Good Good! Glad to hear you were able to get it working. :)

TalkVirginia

04-21-2011 11:39 AM

Quote:

Originally Posted by ifitsmedia (Post 2184353)

Any luck on finding the "blank sender" issue? I would love to use this mod but I'm holding off until that gets solved. Thanks for the help!

I believe I should be able to release a fix for this and a few other issues in the next week. I've also reworked some of the logic for when reminders are sent out as well as a new reminder template manager.

I am working on adding the email bounce detection and I received the ok to reuse code from a couple addon's that some of you have PM'd me about. It's taking a bit longer to work that into the mix, but I believe it will be good once it gets in there.

Alan_SP

04-21-2011 11:50 PM

Excellent, I'm waiting for new version to start using your mod. :)

ifitsmedia

04-22-2011 08:11 AM

Fantastic, thanks for the update. Looking forward to the fixes. Cheers!

Gene Steinberg

05-03-2011 05:35 PM

Quote:

Originally Posted by TalkVirginia (Post 2186980)

Thank you. The problem with us is the fact that the ability to opt-out of the mailings is non-functional. I've had to make excuses, but we could get into trouble with that, because of CAN-SPAM requirements and such.

Peace,
Gene

HMBeaty

05-05-2011 03:24 AM

Tagged for now til a fix has been released. Also, could you make the option to receive the email as an on/off option in the AdminCP?

TalkVirginia

05-05-2011 03:58 PM

Quote:

Originally Posted by Gene Steinberg (Post 2191428)

Quote:

Originally Posted by HMBeaty (Post 2192024)

Tagged for now til a fix has been released. Also, could you make the option to receive the email as an on/off option in the AdminCP?

I have some time scheduled to work on these issues on Saturday, this weekend.

HMBeaty

05-07-2011 02:05 AM

Quote:

Originally Posted by TalkVirginia (Post 2192313)

I have some time scheduled to work on these issues on Saturday, this weekend.

Awesome! Thanks :)

TalkVirginia

05-08-2011 11:12 PM

Just a quick update before I head off to bed. :) I think I made some good progress on these fixes this weekend with it being Mother's day weekend. Will see how things go this week.

If something seems to not work with the addon or it's sending out too much reminders, please disable it until I can release a new version. I apologize for the inconvience. I'm specifically addressing the opt out issue right now.

Thanks again for your patience.

All times are GMT. The time now is 08:29 PM.

Page 35 of 71

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01621 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: