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