Error upgrade ojs 2.4.8.5 > 3.2.1.4

Software Support
, ,
1

Hello everyone, I need help ojs:3.2.1.4 after trying to update from version 2.4.8.5 to 3.2.1.4 this error occurs:

PHP fatal error: Uncaught exception: Database error: ERROR: Invalid input syntax for integer: “” Query: INSERT INTO submit_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ? ) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703

Does anyone know how to treat it???

2

Hi @JUCIO_GABRIEL_ARAUJO,

(Cross-posted: Error Upgrade Ojs 2.4.8.5 > 3.2.1.4 · Issue #9569 · pkp/pkp-lib · GitHub)

Can you post the complete output of the upgrade process?

Also, are there any customizations or custom plugins in the installation? There is no database table called submit_galley_settings in either OJS 2.4.8-5 or OJS 3.2.1-4.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Of course yes I will send it here just waiting for you to send it to me

4

Hi @asmecher this is my log file:

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99431’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM item_views WHERE assoc_type = ? AND assoc_id = ?
[ (0=>‘515’) (1=>‘99431-1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_files
(file_id, revision, submission_id, source_file_id, source_revision, file_type, file_size, original_file_name, file_stage, date_uploaded, date_modified, viewable, uploader_user_id, assoc_type, assoc_id, genre_id, direct_sales_price, sales_type)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ‘2012-05-22 17:02:17’, ‘2012-05-22 17:02:17’, ?, ?, ?, ?, ?, ?, ?)
[ (0=>‘99431’) (1=>‘1’) (2=>‘27103’) (3=>null) (4=>null) (5=>‘image/jpeg’) (6=>‘807235’) (7=>‘Comprovante deposito_BAlbina Soriano.jpg’) (8=>‘2’) (9=>‘0’) (10=>‘702291’) (11=>null) (12=>null) (13=>‘792’) (14=>null) (15=>null) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genres WHERE genre_id = ? ORDER BY seq
[ (0=>‘792’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genre_settings WHERE genre_id = ?
[ (0=>‘792’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM users WHERE user_id = ?
[ (0=>‘702291’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM user_settings WHERE user_id = ?
[ (0=>‘702291’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘lbalbinot, Comprovante deposito_BAlbina Soriano.jpg’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘name’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id WHERE sf.file_id = ? AND sf.revision = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
[ (0=>‘99431’) (1=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99431’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_files
SET
file_id = ?,
revision = ?,
submission_id = ?,
source_file_id = ?,
source_revision = ?,
file_type = ?,
file_size = ?,
original_file_name = ?,
file_stage = ?,
date_uploaded = ‘2012-05-22 17:02:17’,
date_modified = ‘2012-05-22 17:02:17’,
viewable = ?,
uploader_user_id = ?,
assoc_type = ?,
assoc_id = ?,
genre_id = ?,
direct_sales_price = ?,
sales_type = ?
WHERE file_id = ? AND revision = ?
[ (0=>‘99431’) (1=>‘1’) (2=>‘27103’) (3=>null) (4=>null) (5=>‘image/jpeg’) (6=>‘807235’) (7=>‘Comprovante deposito_BAlbina Soriano.jpg’) (8=>‘2’) (9=>‘0’) (10=>‘702291’) (11=>null) (12=>null) (13=>‘792’) (14=>null) (15=>null) (16=>‘99431’) (17=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘comprovante de depósito’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘name’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘creator’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘creator’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘subject’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘subject’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘O documento suplementar que inclui foi um jpg do comprovante de deposito da taxa solicitada qdo se submete um artigo.’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘description’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘description’,‘string’,‘O documento suplementar que inclui foi um jpg do comprovante de deposito da taxa solicitada qdo se submete um artigo.’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘publisher’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘publisher’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘sponsor’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘sponsor’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99431’ and locale=‘pt_BR’ and setting_name=‘source’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99431’,‘pt_BR’,‘source’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM submission_file_settings WHERE file_id = ? AND setting_name IN ( ? ,? ,? ,? )
[ (0=>‘99431’) (1=>‘pub-id::publisher-id’) (2=>‘chapterId’) (3=>‘dateCreated’) (4=>‘language’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27103’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_supplementary_files
SET
file_id = ?,
revision = ?
WHERE file_id = ? AND revision = ?
[ (0=>‘99431’) (1=>‘1’) (2=>‘99431’) (3=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?)
[ (0=>‘99431’) (1=>‘old-supp-id’) (2=>‘12268’) (3=>‘string’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genres WHERE entry_key = ? AND context_id = ?
[ (0=>‘OTHER’) (1=>‘18’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genre_settings WHERE genre_id = ?
[ (0=>‘792’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id WHERE sf.file_id = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id WHERE sf.file_id = ? AND sf.revision = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
[ (0=>‘99341’) (1=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM submission_files
WHERE file_id = ? AND revision = ?
[ (0=>‘99341’) (1=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_files WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM item_views WHERE assoc_type = ? AND assoc_id = ?
[ (0=>‘515’) (1=>‘99341-1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_files
(file_id, revision, submission_id, source_file_id, source_revision, file_type, file_size, original_file_name, file_stage, date_uploaded, date_modified, viewable, uploader_user_id, assoc_type, assoc_id, genre_id, direct_sales_price, sales_type)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ‘2012-05-21 16:57:12’, ‘2012-05-21 16:57:12’, ?, ?, ?, ?, ?, ?, ?)
[ (0=>‘99341’) (1=>‘1’) (2=>‘27078’) (3=>null) (4=>null) (5=>‘application/vnd.openxmlformats-officedocument.wordprocessingml.d…’) (6=>‘79928’) (7=>‘MA.Descentralizacao_Revista_FLORESTA.21 - 05 - 2012.docx’) (8=>‘10’) (9=>‘0’) (10=>‘702291’) (11=>null) (12=>null) (13=>‘792’) (14=>null) (15=>null) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genres WHERE genre_id = ? ORDER BY seq
[ (0=>‘792’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM genre_settings WHERE genre_id = ?
[ (0=>‘792’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM users WHERE user_id = ?
[ (0=>‘702291’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM user_settings WHERE user_id = ?
[ (0=>‘702291’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘lbalbinot, MA.Descentralizacao_Revista_FLORESTA.21 - 05 - 2012.docx’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘name’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99341’,‘pt_BR’,‘name’,‘string’,‘lbalbinot, MA.Descentralizacao_Revista_FLORESTA.21 - 05 - 2012.docx’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): DELETE FROM submission_file_settings WHERE file_id = ? AND setting_name IN ( ? ,? ,? ,? ,? ,? ,? ,? ,? ,? )
[ (0=>‘99341’) (1=>‘creator’) (2=>‘subject’) (3=>‘description’) (4=>‘publisher’) (5=>‘sponsor’) (6=>‘source’) (7=>‘pub-id::publisher-id’) (8=>‘chapterId’) (9=>‘dateCreated’) (10=>‘language’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_supplementary_files
(file_id, revision)
VALUES
(?, ?)
[ (0=>‘99341’) (1=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id WHERE sf.file_id = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM article_supp_file_settings WHERE supp_id = ? AND setting_value IS NOT NULL
[ (0=>‘12245’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT DISTINCT
sf.file_id AS submission_file_id, sf.revision AS submission_revision,
af.file_id AS artwork_file_id, af.revision AS artwork_revision,
suf.file_id AS supplementary_file_id, suf.revision AS supplementary_revision,
COALESCE(p.locale, s.locale) AS submission_locale,
sf., af., suf.*
FROM submission_files sf
LEFT JOIN submission_artwork_files af ON sf.file_id = af.file_id AND sf.revision = af.revision
LEFT JOIN submission_supplementary_files suf ON sf.file_id = suf.file_id AND sf.revision = suf.revision
LEFT JOIN submissions as s ON s.submission_id = sf.submission_id
LEFT JOIN publications p ON s.current_publication_id = p.publication_id WHERE sf.file_id = ? AND sf.revision = ? ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
[ (0=>‘99341’) (1=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_file_settings WHERE file_id = ?
[ (0=>‘99341’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_files
SET
file_id = ?,
revision = ?,
submission_id = ?,
source_file_id = ?,
source_revision = ?,
file_type = ?,
file_size = ?,
original_file_name = ?,
file_stage = ?,
date_uploaded = ‘2012-05-21 16:57:12’,
date_modified = ‘2012-05-21 16:57:12’,
viewable = ?,
uploader_user_id = ?,
assoc_type = ?,
assoc_id = ?,
genre_id = ?,
direct_sales_price = ?,
sales_type = ?
WHERE file_id = ? AND revision = ?
[ (0=>‘99341’) (1=>‘1’) (2=>‘27078’) (3=>null) (4=>null) (5=>‘application/vnd.openxmlformats-officedocument.wordprocessingml.d…’) (6=>‘79928’) (7=>‘MA.Descentralizacao_Revista_FLORESTA.21 - 05 - 2012.docx’) (8=>‘10’) (9=>‘0’) (10=>‘702291’) (11=>null) (12=>null) (13=>‘792’) (14=>null) (15=>null) (16=>‘99341’) (17=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘GESTÃO FLORESTAL NO MARANHÃO: ESTRUTURA ESTADUAL PÓS-DESCENTRALIZAÇÃO’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘name’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘creator’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99341’,‘pt_BR’,‘creator’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘subject’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99341’,‘pt_BR’,‘subject’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘description’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99341’,‘pt_BR’,‘description’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘publisher’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id,locale,setting_name,setting_type,setting_value) VALUES (‘99341’,‘pt_BR’,‘publisher’,‘string’,‘’)

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_file_settings SET setting_type=‘string’,setting_value=‘’ WHERE file_id=‘99341’ and locale=‘pt_BR’ and setting_name=‘sponsor’

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submissions WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT * FROM submission_settings WHERE submission_id = ?
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): select * from “publications” as “p” where “p”.“submission_id” in (?) order by “p”.“version” asc
[ (0=>‘27078’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): UPDATE submission_supplementary_files
SET
file_id = ?,
revision = ?
WHERE file_id = ? AND revision = ?
[ (0=>‘99341’) (1=>‘1’) (2=>‘99341’) (3=>‘1’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_file_settings (file_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?)
[ (0=>‘99341’) (1=>‘old-supp-id’) (2=>‘12245’) (3=>‘string’) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_galleys (locale, submission_id, file_id, label) VALUES (?, ?, ?, ?)
[ (0=>‘’) (1=>‘27078’) (2=>‘99341’) (3=>null) ]

PKP-Database-Logger 1702608787,6349: -----
(postgres8): SELECT currval(pg_get_serial_sequence(‘publication_galleys’, ‘galley_id’))

PHP Warning: pg_query(): Query failed: ERROR: currval of sequence “publication_galleys_galley_id_seq” is not yet defined in this session in /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres7.inc.php on line 259

Warning: pg_query(): Query failed: ERROR: currval of sequence “publication_galleys_galley_id_seq” is not yet defined in this session in /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres7.inc.php on line 259
PKP-Database-Logger 1702608787,6349: -1: ERROR: currval of sequence “publication_galleys_galley_id_seq” is not yet defined in this session
ADOConnection._Execute(SELECT currval(pg_get_serial_sequence(‘publication_galleys’, ‘galley_id’)), false)% line 1241, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.Execute(SELECT currval(pg_get_serial_sequence(‘publication_galleys’, ‘galley_id’)), false)% line 1681, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.GetOne(SELECT currval(pg_get_serial_sequence(‘publication_galleys’, ‘galley_id’)))% line 44, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres8.inc.php
ADODB_postgres8._insertid(publication_galleys, galley_id)% line 1377, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.Insert_ID(publication_galleys, galley_id)% line 1395, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
PKP-Database-Logger 1702608787,6349: -----
(postgres8): INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?)
[ (0=>‘’) (1=>‘pub-id::publisher-id’) (2=>‘artigo substituto’) (3=>‘string’) ]

PHP Warning: pg_query_params(): Query failed: ERROR: invalid input syntax for integer: “” in /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres7.inc.php on line 257

Warning: pg_query_params(): Query failed: ERROR: invalid input syntax for integer: “” in /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres7.inc.php on line 257
PKP-Database-Logger 1702608787,6349: -1: ERROR: invalid input syntax for integer: “”
ADOConnection._Execute(INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?), Array[4])% line 1237, file: /opt/data/html/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.Execute(INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?), Array[4])% line 229, file: /opt/data/html/lib/pkp/classes/db/DAO.inc.php
DAO.update(INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?), Array[4])% line 1454, file: /opt/data/html/classes/install/Upgrade.inc.php
Upgrade.convertSupplementaryFiles(Object:Upgrade, Array[1])% line 417, file: /opt/data/html/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 263, file: /opt/data/html/lib/pkp/classes/install/Installer.inc.php
PHP Fatal error: Uncaught Exception: DB Error: ERROR: invalid input syntax for integer: “” Query: INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /opt/data/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_postgres8), ‘INSERT INTO sub…’)
#1 /opt/data/html/classes/install/Upgrade.inc.php(1454): DAO->update(‘INSERT INTO sub…’, Array)
#2 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles(Object(Upgrade), Array)
#3 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#4 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /opt/data/html/tools/upgrade.php(22): Upgrade in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 703

Fatal error: Uncaught Exception: DB Error: ERROR: invalid input syntax for integer: “” Query: INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /opt/data/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_postgres8), ‘INSERT INTO sub…’)
#1 /opt/data/html/classes/install/Upgrade.inc.php(1454): DAO->update(‘INSERT INTO sub…’, Array)
#2 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles(Object(Upgrade), Array)
#3 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#4 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /opt/data/html/tools/upgrade.php(22): Upgrade in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 703

5

Hi @JUCIO_GABRIEL_ARAUJO,

It looks like you have your debug setting set to On in config.inc.php, which dumps all queries to the log and makes it hard to find the relevant message. However, this warning gives a hint:

Something appears to be wrong with one of your tables’ database sequence.

Can you re-run the upgrade without Debug enabled and post the results?

Thanks,
Alec Smecher
Public Knowledge Project Team

6

good morning, @asmecher . It was a little big but I did as requested, leaving the drive link open for you to download because there were a lot of lines…

link drive:nohup.out - Google Drive

7

Hi @JUCIO_GABRIEL_ARAUJO,

Was the files_dir in config.inc.php mis-configured when you ran the upgrade? Or was this on a test server without a copy of the files directory’s contents? Much of the error log is taken up with missing files warnings.

Regards,
Alec Smecher
Public Knowledge Project Team

8

hello @asmecher following error log could you help me??`[pre-install]
[load: upgrade.xml]
[version: 3.2.1.4]

[code: Installer Installer::checkPhpVersion]

[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml (skipped)]

[code: Installer Installer::removeReviewEntries]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_preupdate_commentsToEditor.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml]
[data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml]
[data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml]

[code: Installer Installer::migrateSubmissionCoverImages]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning_articleGalleySettings.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml]
[data: dbscripts/xml/upgrade/3.2.1_preupdate_subeditor_categories.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/categories.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: lib/pkp/xml/schema/navigationMenus.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]

[code: Installer Installer::installDefaultNavigationMenus]
PHP Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: copy(/var/www/files//journals/30//articles/4449/attachment/4449-385-9816-2-13-20060203.pdf): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180

Warning: copy(/var/www/files//journals/30//articles/4449/attachment/4449-385-9816-2-13-20060203.pdf): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Warning: Illegal string offset ‘en_US’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93188-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93189-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180

Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93189-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93190-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180

Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93190-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93191-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180

Warning: copy(/var/www/files//journals/40//articles/22501/attachment/22501-313-93191-2-13-20120606.doc): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Warning: Illegal string offset ‘es_ES’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: Illegal string offset ‘es_ES’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: Illegal string offset ‘en_US’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: Illegal string offset ‘en_US’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133

Warning: Illegal string offset ‘pt_BR’ in /opt/data/html/lib/pkp/classes/core/DataObject.inc.php on line 133
PHP Notice: unserialize(): Error at offset 0 of 13 bytes in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 357

Warning: copy(/var/www/files//journals/18//articles/27078/attachment/27078-781-99341-1-13-20120521.docx): failed to open stream: Arquivo ou diretório inexistente in /opt/data/html/lib/pkp/classes/file/FileManager.inc.php on line 180
PHP Fatal error: Uncaught Exception: DB Error: ERROR: invalid input syntax for integer: “” Query: INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /opt/data/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError()
#1 /opt/data/html/classes/install/Upgrade.inc.php(1454): DAO->update()
#2 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles()
#3 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction()
#4 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /opt/data/html/tools/upgrade.php(22): UpgradeTool->execute()
#8 {main}
thrown in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 703

Fatal error: Uncaught Exception: DB Error: ERROR: invalid input syntax for integer: “” Query: INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /opt/data/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError()
#1 /opt/data/html/classes/install/Upgrade.inc.php(1454): DAO->update()
#2 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles()
#3 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction()
#4 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /opt/data/html/tools/upgrade.php(22): UpgradeTool->execute()
#8 {main}
thrown in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 703
`

As you can see, I have missing files errors because the database searches for a file and compares it in the files_dir and in fact all the ones it compares do not exist, other errors such as illegal string offset, unserialize, but the fatal error was:

`PHP Fatal error: Uncaught Exception: DB Error: ERROR: invalid input syntax for integer: “” Query: INSERT INTO submission_galley_settings (galley_id, setting_name, setting_value, setting_type) VALUES (?, ?, ?, ?) in /opt/data/html/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /opt/data/html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError()
#1 /opt/data/html/classes/install/Upgrade.inc.php(1454): DAO->update()
#2 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->convertSupplementaryFiles()
#3 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction()
#4 /opt/data/html/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /opt/data/html/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /opt/data/html/tools/upgrade.php(22): UpgradeTool->execute()
#8 {main}
thrown in /opt/data/html/lib/pkp/classes/db/DAO.inc.php on line 703``
type or paste code here


how to fix this? Whenever the update fails, I upload a new database and keep testing, how can I fix this?