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
Mysqli prepare error: Table 'piwik.piwik_brute_force_log' doesn't exist" #13836
Comments
See also https://forum.matomo.org/t/updateprobleme-3-8-0-b4/30909 Seems like a regression from #13472 Interestingly the same update worked fine for me. (from 3.7.0) |
I also experienced this issue a few times, to fix this problem please run the following SQL query: CREATE TABLE `brute_force_log` (
`id_brute_force_log` bigint(11) NOT NULL,
`ip_address` varchar(60) DEFAULT NULL,
`attempted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `brute_force_log` ADD KEY `ip_address` (`ip_address`); Note: you may need to replace I don't think we'll be able to fix it so this manual workaround might be the best option |
Hello, At now, through upgrade process, thus one error was displayed, I have the table created as this :
This table is empty. If I have understand, as my Matomo database is prefixed with piwik_, I just have to let it as it is ? Thanks, Eric |
@eldk Sounds good. If someone enters an incorrect password it should show up in the table. @mattab The question is if this is just the normal "update-failed-for-whatever-reason" or if something is special about this update. I was just suspicious because two people reported the same thing, but maybe that was just bad luck. |
If you experience this problem please try to visit your Matomo root page (eg.
|
For what it's worth, I ran into this when updating from 3.8.0b2 using autoupdate, not Git. Also another more pressing issue with being unable to login, but I think that's separate so I'll file it separately. |
ran into this when upgrading 3.7.0 to 3.8.0 |
Like @pavarnos but happened when updating from 3.6.0 to 3.8.0 release. The table was created, however, and everything seems to work. |
Just updated 2 Matomo Installations to 3.8.0 release and both failed with this error. There seems to be something wrong with the db upgrade scripts. According to #13990 maybe a lot more... |
Same problem when upgrade form 3.7.0 to 3.8.0 |
Same as @AlainRnet Checking the DB, everything is good, the table is here. |
Looks like my hypothesis above was wrong and there really is an issue to investigate and fix |
Same issue for me. Upgrade from 3.7.0 to 3.8.0 |
+1 with this issue, updated from 3.7.0 to 3.8.0. Manually creating the table solved the issue - not sure if we missed updating steps now though. |
I just clicked on "Back to Matomo" and then continued the upgrade process. The table was created afterwards and everything seems to work. |
If you experience this problem please try to visit your Matomo root page (eg.
|
Same error here. And yes, if i visit the root page, the database upgrade runs. |
Same message. "Back to Matomo" and then continued the upgrade process. worked out. thanks. |
The changelog should be updated:
|
@J0WI But I agree that this could be made more clear in the future. |
i can't login in two different installations. First the table doesn't exist message while upgrading, then i checked it.... they are created. |
I ran into the same issue of the table not existing. I clicked back to Matomo it prompted me to do a DB upgrade. I clicked upgrade and then I got a 500 error. Then I clicked the Back button and it then prompted me to log in and it seems to be working now. But I haven't checked the actual database to see if the table was created or not yet. |
If you are able to get to the login page but submitting does nothing except clear the form info and loop back (not even an error message), flushing your cookies may help; it did for me. |
flushing the cookie, helps me to login again! :-) |
FWIW, after I got the first error about When I used the
I looked in that directory and saw a bunch of tmp directories owned by root. Perhaps they got made temporarily during the failed upgrade attempt? Anyway, I fixed them with:
I then tried refreshing the I'm always impressed with how smoothly Piwik upgrades go, but this one has been a mess. Cascading errors perhaps. |
Good |
updating two 3.7.0 to 3.8.0, I got error about missing table, I hit "back" and it promote me to update database on both instance. After that both works fine. |
@diosmosis as people affected by this issue, do we have to do anything to prevent this from happening, or do we have to create that table by hand? or will it be created for us with next update? |
I think table has been created in spite of everything. |
This is correct, if the table hadn't been created, you would still be getting the same error. |
Thanks for clearing this out. |
I went to the root page and it did NOT create the table, ended up having to create manually. (I confirmed my Matomo MySql account has permissions to CREATE and ALTER). After manually creating the upgrade seems to have finished. |
Hello,
While upgrading through automatic update to Matomo 3.8.0-b4, from 3.8.0b3, I have got this message :
""Error in Matomo: Mysqli prepare error: Table 'piwik.piwik_brute_force_log' doesn't exist" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: domain.tld, request: "POST /index.php?module=CoreUpdater&action=oneClickResults HTTP/2.0", upstream: "fastcgi://unix:/var/php-nginx/xxxxxxxx.sock/socket:", host: "domain.tld", referrer: "https://domain.tld/index.php?module=CoreUpdater&action=oneClickUpdate"
Then the database upgrade screen appear as usual. Process.
All seems to have been well completed so Matomo is fonctional.
So, report it in case I missed something.
Thanks,
Eric
The text was updated successfully, but these errors were encountered: