We can't log into our SugarCRM after a system crash due to the following error message:
Query Failed:SELECT tracker.* from tracker WHERE user_id='45f52fb7-fa38-200a-6382-4408ece70642' ORDER BY id DESC LIMIT 0,10::MySQL error 145: Table '.\sugarcrm\tracker' is marked as crashed and should be repaired
This is what phpMyAdmin says when I look at the tracker table:
#145 - Table '.\sugarcrm\tracker' is marked as crashed and should be repaired
Windows XP Pro SP2
SugarCRM 4.5.0 open source (not sure which rev as I can't log in to check)
php version: 4.4.1
MySQL Version: 5.0.18
This is a basic XAMPP install and has been working fine for about 1.5 years.
I know nothing about MySQL databases or how to repair them.
Is this fatal?
I'm assuming that if my database can't be easily repaired that all of my data is still in there and can be exported?
System crash started after updating a few MS security updates and IE7 install. (I know, I know...)
Any help is greatly appreciated!