Also make sure that /var (or where ever MySQL is installed) is not mounted read-only.
-Sean -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Moseley Sent: Thursday, August 16, 2007 3:12 PM To: Tamer Tayea Cc: RT-Users Subject: RE: [rt-users] Issue with RT system 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 This email (including any attachments) is for its intended-recipient's use only. This email may contain information that is confidential or privileged. If you received this email in error, please immediately advise the sender by replying to this email and then delete this message from your system. For further information and disclaimers that apply to this email, see [http://www.viacom.com/email_disclaimer.jhtml]. _______________________________________________ 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
