Redmine

hello,

i've posted in wrong place, so i am pasting it here... (sorry for double posting)

hello,

i've installed RM on Oracle and currently testing it... (it's still not supported :( )

1. I have a problem with db compability...
2. i know where is the bug.
3. i am still not advanced in rails so i am looking for help...

4. in some places there are sql conditions like:

journals.notes <> ''

there is an easy solution - change it to:

tochar(journals.notes <> '')

i don't know how to force 'tochar' conversion on rails/db adapter ...

thank's for your help.

if you are interested in all stacktrace, here it is:

ActiveRecord::StatementInvalid (OCIError: ORA-00932: inconsistent datatypes: expected - got CLOB: SELECT journals.id AS t0_r0, journals.journalized_id AS t0_r1, journals.journalized_type AS t0_r2, journals.user_id AS t0_r3, journals.notes AS t0_r4, journals.created_on AS t0_r5, issues.id AS t1_r0, issues.tracker_id AS t1_r1, issues.project_id AS t1_r2, issues.subject AS t1_r3, issues.description AS t1_r4, issues.due_date AS t1_r5, issues.category_id AS t1_r6, issues.status_id AS t1_r7, issues.assigned_to_id AS t1_r8, issues.priority_id AS t1_r9, issues.fixed_version_id AS t1_r10, issues.author_id AS t1_r11, issues.lock_version AS t1_r12, issues.created_on AS t1_r13, issues.updated_on AS t1_r14, issues.start_date AS t1_r15, issues.done_ratio AS t1_r16, issues.estimated_hours AS t1_r17, projects.id AS t2_r0, projects.name AS t2_r1, projects.description AS t2_r2, projects.homepage AS t2_r3, projects.is_public AS t2_r4, projects.parent_id AS t2_r5, projects.projects_count AS t2_r6, projects.created_on AS t2_r7, projects.updated_on AS t2_r8, projects.identifier AS t2_r9, projects.status AS t2_r10, journal_details.id AS t3_r0, journal_details.journal_id AS t3_r1, journal_details.property AS t3_r2, journal_details.prop_key AS t3_r3, journal_details.old_value AS t3_r4, journal_details.value AS t3_r5, users.id AS t4_r0, users.login AS t4_r1, users.hashed_password AS t4_r2, users.firstname AS t4_r3, users.lastname AS t4_r4, users.mail AS t4_r5, users.mail_notification AS t4_r6, users.admin AS t4_r7, users.status AS t4_r8, users.last_login_on AS t4_r9, users.language AS t4_r10, users.auth_source_id AS t4_r11, users.created_on AS t4_r12, users.updated_on AS t4_r13, users.type AS t4_r14 FROM journals LEFT OUTER JOIN issues ON issues.id = journals.journalized_id LEFT OUTER JOIN projects ON projects.id = issues.project_id LEFT OUTER JOIN journal_details ON journal_details.journal_id = journals.id LEFT OUTER JOIN users ON users.id = journals.user_id WHERE (journals.journalized_type = 'Issue' AND (journal_details.prop_key = 'status_id' OR journals.notes <> '')) AND (1=1 AND (journals.created_on BETWEEN TO_DATE('2009-06-30','YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2009-07-30','YYYY-MM-DD HH24:MI:SS')) AND ((projects.id = 10000 OR projects.parent_id = 10000) AND (projects.status=1 AND EXISTS (SELECT em.id FROM enabled_modules em WHERE em.name='issue_tracking' AND em.project_id=projects.id)))) ):