DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 3 123 Last
Results 1 to 10 of 27

Thread: Reset newsletter to start scanning again from user #1


Forum: DragonByte Newsletter Professional Support

Questions & Answers for DragonByte Newsletter.

  1. #1
    Member
    Level 0 (1,000 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Posts
    62
    Rep Power
    8

    Question Reset newsletter to start scanning again from user #1

    Wer have currently disabled the cron job (scheduled task).

    The owner wants to restart the newsletter to begin mail-outs Wednesday morning.

    What would I need to reset to ensure that when we restart the newsletter it begins again at the top of the memberlist?
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  2. #2
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,743
    Blog Entries
    13
    Rep Power
    10

    Default

    Run a query like this:
    Code:
    UPDATE user SET dbtech_newsletter_lastreceive = 0
    Remember to add your table prefix if you use one
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  3. #3
    Member
    Level 0 (1,000 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Posts
    62
    Rep Power
    8

    Default

    That didn't work.

    I want to restart the sending from user #1 on the forum. I ran the query and when it restarted it sent out newsletters but it didn't start from user #1. I assumed it started from wherever it left off the last time it ran.,
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  4. #4
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,743
    Blog Entries
    13
    Rep Power
    10

    Default

    That query does work, it sends the newsletter to the first user in your database that has not unsubscribed. The column you updated is the only measure for whether someone has previously received the newsletter.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  5. #5
    Member
    Level 0 (1,000 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Posts
    62
    Rep Power
    8

    Default

    But it's not a large member list and it took a good 17 hours until user #1 received the newsletter.

    How does the scheduled task know where to start if it's been disabled for a while and then is enabled again? Is there a way to reset the marker for the scheduled task back to #1?
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  6. #6
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,743
    Blog Entries
    13
    Rep Power
    10

    Default

    Quote Originally Posted by djbaxter View Post
    How does the scheduled task know where to start if it's been disabled for a while and then is enabled again?
    The scheduled task selects 250 users that have not received the list for a week (or whatever you changed the interval to), ordered by User ID in ascending order.

    Quote Originally Posted by djbaxter View Post
    Is there a way to reset the marker for the scheduled task back to #1?
    The query I posted above is the method for that.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  7. #7
    Member
    Level 0 (1,000 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Posts
    62
    Rep Power
    8

    Default

    Okay. Thank you. I guess I need to look elsewhere for the "bottleneck", e.g., vBulletin mail settings.
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  8. #8
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,743
    Blog Entries
    13
    Rep Power
    10

    Default

    Quote Originally Posted by djbaxter View Post
    Okay. Thank you. I guess I need to look elsewhere for the "bottleneck", e.g., vBulletin mail settings.
    Ah yeah, I didn't think to mention that - this mod uses vBulletin's mail queue system, so if your forum has low activity (so the scheduled task doesn't get processed often) or the mails per cron run is set very low (I think by default it's set at 10), then that could be a cause for delay.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  9. #9
    Member
    Level 0 (1,000 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Jun 2010
    Posts
    62
    Rep Power
    8

    Default

    Does it use the vBulletin mail queue system even if that is turned off in the vBulletin email settings?

    Or does this product REQUIRE that the vBulletin mail system be turned on?
    0 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

  10. #10
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,743
    Blog Entries
    13
    Rep Power
    10

    Default

    This mod respects whatever your settings are. We use the standard vbmail() function for sending email, which does its own thing based on your vBulletin settings.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    1 0 0
     
    Reset newsletter to start scanning again from user #1 Send PM  

Page 1 of 3 123 Last

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.