Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
ryrun opened this issue Mar 7, 2014 · 5 comments
Closed
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@ryrun
Copy link

ryrun commented Mar 7, 2014

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
Copy link
Member

mattab commented Mar 9, 2014

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

@ryrun
Copy link
Author

ryrun commented Mar 10, 2014

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
Copy link
Member

mattab commented Mar 27, 2014

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

@mattab
Copy link
Member

mattab commented Mar 27, 2014

In ed3f588: Fixes #4828 no comment

@mattab
Copy link
Member

mattab commented Mar 27, 2014

In 80520d0: refs #4828 commmitting test files

@ryrun ryrun added this to the 2.2.1 - Piwik 2.2.1 milestone Jul 8, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

No branches or pull requests

2 participants