Hello @asmecher,
I did some changes at database migration process. Now I have my data in MariaDB. I’ve tried (again) to migrate from ojs 2.3 to ojs 3.1 using ojs 2.4 as bridge. When I run my upgrade using php tool/upgrade.php upgrade I am obtaining the next error:
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = ‘title’ AND stpl.locale = ‘es_ES’)
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = ‘title’ AND stl.locale = ‘es_ES’)
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = ‘abbrev’ AND sapl.locale = ‘es_ES’)
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = ‘abbrev’ AND sal.locale = ‘es_ES’)
WHERE s.submission_id = 397
-----
-----
(mysql): SELECT * FROM submission_settings WHERE submission_id = ‘397’
-----
PHP Warning: assert(): Assertion failed in /var/www/html/ojs3/lib/pkp/classes/submission/SubmissionFileDAODelegate.inc.php on line 112
PHP Warning: mkdir(): Permission denied in /var/www/html/ojs3/lib/pkp/classes/file/FileManager.inc.php on line 289
PHP Warning: copy(/var/submission_files3/journals/1//articles/397/submission/review/397-38–1-4-20121003.doc): failed to open stream: Permission denied in /var/www/html/ojs3/lib/pkp/classes/file/FileManager.inc.php on line 159
-----
(mysql): DELETE FROM submission_files
WHERE file_id = 6216 AND revision = 1
-----
-----
(mysql): SELECT * FROM submission_files WHERE file_id = 6216
-----
-----
(mysql): DELETE FROM submission_file_settings WHERE file_id = 6216
-----
-----
(mysql): DELETE FROM item_views WHERE assoc_type = 515 AND assoc_id = ‘6216-1’
-----
-----
(mysql): SELECT s.*, ps.date_published,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM submissions s
LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
JOIN sections se ON se.section_id = s.section_id
LEFT JOIN section_settings stpl ON (se.section_id = stpl.section_id AND stpl.setting_name = ‘title’ AND stpl.locale = ‘es_ES’)
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = ‘title’ AND stl.locale = ‘es_ES’)
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = ‘abbrev’ AND sapl.locale = ‘es_ES’)
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = ‘abbrev’ AND sal.locale = ‘es_ES’)
WHERE s.submission_id = 397
-----
-----
(mysql): SELECT * FROM submission_settings WHERE submission_id = ‘397’
-----
PHP Fatal error: Call to a member function getFileId() on null in /var/www/html/ojs3/lib/pkp/classes/submission/PKPSubmissionFileDAO.inc.php on line 1065
I don’t know what registries I have to verify before I run the upgrade script. Can you help me please?
thanks in advance.