Did you check to make sure the mysqld process is running? Have you checked
the mysql logs for errors? If the mysqld process is running and your
Tickets table exists, it's possible the Tickets table is corrupted. Try a
repair table operation if so.
And like Ole stated, you need to provide a lot more information in order to
get help.
James Moseley
"Tamer Tayea"
<[EMAIL PROTECTED]
ytouch.com> To
Sent by: "Ole Craig"
rt-users-bounces@ <[EMAIL PROTECTED]>
lists.bestpractic cc
al.com RT-Users
<[email protected]>
Subject
08/16/2007 02:01 RE: [rt-users] Issue with RT system
PM
This server has been running for 3 years at least. Today , the server
wan hung , I had to reboot it ..
Since rebooting it , I am getting these errors. Yes, the backend is
mysql..
How I go about fixing this db issue ( I am not expert on DB)
Thanks
Tamer
-----Original Message-----
From: Ole Craig [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 16, 2007 2:59 PM
To: Tamer Tayea
Cc: RT-Users
Subject: RE: [rt-users] Issue with RT system
On Thu, 2007-08-16 at 14:31 -0400, Tamer Tayea wrote:
[...]
> [Thu Aug 16 14:52:36 2007] [crit]: Couldn't create a ticket: Internal
> Error: Couldn't execute the query 'INSERT INTO Tickets (Subject,
> Status, Queue, Creator, Owner, LastUpdatedBy, Started, Type, Starts,
> Resolved, Created, Priority, Due, LastUpdated) VALUES
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Can't open file:
> 'Tickets.MYI' (errno: 145)
> (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:590)
[...]
Tamer -
What are you actually running? "RT 3" covers years and years of
development; 3.6.4 (latest stable) is *worlds* away from RT 3.0. Also,
when asking for help on this list, you're more likely to get meaningful
responses if you list all the components -- and versions thereof --
you're using to run RT: host OS, webserver, database, and RT codebase
itself.
Anyway, this is a database problem. "Can't open file: 'Tickets.MYI'"
says to me that you're using a mysql backend, but the schema hasn't been
created. Is this a new install? Did you run the database initializer?
--
/Ole Craig
Security Engineer
Team lead, customer support
[EMAIL PROTECTED]
303-381-3824 direct
303-381-3802 support
303-381-3880 fax
www.stillsecure.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
