I have upgraded to the new version and when I "view subscribed users" or "view unsubscrided users" the usernames a blank.
Will I have to recreate these mailing lists?

Just added a mailing list with everyone subscribed by default. Wrote and email sent it, received nothing. Also when I look at the "[View Subscribed Users]" all it shows is [Unsubscribe] instead of a username and it says there are 1,433 total entries.

Any ideas?

Thanks

Same here. It was working fine before the update.:confused:

I'll release an update today to address this.

Fillip

Great! Thanks Fillip. :D

vBMail v1.1.1
Feature: Unsubscribe stats on the Mailing List and Mail History pages
Feature: New Per-Mailing List permission for who can see Unsubscribe stats (default to off for all)
Fix: (Lite) Mail sending and viewing subscribed users will no longer fail due to incompatibility with a Pro-only feature
Fix: (vB4) Database errors for the early adopters of v1.1.0 who were hit with an incorrect installer file

Fillip

Still have these problems with the new update.

I uninstalled and installed it. The problem still exists!

Cheers

Michael

I forgot to mention, you need to edit and save each mailing list you had created prior to this problem arising in order for the fix to take effect.

Fillip

vBMail v1.1.2
Fix: Unsubscribe link will now properly allow for per-mail unsubscribe stats.

Fillip

tanks for this update!

Fillip please seriously consider adding this. No, actually please add this. This is a great mod but this feature would make it spectacularific!! :D

Does the bounce mail work on e-mail confirmation links and other stock vb features? Thanks

When a users email is removed from the mailing list and a PM is sent, can you nominate the account this is sent from? With Foromail it was hard coded to be UserID 1, took me a while to find the relevant code.

Not currently, no.

It will show to the end-user as coming from themselves.


Fillip

Ah smart :)

Can the newsletters be automatically generated like the way Foromail worked? You could just set some options and then schedule a recurring email once a week or whatever.

Not currently, it's one of the planned features for the future though.

Fillip

I'll keep an eye on this then, thank you for answering my questions. Tagged.

Will this mod include any forum details automatically.

New posts
New members
Polls
CMS content

You get the ideal, or do I have to add all those myself?

I was using Commbul but since the upgrade it stopped working for me.

It does not add any such details no, we plan to make Widget support for content like that as a Pro feature in the future :)


Fillip

Installed but guest users can view everything!! :(

Also, in the settings page of any mailing list does not appear the guest group...

How I can fix it?

(fresh install 1.1.2 version)

Thanks Fillip.

is it to possible to automatic email a post?

This is intended behaviour, so there's no fix :)

Not in the current version, no.


Fillip

Then, is there no way to have a mailing list "private" for certain groups?

I think it would be very interesting for many communities.

Thanks.

I believe there is, but I'll look into it for the next version :)
There's no ETA for the next version yet.


Fillip

Thanks Fllip.

Hi. I've installed this mod and when trying to ad a mailing list got this error:

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO vbdbtech_vbmail_mailinglist
(title, description, active, displayorder, ownerid, fromemail, external, permissions, bitfield)
VALUES
('Mailing List', 'A mailing list that notifies people of wonderous things.', '1', 10, 0, 'mail@mail.com', '0', 'a:14:{i:7;i:89;i:5;i:89;i:11;i:89;i:23;i:89;i:12; i:65;i:2;i:65;i:13;i:65;i:9;i:65;i:21;i:65;i:20;i: 65;i:6;i:89;i:25;i:89;i:10;i:65;i:19;i:65;}', 1);

MySQL Error : Unknown column 'external' in 'field list'
Error Number : 1054

Could you help me?

Run this query:

Fillip

Thanks fillip, that worked for the mailing list ad. But another problem came up. When trying to change one user email in the CP this MySQL error showed up:

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE vbuser SET
### Bitfield: vbuser.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = '<font color=#C8ABDE size=2><b>G6 Iniciado</b></font>',
customtitle = 0,
email = '********@live.com',
languageid = 0,
birthday_search = '****-**-**',
birthday = '**-**-***',
referrerid = 0,
joindate = 1220931960,
lastactivity = 1221240900,
lastpost = 0,
dbtech_vbmail_bounceflag = '0',
membergroupids = ''
WHERE userid = ******;

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'field list'
Error Number : 1054
Request Date : Monday, August 15th 2011 @ 12:00:27 AM
Error Date : Monday, August 15th 2011 @ 12:00:27 AM
Script :
Referrer :
IP Address : *********
Username : PedroEnf
Classname : vB_Database
MySQL Version : 5.5.15

Even when the plugin is disabled the error persists.


PS: Tested after the last plugin update

Are you using a 3rd party plugin manager? It looks like your product manager is incapable of correctly running install scripts :p

You might want to try a reinstall.


Fillip

And another one when editing the mailing list activating the Default Subscribed or creating one with Default subscribed field selected:

Database error in vBulletin 4.1.5:

Invalid SQL:

INSERT IGNORE INTO vbdbtech_vbmail_subscription
(userid, mailinglistid)
(
SELECT userid, 1 AS mailinglistid
FROM vbuser AS user
WHERE (
FIND_IN_SET(6, membergroupids)
OR usergroupid IN(6)
)
AND user.dbtech_vbmail_bounceflag = '0'
);

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Monday, August 15th 2011 @ 12:20:20 AM
Error Date : Monday, August 15th 2011 @ 12:20:21 AM
Script :
Referrer :

MySQL Version : 5.5.15


Too many errors in the plugin. I would like to try it before consider buying it but probably will unninstall it. Sorry :(

Never thought of that. yes i am. Let me disable it and try reinstall. I'll let you know in just a moment :D

Well, the mailing list problem is solved (but had exec that bd query for the 'external' column anyway), but the member email editing in CP remains :(

Well the problem isn't this mod - or you'd be seeing 5 pages of people complaining about this error.


Fillip

No doubt about that neither i said that :) Just asked for help and thank you for it :up:
Member email edit in CP solved.

But i have another question, isn't supposed to have all member in mailing list if selected in Default Subscribed option?

It wouldn't have, because of the aforementioned error. Delete the mailing list and re-create it, then it will work :)


Fillip

It worked :) Thanks

Having a problem with the Editor; I'm presuming that all controls should be showing when creating mail and not just two arrows, and I'm presuming that there may be a problem with my installation (I've disable all hacks except vbMail and still get the same result). Any pointers where to look next would be appreciated. Image attached shows what I'm seeing. Thanks in advance for any help.

Have you customised any templates? We've received no reports of similar issues appearing on 4.1.5 (and we're running it on DBTech as well), so I'm rather stumped...

Fillip