vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Email Integration (New threads/replies by email) (https://vborg.vbsupport.ru/showthread.php?t=151222)

popmyzit 09-05-2007 07:59 AM

Hello,
getting Error Number: 1064 on new registrations

Invalid SQL:

REPLACE INTO vb_subscribeforum (userid, emailupdate, forumid)
VALUES (0, 1, );

database error.

Can someone help?
cheers

Cyricx 09-05-2007 11:36 AM

Quote:

Originally Posted by popmyzit (Post 1332723)
Hello,
getting Error Number: 1064 on new registrations

Invalid SQL:

REPLACE INTO vb_subscribeforum (userid, emailupdate, forumid)
VALUES (0, 1, );


database error.

Can someone help?
cheers

It would appear that in the usergroup manager you have autosubscribed turned on, but did not specify the forumids that the user should automatically be subscribed to.

popmyzit 09-05-2007 12:28 PM

Hello,
thanks for responding
I have actually put YES for subscribe and added a forumid in the field. I will double check this

however this may be happening despite that data in the fields... can anyone else check this?

thanks :)

popmyzit 09-05-2007 12:55 PM

Ok, i think it was trailing , comma in forum ids.

but now i am getting:

Warning: imap_open() [function.imap-open]: Couldn't open stream {localhost:110/pop3/notls}INBOX in /includes/cron/emailintegration.php on line 111

Warning: imap_headers(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 114

Warning: imap_close(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 1213

Done

any ideas? I think its the username what do you put there?

j14nsx 09-05-2007 05:36 PM

Apologies if my problem has already been answered. I have looked.

I have installed this mod, and it is working fine. However the emails I am receiving are not displaying as html. Other emails from other sender I can read as html, so it's not my Outlook 2007 setup.

I get text that looks like raw html.

Aside from this, works great!

USI_Garrett 09-11-2007 01:47 PM

Sorry if this is a basic question, but I can't quite figure it out. In the latest set of instructions, it says that I should import the product file "product-emailreplyint.xml". Where do I import it to? Is there there anything special I should use to import it (i.e. Impex)? Once again, sorry if this has already been addressed in the thread.

Thanks in advance.

USI_Garrett 09-11-2007 01:51 PM

Wow, nevermind. Figured it out. Looking forward to getting this mod up and running.

linnov 09-16-2007 10:33 PM

I have an automatted post in a forum I have this set on using the following code

Code:

<?

// chdir('./forums');
require_once('./global.php');
require_once('./includes/class_dm.php');
require_once('./includes/class_dm_threadpost.php');
require_once('./includes/functions_databuild.php');

$threaddm = new vB_DataManager_Thread_FirstPost($vbulletin, ERRTYPE_STANDARD);

$forumid = 209;
$postuserid = 3;
$userid = 3;
$username = 'linnov';
$pagetext = 'Testing 123 ';
$title = 'Test Post ';
$allowsmilie = '1';
$visible = '1';

$threadinfo = fetch_threadinfo($postthreadid);
$foruminfo = fetch_foruminfo($threadinfo['forumid']);

$threaddm->do_set('forumid', $forumid);
$threaddm->do_set('postuserid', $postuserid);
$threaddm->do_set('userid', $userid);
$threaddm->do_set('username', $username);
$threaddm->do_set('pagetext', $pagetext);
$threaddm->do_set('title', $title);
$threaddm->set('allowsmilie', $allowsmilie);
$threaddm->set('visible', $visible);
$threaddm->save();

build_forum_counters($forumid);

?>

The problem is the email is not generated so I'm thinking I need to call some other function within the script in order for the email to occurr

It does email if I create a new thread from within the forum.

Anyone have any ideas?

FleXy 09-17-2007 02:29 PM

great mod, but I can not find information how user can define himself by mail...
This plugin use email address to know "user login"? I mean "to know who wrote by mail" ?

If yes, it's not secure, because anybody can send letters from any email address. I mean i can send email from support @ microsoft [dot] com etc.
email is WRONG choose to define user. So it's loophole for spammers....

p.s. sorry for my english.

silurius 09-20-2007 04:54 PM

I think FleXy is referring to email spoofing?

At some point it would be great to see information about how best to bridge this with a Mailman listserv (perhaps adopting some of the development from the NNTP Gateway add-on) as well as with the vBulletin calendar and any event management add-ons related to that area.

But these are all bonuses, really. This is a great add-on, Chris. I expect this will greatly ease some of the phobias members of the particular community I'm working with, many of whom are technically and cognitively challenged, have about using internet applications. Even though my own work in this case is not-for-profit I still intend to paypal you when my site launches.


All times are GMT. The time now is 08:14 AM.

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