search

mheinzerling / jforum2

Automatically exported from code.google.com/p/jforum2
Other
0 stars 0 forks source link

Oracle TopicModel.topicPosters missing user_twitter column #57

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Install 2.3.5 to Oracle
2. Attempt to view a post

An error is shown, which is resolved by adding the "user_twitter" column to the 
select line of the "TopicModel.topicPosters" query (oracle.sql line 217).

Column potentially needs to be rolled out to other queries, this is the only 
error I have found so far.

What version of the product are you using? On what operating system,
database, and application server/servlet container?
* Product: JForum 2.3.5
* DB: Oracle

Original issue reported on code.google.com by C.M.A.Pa...@gmail.com on 20 May 2014 at 10:27

GoogleCodeExporter commented 9 years ago 
Two queries are related to the newly added column "user_twitter":
UserModel.update
TopicModel.topicPosters

The oralce.sql has duplicate TopicModel.topicPosters. So remove it should fix 
this.
commit in [r335]

Original comment by andow...@gmail.com on 6 Jul 2014 at 1:54