I"m a new Piwik user and have yesterday installed stats for a web site on my server. Piwik successfully shows me “Visitors in real time”, but several of the other views show an error:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘piwik_xxarchive_numeric_2011_05’ already exists.
This particular error shows in Last Visits graph, List of Keywords, and Visits by server time.
For Visitor Countries, Lists of External Websites, Visitor Websites, and Best Search Engines, I get “No data to report”.
Any thoughts on this or resources I could look for answers?