@anonymous-piwik-user opened this issue on March 12th 2008

After 1 day of use, recording about 6000 entries in table 'piwik_archive_blob_2008_03', I get this error in every widget for yesterday view :

Uncaught exception: 'Column nb_visits already in the array!' More information In /home/ideeforc/sd/piwik/modules/DataTable/Row.php on line 270 Backtrace:

#0 /home/ideeforc/sd/piwik/plugins/Actions/Actions.php(257): Piwik_DataTable_Row->addColumn('nb_visits', '1')
#1 /home/ideeforc/sd/piwik/plugins/Actions/Actions.php(111): Piwik_Actions->updateActionsTableWithRowQuery(Object(Zend_Db_Statement_Pdo))
#2 [internal function]: Piwik_Actions->archiveDay(Object(Event_Notification))
#3 /home/ideeforc/sd/piwik/libs/Event/Dispatcher.php(280): call_user_func_array(Array, Array)
#4 /home/ideeforc/sd/piwik/libs/Event/Dispatcher.php(250): Event_Dispatcher->postNotification(Object(Event_Notification), true, false)
#5 /home/ideeforc/sd/piwik/modules/PluginsManager.php(422): Event_Dispatcher->post(Object(Piwik_ArchiveProcessing_Day), 'ArchiveProcessi...', Array, true, false)
#6 /home/ideeforc/sd/piwik/modules/ArchiveProcessing/Day.php(69): Piwik_PostEvent('ArchiveProcessi...', Object(Piwik_ArchiveProcessing_Day))
#7 /home/ideeforc/sd/piwik/modules/ArchiveProcessing.php(237): Piwik_ArchiveProcessing_Day->compute()
#8 /home/ideeforc/sd/piwik/modules/Archive/Single.php(80): Piwik_ArchiveProcessing->loadArchive()
#9 /home/ideeforc/sd/piwik/modules/ArchiveProcessing.php(386): Piwik_Archive_Single->prepareArchive()
#10 /home/ideeforc/sd/piwik/modules/ArchiveProcessing.php(233): Piwik_ArchiveProcessing->loadSubperiodsArchive()
#11 /home/ideeforc/sd/piwik/modules/Archive/Single.php(80): Piwik_ArchiveProcessing->loadArchive()
#12 /home/ideeforc/sd/piwik/modules/Archive/Single.php(117): Piwik_Archive_Single->prepareArchive()
#13 /home/ideeforc/sd/piwik/modules/Archive/Single.php(306): Piwik_Archive_Single->get('Referers_search...', 'blob')
#14 /home/ideeforc/sd/piwik/plugins/Referers/API.php(40): Piwik_Archive_Single->getDataTable('Referers_search...', NULL)
#15 /home/ideeforc/sd/piwik/plugins/Referers/API.php(53): Piwik_Referers_API->getDataTable('Referers_search...', '1', 'month', '2008-03-12')
#16 [internal function]: Piwik_Referers_API->getKeywords('1', 'month', '2008-03-12')
#17 /home/ideeforc/sd/piwik/modules/API/Proxy.php(462): call_user_func_array(Array, Array)
#18 [internal function]: Piwik_API_Proxy->__call('getKeywords', Array)
#19 [internal function]: Piwik_API_Proxy->getKeywords('1', 'month', '2008-03-12')
#20 /home/ideeforc/sd/piwik/modules/API/Request.php(140): call_user_func_array(Array, Array)
#21 /home/ideeforc/sd/piwik/modules/ViewDataTable.php(352): Piwik_API_Request->process()
#22 /home/ideeforc/sd/piwik/modules/ViewDataTable/Html.php(45): Piwik_ViewDataTable->loadDataTableFromAPI()
#23 /home/ideeforc/sd/piwik/modules/Controller.php(43): Piwik_ViewDataTable_Html->main()
#24 /home/ideeforc/sd/piwik/plugins/Referers/Controller.php(86): Piwik_Controller->renderView(Object(Piwik_ViewDataTable_Html), false)
#25 [internal function]: Piwik_Referers_Controller->getKeywords()
#26 /home/ideeforc/sd/piwik/modules/FrontController.php(120): call_user_func_array(Array, Array)
#27 /home/ideeforc/sd/piwik/index.php(62): Piwik_FrontController->dispatch()
#28 {main}
@mattab commented on March 14th 2008

reporter says the bug is because he modified the database

@anonymous-piwik-user commented on March 18th 2008

I get the exact same thing. I downloaded the latest version available on March 10th, but the same thing happens with trunk@2008-03-19, and I haven't made any modifications to the database.

@mattab commented on March 19th 2008

see #5566

This issue was closed on August 18th 2009
Powered by GitHub Issue Mirror