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
