I upgraded from OTRS 0.5 beta 8 to OTRS 1.0.1, including the PostgreSQL
upgrade script. PostMasterPOP3.pl is correctly fetching and inserting
messages from my mail server, but it's generating a traceback each time
there's a message to fetch:
DBD::Pg::st execute failed: ERROR: Relation "charset" does not exist
at /usr/local/otrs/Kernel/System/DB.pm line 192.
ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: freebsd Time: Thu Mar 6 18:20:02
2003
Message: ERROR: Relation "charset" does not exist, SQL: 'SELECT
ar.text0, sa.value0, sa.value1, ar.text1, ch.charset FROM
auto_response_type art, auto_response ar, queue_auto_response qar,
system_address sa, charset ch WHERE qar.queue_id = 2 AND art.id =
ar.type_id AND qar.auto_response_id = ar.id AND
ar.system_address_id = sa.id AND ar.charset_id = ch.id AND art.name
= 'auto reply''
Traceback (14773):
Module: Kernel::System::AutoResponse::AutoResponseGetByTypeQueueID
Line: 193
Module: Kernel::System::Ticket::Article::CreateArticle Line: 128
Module: Kernel::System::PostMaster::NewTicket::Run Line: 105
Module: Kernel::System::PostMaster::Run Line: 203
Module: main::FetchMail Line: 165
Module: /usr/local/otrs/bin/PostMasterPOP3.pl Line: 94
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/otrs/Kernel/System/DB.pm line 205.
DBD::Pg::st execute failed: ERROR: Relation "charset" does not exist
at /usr/local/otrs/Kernel/System/DB.pm line 192.
ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: freebsd Time: Thu Mar 6 18:20:02
2003
Message: ERROR: Relation "charset" does not exist, SQL: 'SELECT
ar.text0, sa.value0, sa.value1, ar.text1, ch.charset FROM
auto_response_type art, auto_response ar, queue_auto_response qar,
system_address sa, charset ch WHERE qar.queue_id = 5 AND art.id =
ar.type_id AND qar.auto_response_id = ar.id AND
ar.system_address_id = sa.id AND ar.charset_id = ch.id AND art.name
= 'auto follow up''
Traceback (14773):
Module: Kernel::System::AutoResponse::AutoResponseGetByTypeQueueID
Line: 193
Module: Kernel::System::Ticket::Article::CreateArticle Line: 128
Module: Kernel::System::PostMaster::FollowUp::Run Line: 70
Module: Kernel::System::PostMaster::Run Line: 177
Module: main::FetchMail Line: 165
Module: /usr/local/otrs/bin/PostMasterPOP3.pl Line: 94
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/otrs/Kernel/System/DB.pm line 205.
message 1/3 (otrs@mailbox.samurai.com)
New Ticket created!
TicketNumber: 2003030610000012
TicketID: 175
Priority: normal
State: new
CustomerID: RandyN5242@netscape.com
From: "Domain Hostmaster"
Hi Bryan, On Thu, Mar 06, 2003 at 06:39:35PM -0500, Bryan Fullerton wrote:
I upgraded from OTRS 0.5 beta 8 to OTRS 1.0.1, including the PostgreSQL upgrade script. PostMasterPOP3.pl is correctly fetching and inserting messages from my mail server, but it's generating a traceback each time there's a message to fetch:
DBD::Pg::st execute failed: ERROR: Relation "charset" does not exist at /usr/local/otrs/Kernel/System/DB.pm line 192. ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: freebsd Time: Thu Mar 6 18:20:02 2003 [...]
Is there something in in your charset table (select * from charset;)?
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
Hi Martin, On Thursday, March 6, 2003, at 06:57 PM, Martin Edenhofer wrote:
Is there something in in your charset table (select * from charset;)?
Apparently not. :) otrs=> select * from charset; ERROR: Relation "charset" does not exist I'm unsure why the DBUpdate-to-1.0.postgresql.sql script didn't create it - can I safely re-run that script? Bryan
Hi Bryan, On Thu, Mar 06, 2003 at 07:21:58PM -0500, Bryan Fullerton wrote:
Is there something in in your charset table (select * from charset;)?
Apparently not. :)
otrs=> select * from charset; ERROR: Relation "charset" does not exist
I'm unsure why the DBUpdate-to-1.0.postgresql.sql script didn't create it - can I safely re-run that script?
Yes. But I think the best way is to create/insert the charset this way: CREATE TABLE charset ( id serial, name varchar (200) NOT NULL, charset varchar (50) NOT NULL, comment varchar (250), valid_id smallint NOT NULL, create_time timestamp(0) NOT NULL, create_by integer NOT NULL, change_time timestamp(0) NOT NULL, change_by integer NOT NULL, PRIMARY KEY(id), UNIQUE (name) ); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Latin-1 (iso-8859-1)', 'iso-8859-1', 'Western European languages.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Latin-2 (iso-8859-2)', 'iso-8859-2', 'Slavic and Central European languages.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Latin-3 (iso-8859-3)', 'iso-8859-3', 'Esperanto, Galician, Maltese, and Turkish.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Latin-4 (iso-8859-4)', 'iso-8859-4', 'Estonian, Latvian, and Lithuanian.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic (iso-8859-5)', 'iso-8859-5', 'Bulgarian, Byelorussian, Macedonian, Russian, Serbian and Ukrainian.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Greek (iso-8859-7)', 'iso-8859-7', 'Modern monotonic Greek.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Unicode (UTF-8)', 'UTF-8', 'Unicode UTF-8', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic Charset (KOI8-R)', 'KOI8-R', 'Unicode UTF-8', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic Charset (Windows-1251)', 'Windows-1251', 'Windows-1251 - cp1251', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Turkish (iso-8859-9)', 'iso-8859-9', 'Turkish.', 1, 1, current_timestamp, 1, current_timestamp); INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Latin-15 (iso-8859-15)', 'iso-8859-15', 'Western European languages with euro.', 1, 1, current_timestamp, 1, current_timestamp);
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 6:47am up 18 days, 17:08, 6 users, load average: 0.13, 0.22, 0.23
participants (2)
-
Bryan Fullerton -
Martin Edenhofer