• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Error while sending notification emails

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you please register this bug in your JIRA?

Thank you.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My /WEB-INF/config/database/oracle/oracle.sql already has the corrected code, and I'm getting the same error:

15:59:35,639 WARN [TopicsCommon ] Error while sending notification emails: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Invalid column name

JForum v2.1.7
tomcat v.0.28
Oracle v9.2.0.4
[originally posted on jforum.net by jenamon]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
A quick follow-up on this one.

The generic query has different logic than the Oracle one and I have successfully tested and removed the Oracle specific query as there is nothing Oracle specific about it.

I have also added this note to http://www.jforum.net/jira/browse/JF-603 and created a new issue http://www.jforum.net/jira/browse/JF-643.

Thanks,
E/.
[originally posted on jforum.net by ewise]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I notice that in the bug database, Rafael posted a contradiction to the suggested query change. So, what's the bottom line on this? Is there a quick fix or work-around to it?

Thanks,
Jennifer
[originally posted on jforum.net by jenamon]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic