@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:

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

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 Owner

see #5566

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