Column not found: 1054 Unknown column 'log_conversion_item' in 'field list'

[ryrun]

I'm using a segment and got following error on ecommerce report page:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'log_conversion_item' in 'field list'

Segment do following:

"All visitors with ecommerce state ordered and accomplish a specific goal."

Dashboard is working fine. Visitors and Goals/Ecommerce showing this SQL error. Referers have no data. It seems that this error only happen when timeframe is bigger than 1 day. (Week/Month/Year)
Keywords: segements, ecommerce, piwik2.1.0

[mattab]

Can you please post exact URL used when seeing the error (especially the &segment= parameter)

[ryrun]

Here thr url:

/index.php?module=CoreHome&action=index&date=2014-03-06&period=year&idSite=1&segment=visitEcommerceStatus%3D%3Dordered%3BvisitConvertedGoalId%3D%3D3#module=Goals&action=ecommerceReport&date=2014-03-06&period=year&idSite=2&idGoal=ecommerceOrder&segment=visitEcommerceStatus%3D%3Dordered%3BvisitConvertedGoalId%3D%3D3

It seems, when i swap the order of the statements, then it works:

/index.php?module=CoreHome&action=index&date=2013-03-08&period=year&idSite=1&segment=visitConvertedGoalId%3D%3D3%3BvisitEcommerceStatus%3D%3Dordered#module=Goals&action=ecommerceReport&date=2013-03-08&period=year&idSite=2&idGoal=ecommerceOrder&segment=visitConvertedGoalId%3D%3D3%3BvisitEcommerceStatus%3D%3Dordered

[mattab]

In b65ad76: Refs #4828 Adding integration test replicating the SQL error

[mattab]

In ed3f588: Fixes #4828 no comment

[mattab]

In 80520d0: refs #4828 commmitting test files