I have received reports from a journal manager about images missing from XML galleys.
Checking the forums I’ve found this post:
It didn’t provide a solution but I could use some pointers from it to check the database contents.
Below I’ll share a snippet from the xml and the contents of the database of the 3.2.1.1 version and the new 3.0.0.5 version
[XML]
<p>
<fig id="f1">
<label>Figura 1</label>
<caption>
<title>Una posta del Estado en siglo XIX en Sudamérica</title>
</caption>
<graphic xlink:href="2314-1549 -rhaa-55-02-35-gf1.jpg"/>
<attrib>Fuente: <xref ref-type="bibr" rid="B11">Page, 2007</xref>, p. 214</attrib>
</fig>
</p>
[OJS 3.2.1.1]
mysql> SELECT * FROM submission_files WHERE
> original_file_name = ‘2314-1549 -rhaa-55-02-35-gf1.jpg’;
| file_id | revision | source_file_id | source_revision | submission_id | file_type | file_size | original_file_name | file_stage | viewable | date_uploaded | date_modified | assoc_id | genre_id | direct_sales_price | sales_type | uploader_user_id | assoc_type |
±--------±---------±---------------±----------------±--------------±-----------±----------±---------------------------------±-----------±---------±--------------------±--------------------±---------±---------±-------------------±-----------±-----------------±-----------+
| 12883 | 1 | NULL | NULL | 3988 | image/jpeg | 12312 | 2314-1549 -rhaa-55-02-35-gf1.jpg | 17 | 0 | 2020-10-25 21:34:42 | 2020-10-25 21:34:42 | 12882 | 202 | NULL | NULL | 1555 | 515 |
1 row in set (0.00 sec)
mysql> select * from genre_settings where genre_id =202;
±---------±-------±-------------±-------------------------±-------------+
| genre_id | locale | setting_name | setting_value | setting_type |
±---------±-------±-------------±-------------------------±-------------+
| 202 | es_ES | name | Imagen | string |
±---------±-------±-------------±-------------------------±-------------+
[OJS 3.0.0.5]
MariaDB [revistasuncu]> select * from submission_files where file_id = 12883;
| submission_file_id | source_submission_file_id | submission_id | file_stage | viewable | created_at | updated_at | assoc_id | genre_id | direct_sales_price | sales_type | uploader_user_id | assoc_type | file_id |
±-------------------±--------------------------±--------------±-----------±---------±--------------------±--------------------±---------±---------±-------------------±-----------±-----------------±-----------±--------+
| 14894 | 14893 | 3438 | 11 | 0 | 2021-02-25 13:37:47 | 2021-02-25 13:40:25 | NULL | 133 | NULL | NULL | 1430 | NULL | 12883 |
1 row in set (0.001 sec)
MariaDB [revistasuncu]> select * from submission_files where file_id = 12882;
| submission_file_id | source_submission_file_id | submission_id | file_stage | viewable | created_at | updated_at | assoc_id | genre_id | direct_sales_price | sales_type | uploader_user_id | assoc_type | file_id |
±-------------------±--------------------------±--------------±-----------±---------±--------------------±--------------------±---------±---------±-------------------±-----------±-----------------±-----------±--------+
| 14893 | NULL | 3438 | 6 | 1 | 2021-02-25 13:37:47 | 2021-02-25 13:37:47 | NULL | 133 | NULL | NULL | 1430 | NULL | 12882 |
1 row in set (0.000 sec)
MariaDB [revistasuncu]> select * from genre_settings where genre_id =133;
| genre_id | locale | setting_name | setting_value | setting_type |
±---------±-------±-------------±---------------------------±-------------+
| 133 | es_ES | name | Texto del Artículo | string |
It seems that, somehow during the upgrade the image file lost his link to the xml file and also it’s file type among other things …
I haven’t tried to “fill the blanks” directly in the database in the hope to find a better, more general, solution.
Thanks in advance!