if the site uses a database table prefix for its drupal database
a SQL error will occur when configuring views mail setting

actually it's caused by a small mistake in the SQL code
just use { } to hold all database table name,
i.e. {term_data} and {vocabulary} instead of term_data
and the problem is then solved

CommentFileSizeAuthor
#3 views_mail.module.5.x-2.0a.patch20.8 KBsomebodysysop

Comments

greg.harvey’s picture

greg.harvey
Primary language English
Location Occitanie, France
commented

Hi Ben,

I'm nothing to do with the project, but it seems a bit empty in here judging by the open issues - suggest you create and post a patch if you have time and know how to do it. =)

--
http://www.drupaler.co.uk/

zmove’s picture

zmove commented

/subscribe for a bracked query patch...

somebodysysop’s picture

somebodysysop commented
Status: Active » Needs review
StatusFileSize
new views_mail.module.5.x-2.0a.patch20.8 KB

This project had to go on the back burner for a while. Sorry. I'm back on it and trying to catch up. A bit more knowledgable as well, which will hopefully help.

I have created a patch for this issue, but can't seem to get it uploaded.

greg.harvey’s picture

greg.harvey
Primary language English
Location Occitanie, France
commented

Welcome back. Glad you're on it. It's a great project. =)

somebodysysop’s picture

somebodysysop commented
Status: Needs review » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.