FATAL ERROR

[Leandro Noferini]

I get this error in my semanticscuttle working on debian stable with mysql 5.1.66

Errore interpretazione XML: errore di sintassi
Indirizzo: https://bbs.cybervalley.org/semanticscuttle/
Riga numero 2, colonna 1:

Fatal error: <u>SQL ERROR</u> [ mysql4 ]<br /><br />Incorrect key file for table '/tmp/#sql_bcf_0.MYI'; try to repair it<br /><br /><u>CALLING PAGE</u><br /><br />/semanticscuttle/index.php&amp;<br /><br /><u>SQL</u><br /><br />SELECT DISTINCT SQL_CALC_FOUND_ROWS B.*, U.username, U.name FROM sc_users AS U, sc_bookmarks AS B WHERE B.uId = U.uId AND B.bStatus = 0 GROUP BY B.bHash ORDER BY B.bModified DESC 
^

It worked well for many months

[Leandro Noferini]

Sorry for the italian text. In english is:

Error interpreting XML: syntax error
Address: https://bbs.cybervalley.org/semanticscuttle/
Row number 2, column 1:

[Christian Weiske]

Disable debug mode. The XML errors should not occur then.

Also, did you try to repair your mysql database table? Look at the source of the HTML file (with debug mode enabled) to see the error.

[Leandro Noferini]

I found I have the mysql table in corrupt

This is the error:

Fatal error: <u>SQL ERROR</u> [ mysql4 ]<br /><br />Incorrect key file for table '/tmp/#sql_bcf_0.MYI'; try to repair it<br /><br /><u>CALLING PAGE</u><br /><br />/semanticscuttle/index.php&amp;<br /><br /><u>SQL</u><br /><br />SELECT DISTINCT SQL_CALC_FOUND_ROWS B.*, U.username, U.name FROM sc_users AS U, sc_bookmarks AS B WHERE B.uId = U.uId AND B.bStatus = 0 GROUP BY B.bHash ORDER BY B.bModified DESC LIMIT 10<br /> in /var/www/semanticscuttle/src/SemanticScuttle/db/mysql4.php on line 390

Could you help me to correct?

[Christian Weiske]

Your database has been corrupted. You need to repair it. Search the internet for help about that topic.