HELP! crm has crashed - error msg inside

[Evenetworks]

now when going to the url of the crm front end i get the following msg and nothing else, it doesnt even ask for login

Query Failed:SELECT tracker.* from tracker WHERE user_id = '7ec9d68a-c71c-e807-de8b-4863ae40e742' AND visible = 1 ORDER BY id DESC LIMIT 0,10::MySQL error 145:

what can i do? what can i do? what can i do???

[andopes]

Hi Evenetworks

if you have phpMyAdmin run this query into SugarCRM database:

SELECT tracker.* from tracker WHERE user_id = '7ec9d68a-c71c-e807-de8b-4863ae40e742' AND visible = 1 ORDER BY id DESC LIMIT 0,10

Cheers

[roblaus]

This I found when googling for the error no:

--------------
The following error may occur with a MySQL database table:

Can't open file: 'TableName.MYD'. (errno: 145)

This error usually means the 'TableName' table has become corrupt. From our experience, it appears the error commonly affects a table used for storing sessions and may occur the webs site/database has used up all allocated disk space. Additional disk space will normally need to be allocated.

Also, run the following SQL query using phpMyAdmin:

REPAIR TABLE TableName

This will often fix the table.
------------

Try to restart your mysql server and then Sugar. Check whether there is any improvement.

rgds

[andopes]

Hi Evenetworks

Robert is right. This is the error related to corrupted table, so you can log in the database through phpMyAdmin and run the following SQL:

REPAIR TABLE tracker;
OPTIMIZE TABLE tracker;

Cheers

[philipw]

Hi I am now having a major issue, my sugar has totally crashed and I really need help.

Can anyone help? I a getting the following:-


Parse error: syntax error, unexpected $end in /home/sites/medi-lasersolutions.co.uk/public_html/crm/include/utils/user_utils.php(90) : eval()'d code on line 1

Warning: ini_set() [ref.outcontrol]: Cannot change zlib.output_compression - headers already sent in /home/sites/medi-lasersolutions.co.uk/public_html/crm/include/utils.php on line 2908

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/sites/medi-lasersolutions.co.uk/public_html/crm/include/utils/user_utils.php(90) : eval()'d code:1) in /home/sites/medi-lasersolutions.co.uk/public_html/crm/index.php on line 178

Warning: Cannot modify header information - headers already sent by (output started at /home/sites/medi-lasersolutions.co.uk/public_html/crm/include/utils/user_utils.php(90) : eval()'d code:1) in /home/sites/medi-lasersolutions.co.uk/public_html/crm/index.php on line 216


I really have no clue?? please help