Name field in the database

Software Support
1

Hello,
I am not sure this is the right place to post this question, but I am not able to find the Name and Surname fields in any existing SQL table related to the registered users.

OJS 3.1.2.4, but probably this info is not important here.

Kind regards,
Zoran

2

Hi @zmandic ,

There are first_name and last_name in the table users.

Regards, Primož

3

Thank you very much Primož for your response.

Maybe my glasses are not adequate anymore, but I do not see these fields in the table Users. Is there a catch here? I see 21 fields and none of them are first_name and last_name.

Kind regards,

Zoran

4

the users table have username and user ID…
You can finde Name and Surname
tables > user_settings > setting_name = > setting_value

image

5

Right!
Thank you very much, Kerim. That’s it.
Kind regards,
Zoran

1 Like