Extend field size of "email addresses to notify" field?

[davekeats]

Please help!!

I have a small community for my neighborhood that I maintain. Many of the members are looking for Yahoo Groups functionality, where members are notified of any and all posts made to the vBulletin. Additionally, most will only register on the site; I don't expect that they will subscribe themselves to any forums. I will likely have less than 200 members maximum at any point. In the forum manager, the "Email Addresses to Notify When there is a New Post" supports just 40 or so characters. Is there a SQL statement I could use that would increase the size of the field in the DB, or change it to a "memo" field or a type that would support approx 10,000 characters?

I'm still pretty new to vb, but think this built-in functionality would be great.

Thanks for any and all help and have a great Holiday!!!

Dave

[Marco van Herwaarden]

Your members should just subscribe to the thread/forum. What you are trying to use now is intended for a staff member to be notified.

[davekeats]

I know, but I cannot get the members to subscribe. That's why I wanted to make this modification. Do you know how it's done?

[Marco van Herwaarden]

Why would you want them to subscribe? Isn't that something each member should decde for himself? Forcing them to receive notifications would be considered spamming in many countries.

[davekeats]

I understand, but this is what the group is asking for. We are migrating from a Yahoo Groups list, where every member receives notification of every post made.

[Marco van Herwaarden]

They can set it as preference in their User Options.

[Zachery]

I would suggest using some sort of mailing list to notifiy staff members.,

[davekeats]

Hi Zach and Marco - I know it sounds crazy, but all the members want to be notified of the posting of all new posts -- new threads and replies. They're all new to vBulletin, and I don't expect they will be proactive in setting this up in their user options. I know there's a way to increase the field size of this field in the forum settings, but I can't find it here at Vb.org. Any ideas?

[Zachery]

Setup a global mailing list then, put the email address to be notified as the main list for each forum and allow your members to subscribe to the list.

[davekeats]

Unfortunately, I don't have a hosting account that will allow for this.. I did read the following from another thread here...

"You would need to change the newpostemail column in the forum table. Run the following query:

ALTER TABLE forum CHANGE COLUMN `newpostemail` `newpostemail` mediumtext NOT NULL;"

Seems pretty straightforward, but the "newpostemail" field no longer seems to exist in VB 3.6.x

Argh!!