| Server IP : 172.66.157.178 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/dbscripts/xml/upgrade/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd"> <!-- * event_log_submissionid.xml * * Copyright (c) 2013-2019 Simon Fraser University * Copyright (c) 2003-2019 John Willinsky * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING. * * Add missing submissionId param for the log.author.submitted events. * --> <data> <sql> <query> INSERT INTO event_log_settings (log_id, setting_name, setting_value, setting_type) SELECT event_log.log_id, 'submissionId', event_log.assoc_id, 'string' FROM event_log WHERE event_log.message='log.author.submitted' AND NOT EXISTS (SELECT * FROM event_log_settings WHERE setting_name='submissionId' AND log_id=event_log.log_id) </query> </sql> </data>