I was trying it, I delete row and it does not work, I restored database and I try adding a non-numeric prefix and it does not work.
Hi @leoto17,
Can you describe in detail what you tried, and what the resulting behavior was?
Regards,
Alec Smecher
Public Knowledge Project Team
Of course, first I tried deleting the row associated to article with problems “article_id=203” on table article_settings where the “setting_name=pub-id::publisher-id” and after this nothing happened the article continues with problem. Later I restored database for try other thing, I asign to the same row that tried delete the setting_value with non-numeric prefix as art203 but the result was same.
Hi @leoto17,
You’re mixing two kinds of IDs which I presume have different values – the article_id
, which is automatically assigned by OJS, and the setting_value
for article_settings
entries with a setting_name
of pub-id::publisher-id
.
If you’re sure you don’t want to use these IDs, one option would be to
DELETE FROM article_settings WHERE setting_name = 'pub-id::publisher-id';
…but make sure you take a backup before you do this, just in case it’s not what you want.
Regards,
Alec Smecher
Public Knowledge Project Team
Thank so much, it was the solution.