First Oracle Experiences: not bad

Added by Mario Haupt over 9 years ago

Hello,
here my env:
redmine 0.6.4, ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32], Oracle 10 XE, ruby-oci8-1.0.0-mswin32.rb installed,
The installation of sql-scriptes runs well.

#1
Error in login form:

Processing WelcomeController#index (for 146.142.45.188 at 2008-03-24 15:49:19) [GET]
Session ID: a2b8e8fa0e7083e4f825cafee9ecbbdf
Parameters: {"action"=>"index", "controller"=>"welcome"}

After disabling check constraints on table USERS it works. Redmine inserts an anonymous user. I could not found other problems.

#2
trying some other functions I got the following Errors:

undefined method `each_key' for empty_clob()
undefined method `store' for empty_clob()

*After installing oracle_adapter.rb from
http://dev.rubyonrails.org/browser/trunk/activerecord/lib/active_record/connection_adapters/oracle_adapter.rb?rev=6388

into c:\redmine\vendor\rails\activerecord\lib\active_record\connection_adapters\oracle_adapter.rb
this problems seems to be resolved.*

The only one problem I just have is saving the account data from user "admin":

NoMethodError in MyController#account

undefined method `store' for "empty_clob()":String

But I do not care about this why this doesn't happens with other accounts (also with administrator role)
At this time I couldn't find any others problems.

regards Mario

Replies (3)

RE: First Oracle Experiences: not bad - Added by Mario Haupt over 9 years ago

Opening a news-entry I got the following problem:

NoMethodError in News#show
Showing app/views/news/show.rhtml where line #20 raised:

undefined method `empty?' for nil:NilClass

RE: First Oracle Experiences: not bad - Added by Jean-Philippe Lang over 9 years ago

The only one problem I just have is saving the account data from user admin

You get this error because this account was created before you apply the patch to the oracle adapter.
To fix this you can simply delete the row in user_preferences that correspond to this user. It will be recreated automatically.

NoMethodError in News#show

You can replace .empty? by .blank? to fix this (change committed in r1307).

RE: First Oracle Experiences: not bad - Added by Mario Haupt over 9 years ago

Hello,
first problem is solved.

regarding the other one:
after applying the patch I get the next error
Showing app/views/news/show.rhtml where line #45 raised:

undefined method `any?' for nil:NilClass

Extracted source (around line #45):

42:     </div>
43:     <h4><%= authoring comment.created_on, comment.author %></h4>
44:     <%= textilizable(comment.comments) %>
45: <% end if @comments.any? %>
46: </div>
47: 
48: <% if authorize_for 'news', 'add_comment' %>

RAILS_ROOT: ./script/../config/..

(1-3/3)