This Help forum is for issues relates to the latest release (1.7.7). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."
  • Page:
  • 1

TOPIC:

Problem with database import 4 years 7 months ago #1

  • Ralvex1
  • Ralvex1's Avatar Topic Author
  • Visitor
  • Visitor
Hi all!

First, sorry for my bad english speaking :/

I try to import my old database (mysql) in my fresh webtrees installation. I import with "phpmyadmin". All work fine except login :/
My user is present in my database, but if i try to log it. I have this message: "This account has not been verified. Please check your email for a verification message." But I can not connect me :/
Do I modify the database to change that? switch my user at "verified?

I hope you understand my poor english

thx

Please Log in or Create an account to join the conversation.

Problem with database import 4 years 7 months ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
> I have this message: "This account has not been verified. Please check your email for a verification message." But I can not connect me :/
> Do I modify the database to change that? switch my user at "verified?

If this is an administrator account, then "verified" is ignored.

You can find administrators like this:
SELECT * FROM wt_user_setting WHERE setting_name='canadmin' and setting_value='1';

Did you copy this table?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Problem with database import 4 years 7 months ago #3

  • Ralvex1
  • Ralvex1's Avatar Topic Author
  • Visitor
  • Visitor
I expose my installation method for more comprehension.
1. I have installed webtrees on my news VPS.
2. I have deleted the database on this news installation
3.I have importing my old mysql's backup (from my old webtrees installation on my other server (at home)
4.If i try to connecte my admin acompte (old admin acompte of my mysql backup)

It's a problem with account? (account in my old mysql conflict with account in the fresh installlation)

I shoul'd remove account in database?

Please Log in or Create an account to join the conversation.

Problem with database import 4 years 7 months ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
> My user is present in my database, but if i try to log it. I have this message:

On your old system, was this user an administrator?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Problem with database import 4 years 7 months ago #5

  • Ralvex1
  • Ralvex1's Avatar Topic Author
  • Visitor
  • Visitor
In the old installation: matthieu is the admin account.
I have created again matthieu's account in the fresh installation!

Please Log in or Create an account to join the conversation.

Problem with database import 4 years 7 months ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
> I have created again matthieu's account in the fresh installation!

To login, you must be either

1) have email verified and be approved by administrator
2) be an administrator

If you created the account (add a row in table wt_user), then you must also make this an administrator (table wt_user_setting - see above)
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

(Solved) Problem with database import 4 years 7 months ago #7

  • Ralvex1
  • Ralvex1's Avatar Topic Author
  • Visitor
  • Visitor
OK It work :)
1 I have made a fresh install again with matthieu's account, same password, same email adress.
2 I have removed the fresh database
3 imported old database
4 login work :)

Thank for your help ;)

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum