User added but not displayed

Zacharieg

Hello !
For a migration from fluxBB I added users to the database, why they don't show up in the user tables in administration ?
I added them via DB::table('users')->insert()
(I precise I didn't migrate post or tags, only users)
Captures (I didn't found a site to correctly host them) :
https://pasteboard.co/K6JClwT.png
https://pasteboard.co/K6JDCY3.png

clarkwinkelmann

Zacharieg check the browser javascript console, there might be a javascript error.

In the screenshot we see 3 pages are loaded, so it means the first page must contain 50 results. The lines are probably just not visible in the frontend because of a bug.

If that doesn't help, what happens when you use the arrow to move to page 2?

Zacharieg

clarkwinkelmann Thank you for your reply !
I only have some warnings in the console from frappe-charts.esm.js (Unexpected NaN value when parsing width attribute.), but it seems that even the html isn't added.
I wonder if it is because of a cache or because I have inserted unexpected values.
When I click on the arrow it happens nothing.
I'm quite confused, if you have another idea...

Zacharieg

I think this is an API problem, when I get /api/users I only get the admi user 🤔

luceos

Most likely these users aren't confirmed in the database. Can you screen capture the table (without email addresses and usernames)?

Zacharieg

luceos Here

luceos

The column I needed is not in the screenshot. Can you confirm that is_email_confirmed is set to 1 on all those users?

Zacharieg

luceos yes it is (it's the first column, the label is cut)
Ok this is a weird thing, I tried to add normally new users and I can't start a discussion ("can't start a discussion" on the button) even if I validate the user with the link sent by mail. I'm in log mode for the mail, but I don't think it changes something.

Zacharieg

I have no idea why, but I remove and reinstall Flarum and it works 🙃