vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - Email Integration (New Threads/Replies by and through email!) (https://vborg.vbsupport.ru/showthread.php?t=169247)

Cyricx 01-31-2008 04:48 PM

Right on, remember to upload the new cron file too.

My 2.4 code made some query references to the slave database. I suspect that you have different settings then those running on 3.6 that have upgraded so far :)

Cyricx 01-31-2008 05:48 PM

Found the error in the cron file :)

New zip attached.

Mah bad... trying to help someone figure out a way to setup a system cron to run the file instead of waiting for vbulletin :)

popmyzit 01-31-2008 07:50 PM

Hey Cyricx,
just installed. thanks for the great work!!

Got error going to maintenance email area with mysql error:
Database error in vBulletin 3.7.0 Beta 4:
Code:

Invalid SQL:
SELECT title FROM vb_forum WHERE forumid =;

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          : Thursday, January 31st 2008 @ 03:43:59 PM
Script        : http://www.mysite.com/forum/admincp/admin_ei.php
Referrer      : http://www.mysite.com/forum/admincp/index.php?do=nav
IP Address    : -----
Username      : admin
Classname    : vB_Database
MySQL Version : 4.1.22-standard


Cyricx 01-31-2008 07:57 PM

Please go to your Usergroup Manager and be sure that you have entered in a forumid for the usergroups that you wish to enable auto subscriptions for.


In version 2.4 you could actually turn on auto subscription for a usergroup and not enter in the forumids. This would spiral to a few other errors such as the one you mentioned above :)

2.5 will not allow you to not enter in a forumid if you are turning on auto subscription. So I'm fairly certain that when you installed 2.4 that mistake was made. :)

I've put in a safety net to ensure that fumble isn't made with these versions going forward :)

popmyzit 01-31-2008 08:13 PM

Hello Cyricx,
also when registering I still get:


Database Error Database error
The Forum database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.mysite.com home page, then try to open another page.
* Click the Back button to try another link.

The www.mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

popmyzit 01-31-2008 08:14 PM

maybe i will try i reinstall, i was upgrading from a previous version... that may be the problem.

Update: Yes Updating was the problem. Make sure you uninstall, then reinstall fresh clean install. worked for me.

Cyricx 01-31-2008 08:22 PM

The most common problem people have from upgrading from the older versions like 2.3 is forgetting to reverse the file edits or to put in the new file edit in the class_mail.php file.

Please follow the instructions in the UPGRADE.txt file closely :)

Let me know if you have any other issues Popmyzit and I'll work to resolve them asap!

popmyzit 01-31-2008 09:24 PM

Everything is fine after installing everything fresh. I will be looking for any bugs when people start sending emails

thanks again!

snoopy5 02-08-2008 12:33 PM

Hi

I am very interested in this hack. I only need a slight modification. I would be willing to pay for this.

I need this mailinglist functionality depending on the usergroup. I do not want that every user can use this feature, only premium members and Moderators shall be allowed to use this feature.

Would that be possible?

Thanks in advance

P.S.: Where is the difference between this hack above and this one:

https://vborg.vbsupport.ru/showthread.php?t=151222

Rich 02-08-2008 12:46 PM

Isn't the potential for this to backup the mail server pretty high? This could essentially generate a lot of emails if the site is active. If i am incorrect, I apologize. I am just thinking of the mass email that this could generate in addition to the email the site already sends.


All times are GMT. The time now is 04:51 PM.

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.01314 seconds
  • Memory Usage 1,739KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)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