Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Uncaught exception: 'Column nb_visits already in the array!' #5560

Closed
anonymous-matomo-user opened this issue Mar 12, 2008 · 3 comments
Closed
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously.
Milestone

Comments

@anonymous-matomo-user
Copy link

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:

```

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

mattab commented Mar 14, 2008

reporter says the bug is because he modified the database

@anonymous-matomo-user
Copy link
Author

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
Copy link
Member

mattab commented Mar 19, 2008

see #5566

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Development

No branches or pull requests

2 participants