1.8.4 archive.php - SQLSTATE[42S22]: Column not found: 1054 Unknown column '-1' in 'field list'

Support & Bugs
21

Hi matt,

i patched my 1.9 piwik with the changes from SVN http://dev.piwik.org/trac/changeset/7293 . Archiving is working, but the problem with the Transitions plugin still remains:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ’ ’ in ‘field list’

Any clue on this?

Thanks!

22

There is a new patch, check it on the ticket, it should work then?

23

Hi matt,

yes it’s working now, thanks a lot!

Maybe there are other places in piwik where we need a fix for the ANSI_SQL mode, too?

24

tsfoer, it’s possible, if you find more errors please create a ticket

please update to 1.9.1 where this bug has been fixed! Changelog Archive - Analytics Platform - Matomo

25

Hi matt,

1.9.1 is working fine!
I’ll help improving piwik by opening tickets if i will find another problem of course :slight_smile: