¿In which table is the family name stored?
Hi @kaluosi,
Which version of OJs are you using? Family name of authors or registered users?
Regards, Primož
Thank you Primož
- Version: OJS 3.1.2.0
- I am looking for Family name of registered users. I can see this family name in the list of users:
Curiosly this ##user.familyName## column is empty when I change from spanish to english in the GUI
Family name is not in table users. That’s why i am wondering where is saved in the database
Regards
Carlos
Family name is stored in table user_settings.
Look at this thread for a similar problem:
https://github.com/pkp/pkp-lib/issues/4675
and try this solution:
https://github.com/NateWr/pkp-lib/commit/3481f2ba60cf1599836eacef1fd026036da78061
Thank you Dragoljub.
Table user_settings have not family name in my OJS 3.1.2
This is the structure of the table
[ojs3sel]> describe user_settings;
±------------------±-----------------±------±------±--------±------+
| Field | Type | Null | Key | Default | Extra |
±------------------±-----------------±------±------±--------±------+
| user_id | bigint(20) | NO | MUL | NULL | |
| locale | varchar(14) | NO | | | |
| setting_name | varchar(255) | NO | | NULL | |
| assoc_type | bigint(20) | YES | | 0 | |
| assoc_id | bigint(20) | YES | | 0 | |
| setting_value | text | YES | | NULL | |
| setting_type | varchar(6) | NO | | NULL | |
±--------------±-------------±-----±----±--------±------+
And his is a select of the first 5 registers:
select * from user_settings limit 5;
±--------±-------±--------------±-----------±---------±-----------------------------------±-------------+
| user_id | locale | setting_name | assoc_type | assoc_id | setting_value | setting_type |
±--------±-------±--------------±-----------±---------±-----------------------------------±-------------+
| 1 | | filterEditor | 256 | 1 | 0 | int |
| 1 | | filterSection | 256 | 1 | 0 | int |
| 2 | de_DE | biography | 0 | 0 | My biograhy (German) - TestUser1. | string |
| 2 | en_US | biography | 0 | 0 | My biograhy (English) - TestUser1. | string |
| 2 | es_ES | biography | 0 | 0 | My biograhy (Spanish) - TestUser1. | string |
±--------±-------±--------------±-----------±---------±-----------------------------------±-------------+
No family name any where.
Family name is just one of settings in field ‘setting_name’. Try this query:
SELECT * FROM user_settings where setting_name=‘familyName’ and you’ll see.
Anyway, try a solution from my previus post.
OK. Thank you so much!!That’s all I need.
I am developing a php script for sending mails to all users. Alas, this functionality is not present in OJS 3 or I have not been able to find it. I’m going to use the mail address from users table but also I need as well the family name for the heading of the message.
Thank you!!
1 Like