Summary: Posting new tickets result in Quotation Errors. When correcting them with a patch, the fetchrow method fails.
I did the following:
a) Install the Oracle 9 client.
b) Install Perl DBI and DBD::Oracle
c) Create an Oracle SQL Schema including triggers for the auto increment values, index names hat to be cut off (some where longer than 32 chars). The "session" table has to be renamed to "sessiondb" as "session" is a reserved word - we are not using an sql session database anyhow.
d) Create an own initial SQL file for feeding databases (you have to replace "&" with '||chr(38)||') so sqlplus will not complain any more. This also worked. I can put these two files (otrs-schema.oracle and initial_insert.oracle) on my server if there is interest for it.
After this I finally had the chance to log on ([EMAIL PROTECTED]). I was able to create users and groups - it worked.
Problem: I can't open a ticket. The result is shown in
<http://pgienger.de/otrs/oci-error.png>
Look at the wrong quotation of the content-type. So I did this in the source code of Kernel/System/Ticket/Article.pm (not meant as a contribution, it is more like an instant patch to test):
# do db insert
$DBParam{ContentType} =~ s/\'//g;After this, there is a new error rising, shown in
<http://pgienger.de/otrs/oci-fetch-error.png>
Remarkably, the tickets get created! The proof is shown in
<http://pgienger.de/otrs/oci-ticket-created.png>
I am a little bit stuck because of the quotation error and because of the fetchrow error. The database type is "oracle", the communication works. I looked at the DB::Limit-Selector and I saw the Oracle definition which seems to be correct.
What's the next step to do? I am happy to contribute if I can.
I am using OTRS 1.2.3 on a Linux box. Perl version is 5.8.1. Database is:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production
Pascal
PS: Textual error messages are:
a) Quotation error:
Traceback: ERROR: OTRS-CGI-42 Perl: 5.8.1 OS: linux Time: Tue May 18 11:27:37 2004
Message: ORA-01756: quoted string not properly terminated (DBD ERROR: OCIStmtPrepare), SQL: 'INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (19, 5, 3, '[EMAIL PROTECTED]', '', 'Misc', '', 'This is a test ticket.', '', 'Test Test Test', 'text/plain'; charset=iso-8859-15', '2004/05/18', 1, 1084872457, current_timestamp, 1, current_timestamp, 1)'
Traceback (14372): Module: Kernel::System::Ticket::Article::CreateArticle (v1.52) Line: 83 Module: Kernel::Modules::AgentPhone::Run (v1.55.2.2) Line: 514 Module: Apache::ROOT::otrs::index_2epl::handler (v1.66) Line: 687 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149
b) fetchrow error:
Software error:
Can't call method "fetchrow_array" on an undefined value at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 438.
For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving this error message and the time and date of the error.
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
