Where are author names stored in mysql database

Software Support
,
1

I looked through all the tables of mysql database but could not find the author First name and Last name column. Where are they stored? I’m new to sql and couldn’t figure it out. I’m using OJS 3.2.0.3 and mysql version 5.7.

Can someone help me out please? Can anyone even see my questions. I have posted 3 different questions in the past on this forum and no one even replied once.

2

There is a table author_setting with the columns setting_name and setting_value. You have to look for entries where setting_name = “familyName” or setting_name=“givenName”. In the column setting_value you will see the names.

You have to be really careful with the database if you are new to this. Don’t change anything, because it can really messes with the data and your whole system.

1 Like