Hello friends!
I have a problem with the process to upgrade OMP 3.1.2.4 to 3.2.0.0
First problem:
When i run upgrade.php in the end shows: DB: Column ‘publication_id’ cannot be null
I actived debug mode on
It shows:
UPDATE publication_formats as pf
SET publication_id = (
SELECT s.current_publication_id
FROM temp_publication_formats as tpf
LEFT JOIN submissions as s
ON (tpf.submission_id = s.submission_id)
WHERE pf.publication_format_id = tpf.publication_format_id
)
→ failed. Column ‘publication_id’ cannot be null
→ PKP-Database-Logger 1613733245.0274: 1048: Column ‘publication_id’ cannot be null
I search how to fix this problem on:
When i do this consult: ```
SELECT COUNT(*) FROM authors a LEFT JOIN submissions s ON (a.submission_id = s.submission_id) WHERE s.submission_id IS NULL;
show 0
then i run this consult:
`SELECT` `pf.` `publication_id` `FROM ` `publication_formats` `` `pf` `LEFT JOIN submissions s ON (` `pf` `.submission_id
= s.submission_id) WHERE s.submission_id IS NULL;`
shows:
+----------------+
| publication_id |
+----------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+----------------+
16 rows in set (0.000 sec)
I dont know what i have to do
Second problem:
When i run upgrade.php
Shows a lot messages:
PHP Warning: copy(/dados/press_public//presses/1//monographs/595/simple/cover.jpg): failed to open stream: No such file or directory in /srv/www/sistema/teste5/lib/pkp/classes/file/FileManager.inc.php on line 181
When its happens, a lot of images disappear of files_dir and the page web doesnt have imagens