1.5 error SQLSTATE[42S01]

Juc1 · July 3, 2011, 11:42am

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 · July 3, 2011, 12:52pm

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

Juc1 · July 3, 2011, 1:01pm

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

Thank you

vipsoft · July 3, 2011, 9:15pm

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

Juc1 · July 16, 2011, 3:50pm

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 · July 16, 2011, 5:55pm

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