Mysqli statement execute error : Incorrect key file for table

Support & Bugs
1

Hi, i ran out of diskspace and got this message.
Im not that SQL pro, maybe someone can help me please?

Mysqli statement execute error : Incorrect key file for table ‘./db_xxx_stats/piwik_log_visit.MYI’; try to repair it

Go to Piwik
Login
Backtrace:

#0 /+++/public_html/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /+++/public_html/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /+++/public_html/libs/Zend/Db/Adapter/Abstract.php(755): Zend_Db_Adapter_Abstract->query(’???SELECT???..’, Array)
#3 /+++/public_html/core/ArchiveProcessing/Day.php(103): Zend_Db_Adapter_Abstract->fetchRow(’???SELECT???..’, Array)
#4 /+++/public_html/core/ArchiveProcessing/Day.php(41): Piwik_ArchiveProcessing_Day->isThereSomeVisits()
#5/+++/public_html/core/ArchiveProcessing.php(473): Piwik_ArchiveProcessing_Day->compute()
#6 /+++/public_html/core/Archive/Single.php(226): Piwik_ArchiveProcessing->launchArchiving()
#7 /+++/public_html/core/Archive/Array/IndexedBySite.php(192): Piwik_Archive_Single->prepareArchive()
#8 /+++/public_html/core/Archive/Array/IndexedBySite.php(131): Piwik_Archive_Array_IndexedBySite->getArchiveIdsAfterLaunching(Array)
#9 /+++/public_html/core/Archive/Array/IndexedBySite.php(108): Piwik_Archive_Array_IndexedBySite->loadValuesFromDB(Array)
#10 /+++/public_html/core/Archive/Array/IndexedBySite.php(73): Piwik_Archive_Array_IndexedBySite->getValues(Array)
#11 /+++/public_html/plugins/MultiSites/API.php(184): Piwik_Archive_Array_IndexedBySite->getDataTableFromNumeric(Array)
#12 /+++/public_html/plugins/MultiSites/API.php(104): Piwik_MultiSites_API->buildDataTable(‘all’, ‘day’, ‘2012-09-06’, false, false, false)
#13 /+++/public_html/plugins/MultiSites/Controller.php(65): Piwik_MultiSites_API->getAll(‘day’, ‘2012-09-06’, false)
#14 /+++/public_html/plugins/MultiSites/Controller.php(37): Piwik_MultiSites_Controller->getSitesInfo(Object(Piwik_View))
#15 [internal function]: Piwik_MultiSites_Controller->index()
#16 /+++/public_html/core/FrontController.php(138): call_user_func_array(Array, Array)
#17/+++/public_html/index.php(53): Piwik_FrontController->dispatch()
#18 {main}

2

with phpmyadmin, run the query on your Database:


REPAIR TABLE piwik_log_visit

and it should work again

3

THX Matt, im back in business.

But now i can only see the header of Piwik, no data.

http://www.it-tf.de/it-tf/piwik.jpg

4

any error in the server error log file ?

5

No error msg!

6

If you use Firebug in firefox, do you see any requests not loading in the NET panel ?

7

it looks like this…

http://www.it-tf.de/it-tf/piwik2.jpg

8

And now i get this message in my apache error log:

[Thu Sep 13 05:19:07 2012] [warn] mod_fcgid: stderr: PHP Warning: sprintf() [function.sprintf]: Too few arguments in /home/xxx/domains/stats.xxx/public_html/core/Tracker/Db/Mysqli.php on line 264
[Thu Sep 13 05:19:07 2012] [warn] mod_fcgid: stderr: PHP Warning: mysqli_query() [function.mysqli-query]: Empty query in /home/xxx/domains/stats.xxx/public_html/core/Tracker/Db/Mysqli.php on line 130

9

the requests seem to be redirected 302 - is that normal ? Maybe it is causing this issue ?

10

don´t think so.

Piwik was runing with that setting for about 2 years without any problem.