MySQL error 145 - but cant login to repair it

[joolsr]

Hi

I am receiving the following error :-

Error filling in additional detail fields: Query Failed:SELECT contacts.first_name, contacts.last_name, contacts.phone_work, contacts.email1, contacts.id , contacts.assigned_user_id contact_name_owner FROM contacts, meetings_contacts WHERE meetings_contacts.contact_id=contacts.id AND meetings_contacts.meeting_id='c54d1cd4-d391-7320-e219-4523fc333fa3' AND meetings_contacts.deleted=0 AND contacts.deleted=0::MySQL error 145: Table './sugarcrm/contacts' is marked as crashed and should be repaired

This is with Sugar 4.5.1 on a rpath Vmware image installation with all the latest updates, running on Win 2000

So ok, I need to do some magic and repair my MySQL table. But I get the error before I get to the Sugar login screen, so I can't log in as admin to repair the tables.

Apart from installing PHP/MyAdmin (if possible anyway via rPath), is there any other ways of fixing this with cmd line access only ?

Julian Robbins

[nathanbthomas]

I am definitely not sure how to fix the problem, but to get phpMyAdmin running you need to install it with conary like this:

1. log in as root (no password by default)
2. run: conary update phyMyAdmin --resolve
3. restart apache: 'service httpd restart"

Nathan