[Piwik-hackers] MAX_JOIN_SIZE error

[Суслов Кирилл]

Hello!

I`ve got that error message:

Uncaught exception: 'SQLSTATE[42000]: Syntax error or access violation: 
1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your 
WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the 
SELECT is okay'
More information

In /home/s/stat/public_html/libs/Zend/Db/Statement/Pdo.php on line 227
Backtrace:

#0 /home/s/suslovbe/stat/public_html/libs/Zend/Db/Statement.php(298): 
Zend_Db_Statement_Pdo->_execute(Array)
#1 
/home/s/suslovbe/stat/public_html/libs/Zend/Db/Adapter/Abstract.php(262): 
Zend_Db_Statement->execute(Array)
#2 
/home/s/suslovbe/stat/public_html/libs/Zend/Db/Adapter/Pdo/Abstract.php(206): 
Zend_Db_Adapter_Abstract->query('SELECT ?name,??...', Array)
#3 /home/s/suslovbe/stat/public_html/plugins/Actions/Actions.php(109): 
Zend_Db_Adapter_Pdo_Abstract->query('SELECT ?name,??...', Array)
#4 /home/s/suslovbe/stat/public_html/libs/Event/Dispatcher.php(280): 
Piwik_Actions->archiveDay(Object(Event_Notification))
#5 /home/s/suslovbe/stat/public_html/libs/Event/Dispatcher.php(250): 
Event_Dispatcher->postNotification(Array, Array)
#6 /home/s/suslovbe/stat/public_html/modules/PluginsManager.php(417): 
Event_Dispatcher->post(Object(Event_Notification), true, false)
#7 
/home/s/suslovbe/stat/public_html/modules/ArchiveProcessing/Day.php(69): 
Piwik_PostEvent()
#8 /home/s/suslovbe/stat/public_html/modules/ArchiveProcessing.php(237): 
Piwik_ArchiveProcessing_Day->compute(Object(Piwik_ArchiveProcessing_Day), 
'ArchiveProcessi...', Array, true, false)
#9 /home/s/suslovbe/stat/public_html/modules/Archive/Single.php(80): 
Piwik_ArchiveProcessing->loadArchive('ArchiveProcessi...', 
Object(Piwik_ArchiveProcessing_Day))
#10 /home/s/suslovbe/stat/public_html/modules/Archive/Single.php(117): 
Piwik_Archive_Single->prepareArchive()
#11 /home/s/suslovbe/stat/public_html/modules/Archive/Single.php(306): 
Piwik_Archive_Single->get()
#12 /home/s/suslovbe/stat/public_html/plugins/UserCountry/API.php(42): 
Piwik_Archive_Single->getDataTable()
#13 /home/s/suslovbe/stat/public_html/modules/API/Proxy.php(462): 
Piwik_UserCountry_API->getCountry('UserCountry_cou...', 'blob')
#14 [internal function]: Piwik_API_Proxy->__call('UserCountry_cou...')
#15 /home/s/suslovbe/stat/public_html/modules/API/Request.php(140): 
Piwik_API_Proxy->getCountry('7', 'day', '2008-02-28')
#16 /home/s/suslovbe/stat/public_html/modules/ViewDataTable.php(352): 
Piwik_API_Request->process(Array, Array)
#17 
/home/s/suslovbe/stat/public_html/modules/ViewDataTable/Html.php(45): 
Piwik_ViewDataTable->loadDataTableFromAPI('getCountry', Array)
#18 /home/s/suslovbe/stat/public_html/modules/Controller.php(43): 
Piwik_ViewDataTable_Html->main('7', 'day', '2008-02-28')
#19 
/home/s/suslovbe/stat/public_html/plugins/UserCountry/UserCountry.php(113): 
Piwik_Controller->renderView(Array, Array)
#20 /home/s/suslovbe/stat/public_html/modules/FrontController.php(120): 
Piwik_UserCountry_Controller->getCountry()
#21 /home/s/suslovbe/stat/public_html/index.php(61): 
Piwik_FrontController->dispatch()
#22 {main}


I don`t have access to MySQL setting on a server (its just a hosting, 
not a my own server), so what can i do thru phpmyadmin or?... :)