1.5 error SQLSTATE[42S01]


#1

Hi all,

I upgraded to 1.5. Everything was ok at first but now I am getting the same errors on two different installations / servers - either ‘There is no data for this report’ or

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘piwik_archive_numeric_2011_07’ already exists

[attachment 259 error1.jpg]

Any suggestions please?

Thank you


(vipsoft) #2

Use this file from trunk: http://dev.piwik.org/trac/export/4968/trunk/core/TablePartitioning.php core/TablePartitioning.php


#3

@ Anthon thanks for your reply. Sorry for being thick but what do I do with your php file?

Thank you


(vipsoft) #4

Replace the existing file in Piwik’s “core” folder.


#5

Hi Anthon

Since my original post piiwk has loaded ok = without the problem but if it happens again I will replace the file.

Thank you


(vipsoft) #6

The fix is included in 1.5.1. No need to manually update that with each Piwik release.