phpbb deleted all inactive users now can't login
I had 45K inactive users on my phpbb3 board.
Went on to delete them from mysql (erased all that had user_new=1).
Now I can't login, and the board shows no forums.
No idea how to get all the forums and the login back without resorting to restore the database.
It would be good to know why this happen if I only erased inactive users.
phpbb3
asked Nov 20 at 20:24
Miguel Pinkas
13
add a comment |
I had 45K inactive users on my phpbb3 board.
Went on to delete them from mysql (erased all that had user_new=1).
Now I can't login, and the board shows no forums.
No idea how to get all the forums and the login back without resorting to restore the database.
It would be good to know why this happen if I only erased inactive users.
phpbb3
asked Nov 20 at 20:24
Miguel Pinkas
13
1
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43
add a comment |
I had 45K inactive users on my phpbb3 board.
Went on to delete them from mysql (erased all that had user_new=1).
Now I can't login, and the board shows no forums.
No idea how to get all the forums and the login back without resorting to restore the database.
It would be good to know why this happen if I only erased inactive users.
phpbb3
asked Nov 20 at 20:24
Miguel Pinkas
13
I had 45K inactive users on my phpbb3 board.
Went on to delete them from mysql (erased all that had user_new=1).
Now I can't login, and the board shows no forums.
No idea how to get all the forums and the login back without resorting to restore the database.
It would be good to know why this happen if I only erased inactive users.
phpbb3
phpbb3
asked Nov 20 at 20:24
Miguel Pinkas
13
asked Nov 20 at 20:24
Miguel Pinkas
13
edited Nov 20 at 21:00
asked Nov 20 at 20:24
Miguel Pinkas
13
asked Nov 20 at 20:24
Miguel Pinkas
13
asked Nov 20 at 20:24
Miguel Pinkas
13
13
1
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43
add a comment |
1
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43
1
1
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43
add a comment |
1 Answer
1
active
oldest
votes
Well, I found the answer.
This link has the mysql statement to bring things back.
So, for what it worth, whatever you do, don't delete the anonymous user from the database...
answered Nov 20 at 21:26
Miguel Pinkas
13
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400976%2fphpbb-deleted-all-inactive-users-now-cant-login%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Well, I found the answer.
This link has the mysql statement to bring things back.
So, for what it worth, whatever you do, don't delete the anonymous user from the database...
answered Nov 20 at 21:26
Miguel Pinkas
13
add a comment |
Well, I found the answer.
This link has the mysql statement to bring things back.
So, for what it worth, whatever you do, don't delete the anonymous user from the database...
answered Nov 20 at 21:26
Miguel Pinkas
13
add a comment |
Well, I found the answer.
This link has the mysql statement to bring things back.
So, for what it worth, whatever you do, don't delete the anonymous user from the database...
answered Nov 20 at 21:26
Miguel Pinkas
13
Well, I found the answer.
This link has the mysql statement to bring things back.
So, for what it worth, whatever you do, don't delete the anonymous user from the database...
answered Nov 20 at 21:26
Miguel Pinkas
13
answered Nov 20 at 21:26
Miguel Pinkas
13
answered Nov 20 at 21:26
Miguel Pinkas
13
answered Nov 20 at 21:26
Miguel Pinkas
13
13
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400976%2fphpbb-deleted-all-inactive-users-now-cant-login%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Do you have a backup of mysql? I would expect a site with that volume of users to have some backup routine?
– Wayne Phipps
Nov 20 at 20:28
Well, I happen to have it, of course. And I can get it back with all 45K users too. It seems my "get all back" was not precise. I edited it. What I meant with "all back" is all the forums back. And maybe in the process, learn WHY the thing drop dead if I deleted INACTIVE users. Couldn't find the answer in the phpbb docs so far. Thanks.
– Miguel Pinkas
Nov 20 at 20:30
You could restore from the backup database. Another alternative possibly dependant on configuration and version would be point in time recovery: dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
– Wayne Phipps
Nov 20 at 20:34
Thanks wayne, But you keep giving me database related answers, and I am asking about phpbb logic for not showing me the forums if I delete INACTIVE users. maybe has to do with the forums being populated with posts from those users... Anyways, I am trying to avoid to solve the issue rolling back mysql.
– Miguel Pinkas
Nov 20 at 20:37
you should clarify your question so it's clear
– Wayne Phipps
Nov 20 at 20:43