vb.org Archive
Page 38 of 71 « First 283637 38 394048 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)

Merenguista 05-19-2011 07:51 PM
thanks man ..

TalkVirginia 05-19-2011 11:01 PM
You're very welcome! :)

ndut 05-20-2011 01:08 AM
installed, thank you

TalkVirginia 05-20-2011 10:33 AM
What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.

doopz 05-20-2011 10:52 AM
Quote:
Originally Posted by TalkVirginia (Post 2197935)
What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.
I personaly use SMTP as my mail servers are spread among several IP's causing less trouble from providers such as yahoo and hotmail who will block IP's when you're sending large amounts of mail.

But as for bounces I use a pop3 box.

doobiefillin 05-20-2011 01:09 PM
is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

PHP Code:
Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate = UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options & 16 AND usergroupid IN ('6','2','') AND rmoptout = 0 LIMIT 10;;

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 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number  : 1064
Request Date  : Friday, May 20th 2011 @ 01:30:51 AM
Error Date    : Friday, May 20th 2011 @ 01:30:51 AM
Script        : http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer      : http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version : 

TalkVirginia 05-20-2011 01:55 PM
1 Attachment(s)
Quote:
Originally Posted by doobiefillin (Post 2197979)
is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

PHP Code:
Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate = UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options & 16 AND usergroupid IN ('6','2','') AND rmoptout = 0 LIMIT 10;;

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 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number  : 1064
Request Date  : Friday, May 20th 2011 @ 01:30:51 AM
Error Date    : Friday, May 20th 2011 @ 01:30:51 AM
Script        : http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer      : http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version : 
Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.
PHP Code:
"SET rmEmailDate = UNIX_TIMESTAMP(), "; 
3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

gamerzhut 05-20-2011 04:07 PM
Installed & rated.

Thank you sir :)

TalkVirginia 05-21-2011 01:11 AM
Quote:
Originally Posted by gamerzhut (Post 2198039)
Installed & rated.

Thank you sir :)
...and thank YOU! :) Hopefully rated well. :up: ;)

gamerzhut 05-21-2011 03:44 AM
Quote:
Originally Posted by TalkVirginia (Post 2198218)
...and thank YOU! :) Hopefully rated well. :up: ;)
RATED ***** :)


All times are GMT. The time now is 03:48 PM.
Page 38 of 71 « First 283637 38 394048 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02162 seconds
  • Memory Usage 1,759KB
  • 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
  • (3)bbcode_php_printable
  • (4)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