Unix Administration 101: Don't install otrs on your root partition. When /
is at 100%, swap is no longer writable, and bad things start to happen. See
below. Sorry to bother everyone.
:-)
Jake Covert
-----Original Message-----
From: Covert, Jake [mailto:jake.covert@eds.com]
Sent: Tuesday, April 22, 2003 11:00 AM
To: otrs@otrs.org
I only get this error when I zoom in on certain tickets. Here is more
detail from the /var/log/messages
========================================
Apr 22 10:58:21 OTRS-CGI-10[2441]:
[Error][Kernel::Modules::AgentZoom::Run][Line:158]: Got error 28 from table
handler, SQL: 'SELECT sa.id, st.tn, sa.a_from, sa.a_to, sa.a_cc,
sa.a_subject, sa.a_body, st.create_time_unix, st.tn, st.user_id,
st.ticket_state_id, st.ticket_priority_id, sa.create_time, stt.name as
sender_type, at.name as article_type, su.login, sl.name as lock_type,
sp.name as priority, tsd.name as state, sa.content_path, sq.name as queue,
st.create_time as ticket_create_time, sa.a_freekey1, sa.a_freetext1,
sa.a_freekey2, sa.a_freetext2, sa.a_freekey3, sa.a_freetext3, st.freekey1,
st.freekey2, st.freetext1, st.freetext2, st.customer_id, sq.group_id,
st.ticket_answered, sq.escalation_time, sa.a_content_type,
sa.incoming_time, st.until_time FROM article sa, ticket st,
article_sender_type stt, article_type at, system_user su, ticket_lock_type
sl, ticket_priority sp, ticket_state tsd, queue sq WHERE sa.ticket_id =
st.id AND sq.id = st.queue_id AND stt.id = sa.article_sender_type_id AND
at.
========================================
Thinking it must be mysql related now.
-----Original Message-----
From: Covert, Jake
Sent: Tuesday, April 22, 2003 8:00 AM
To: 'otrs@otrs.org'
I'm getting the following error and I'm not quite sure what it means.
I'm using the following
Redhat8
1.0.1
Any ideas?
[Tue Apr 22 08:07:44 2003] [error] [client 130.175.169.157] [Tue Apr 22
08:07:44 2003] index.pl: DBD::mysql::st fetchrow_hashref failed: fetch()
without execute() at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line
211., referer: http:///otrs/index.pl?Action=AgentMailbox
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
