I don't know if it's a bug (at last can be useful for someone) but:
1- the forum doesn't send email notification for reply to post.
2- the error in log was
10:27:30,369 WARN [TopicsCommon ] Error while sending notification emails [notifyUsers Topics common]: net.jforum.exceptions.DatabaseException:
java.
sql.SQLException: Nome di colonna non valido (in english, I think " Column name not valid")
3- I have changed /WEB-INF/config/database/oracle/oracle.sql
from
[...]
TopicModel.notifyUsers = SELECT u.user_id AS user_id, u.username AS username, \
u.user_lang AS user_lang, u.user_email AS user_email
FROM jforum_topics_watch tw, jforum_users u \
WHERE tw.user_id = u.user_id AND \
tw.topic_id = ? \
AND tw.is_read = 1 \
AND u.user_id NOT IN ( ?, ? )
[...]
to
[...]
TopicModel.notifyUsers = SELECT u.user_id AS user_id, u.username AS username, \
u.user_lang AS user_lang, u.user_email AS user_email, u.user_notify_text AS user_notify_text \
FROM jforum_topics_watch tw, jforum_users u \
WHERE tw.user_id = u.user_id AND \
tw.topic_id = ? \
AND tw.is_read = 1 \
AND u.user_id NOT IN ( ?, ? )
[...]
and now works fine...
environment:
- jforum-2.1.7
-
Tomcat 4.1.31
- Oracle 8.1.7
[originally posted on jforum.net by giovanni]