[rt-users] Issue with RT system

[Tamer Tayea]

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:ocraig at stillsecure.com] 
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

ocraig at stillsecure.com
303-381-3824 direct
303-381-3802 support
303-381-3880 fax

www.stillsecure.com