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

Manage Goals broken in 3.0.1 #11327

Closed
tipmaster opened this issue Feb 8, 2017 · 6 comments
Closed

Manage Goals broken in 3.0.1 #11327

tipmaster opened this issue Feb 8, 2017 · 6 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@tipmaster
Copy link

Getting the following error:

The following error just broke Piwik (v3.0.1):

Key "description" for array with keys "idsite, idgoal, name, match_attribute, pattern, pattern_type, case_sensitive, allow_multiple, revenue, deleted" does not exist in "@Goals/_listGoalEdit.twig" at line 51
in
/mgmt/piwik/3_0/piwik/vendor/twig/twig/lib/Twig/Template.php line 501

Any help?

@JimmyKuruvilla
Copy link

JimmyKuruvilla commented Feb 10, 2017

Getting the same thing after an upgrade to 3.0 from 2.17.1:

image

Overview of goals and viewing individual goals works fine.

@tipmaster
Copy link
Author

tipmaster commented Feb 10, 2017

I got this response from support which fixed the issue for me:

To answer your question: We haven't seen this error in Piwik 3 before. It sounds like there is a column "description" in the "piwik_goal" MySQL table missing. Can you or your system administrator execute this MySQL query and check if it works afterwards:

Solution: run this SQL query

ALTER TABLE piwik_goal ADD `description` VARCHAR(255) NOT NULL DEFAULT '';

@JimmyKuruvilla
Copy link

JimmyKuruvilla commented Feb 10, 2017

@tipmaster thanks, that was definitely the problem. I guess the db upgrade missed a step (or maybe skipping a piwik version skipped a db migration).

@pgerstbach
Copy link

I had the same issue, now it works after altering the table, thanks @tipmaster !

@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Feb 20, 2017
@DevDaveo
Copy link

+1
Having the same fatal error message too!

@sbuchali
Copy link

We had the same error.

Piwik just told the administrator:

oops, an error occured ... contact your administrator

Nothing more. Only a 500 error in the access.log, but no more specific error message.

The solution posted by @tipmaster did also solve the problem for us. It seems that goals that were created in Piwik 2.x did not have the "description" column yet, which causes the error in 3.x

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

6 participants