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

Jump to bottom

'xxxx.piwik_user_language' doesn't exist #9708

Closed
stefan-niedermann opened this issue Feb 4, 2016 · 4 comments
Closed

'xxxx.piwik_user_language' doesn't exist #9708

stefan-niedermann opened this issue Feb 4, 2016 · 4 comments
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.
Milestone
2.16.1

Comments

@stefan-niedermann
Copy link

Tried to update to 2.16, getting following error:

/xxx/piwik/plugins/LanguagesManager/Updates/2.15.1-b1.php: Error trying to execute the query 'ALTER TABLE piwik_user_language ADD COLUMN use_12_hour_clock TINYINT(1) NOT NULL DEFAULT 0 AFTER language'. The error was: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx.piwik_user_language' doesn't exist

now i stuck at update-page - i can not go back, i can not go forward - what to do?
@tsteur
Copy link
Member

tsteur commented Feb 4, 2016

Marking this one as a duplicate of #9666

To solve it execute the SQL query mentioned here: #9666 (comment)

@tsteur tsteur closed this as completed Feb 4, 2016
@tsteur tsteur added the duplicate For issues that already existed in our issue tracker and were reported previously. label Feb 4, 2016
@tsteur tsteur added this to the 2.16.1 milestone Feb 4, 2016
@tsteur tsteur self-assigned this Feb 4, 2016
@tsteur tsteur mentioned this issue Feb 4, 2016
Closed
@Joey3000
Copy link
Contributor

Joey3000 commented Feb 5, 2016

I'm not sure that this is the same issue as #9666. Because the plugins/LanguagesManager/Updates/2.15.1-b1.php script does run here, and the whole user_language table appears to not exist here during its run.

I'm wondering where the "xxxx." pre-prefix comes from in 'xxxx.piwik_user_language'. (Unless it's normal for MySQL to prepend something on error reporting.)

@stefan-niedermann If this issue persists, could you please provide the following information:

  • How do you update? Could you provide a step-by-step test procedure to reproduce the issue?
  • Your PHP and MySQL version

@stefan-niedermann stefan-niedermann mentioned this issue Feb 5, 2016
Closed
@mattab mattab modified the milestones: 2.16.x, 2.16.1 Feb 6, 2016
@tsteur
Copy link
Member

tsteur commented Feb 7, 2016

Re the xxx it's only an assumption: User might have removed "sensitive" information like the path.

From which version did you try to update?

@tsteur tsteur reopened this Feb 7, 2016
@tsteur
Copy link
Member

tsteur commented Feb 7, 2016

See #9714 user removed real table prefix.

@tsteur tsteur removed this from the 2.16.1 milestone Mar 8, 2016
@tsteur tsteur removed the duplicate For issues that already existed in our issue tracker and were reported previously. label Mar 8, 2016
@tsteur tsteur removed their assignment Mar 8, 2016
@mattab mattab closed this as completed Mar 31, 2016
@mattab mattab added answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. labels Mar 31, 2016
@mattab mattab added this to the 2.16.1 milestone Mar 31, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.
Projects
None yet
Milestone
2.16.1
Development

No branches or pull requests
4 participants
@tsteur @mattab @Joey3000 @stefan-niedermann