DB Error # 144

docebo

I have installed osTicket (v1.6 ST) in November 2010; osTicket worked very well until this morning.

I can't access the open tickets and closed tickets. The log system gives me always the same error: "DB Error # 144" and two types of alert:

Alert message 1 ------------------------------------------------

Table '. / NAME DB / ost_ticket_lock' is marked as crashed and last (automatic?) repair failed

--------------------------------------------------

Alert message 2 ------------------------------------------------

Table '. / NAME DB / ost_ticket_lock' is marked as crashed and last (automatic?) repair failed ... "

--------------------------------------------------

Now the system is blocked. Any ideas?

What is the message: "DB Error # 144"?

Can I repair the DB?

Thanks,

Raffaele

Kelli

Sounds like your database has become corrupted.

Here's some info on how to fix it: http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html(http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html)

phpMyAdmin also has some built-in repair tools, if you have access to that.

Your web host may also be able to assist you or have a backup they could restore from.

docebo

Sounds like your database has become corrupted.
.....

Hi Kelli,

thank you very much for the suggestions. I followed your tips and I repaired the table and now osTicket works again and I recovered all my data.

But some ideas about the error? What stands for "DB Error # 144"?

Thanks again from Italy.

Raffaele