(mysql): SELECT * FROM sessions WHERE session_id = '67kundous71arenl0utec1ntq2'
(mysql): SELECT * FROM journals WHERE path = 'jipolis'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '7'
(mysql): SELECT * FROM site
(mysql): SET time_zone = '+7:00'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = '7' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.generic.usageStats.UsageStatsLoader'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.datacite.DataciteInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.doaj.DOAJInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.medra.MedraInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'plugins.importexport.crossref.CrossrefInfoSender'
(mysql): SELECT last_run FROM scheduled_tasks WHERE class_name = 'lib.pkp.classes.task.ReviewReminder'
(mysql): SELECT * FROM journals WHERE path = 'jipolis'
(mysql): SELECT * FROM journal_settings WHERE journal_id = '7'
(mysql): SELECT * FROM navigation_menus WHERE context_id = 7
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 15
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '203'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '206'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '204'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '207'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '205'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '208'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '209'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 15
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2006'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2009'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2007'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2010'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2008'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2011'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2012'
(mysql): SELECT nmi.*
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 16
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '286'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '280'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '282'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '283'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '284'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '285'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '281'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '210'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '211'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '215'
(mysql): SELECT * FROM navigation_menu_item_settings WHERE navigation_menu_item_id = '212'
(mysql): SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
FROM navigation_menu_item_assignments as nmh
LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
WHERE nmh.navigation_menu_id = 16
ORDER BY nmh.seq
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2216'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2217'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2218'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2219'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2220'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2221'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2222'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2223'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2224'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2225'
(mysql): SELECT * FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = '2226'
(mysql): SELECT c.* FROM journals c
WHERE c.enabled = 1 ORDER BY seq
(mysql): SELECT * FROM static_pages WHERE context_id = 7 AND path = 'article/view/4565'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4565' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4565' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4565
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4565'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4565
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1626'
(mysql): SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = 'pub-id::publisher-id' AND ist.setting_value = '88' ORDER BY i.issue_id
(mysql): SELECT i.* FROM issues i WHERE issue_id = 88
(mysql): SELECT * FROM issue_settings WHERE issue_id = '88'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.galley_id = 0
AND nsf.file_id IS NULL AND g.submission_id = 4565
(mysql):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 7 AND dependent = 0 AND supplementary = 0
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '73'
(mysql): SELECT * FROM genres
WHERE enabled = 1 AND context_id = 7 AND supplementary = 1
ORDER BY seq
(mysql): SELECT * FROM genre_settings WHERE genre_id = '74'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '75'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '76'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '77'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '78'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '79'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '80'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '81'
(mysql): SELECT * FROM genre_settings WHERE genre_id = '84'
(mysql): 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,
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 s ON s.submission_id = sf.submission_id LEFT JOIN submission_files sf2 ON sf.file_id = sf2.file_id AND sf.revision < sf2.revision
WHERE sf2.revision IS NULL AND sf.file_id = 10142 ORDER BY sf.submission_id ASC, sf.file_stage ASC, sf.file_id ASC, sf.revision DESC
(mysql): SELECT * FROM submission_file_settings WHERE file_id = '10142'
(mysql): SELECT * FROM sections WHERE section_id = 9
(mysql): SELECT * FROM section_settings WHERE section_id = '9'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4565)
1062: Duplicate entry 'submissionKeyword-1048585-4565' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4565)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4565) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4565
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18911 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '15947'
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4565' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')INNER JOIN submission_settings sst ON s.submission_id = sst.submission_id
WHERE sst.setting_name = 'pub-id::publisher-id' AND sst.setting_value = '4565' ORDER BY ps.issue_id, s.submission_id
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4565
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4565'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4565
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1626'
(mysql):
SELECT iss.subscription_id
FROM institutional_subscriptions iss
JOIN subscriptions s ON (iss.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD('216.73.216.103', LENGTH('216.73.216.103')+1, '.'))) != 0
AND iss.domain != ''
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)
(mysql): SELECT isip.subscription_id
FROM institutional_subscription_ip isip
JOIN subscriptions s ON (isip.subscription_id = s.subscription_id)
JOIN subscription_types st ON (s.type_id = st.type_id)
WHERE ((isip.ip_end IS NOT NULL
AND '3628718183' >= isip.ip_start AND '3628718183' <= isip.ip_end
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND '3628718183' = isip.ip_start
AND s.journal_id = 7
AND s.status = 1
AND st.institutional = 1
AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2026-01-29 02:09:55' >= s.date_start AND '2026-01-29 02:09:55' <= s.date_end)))
AND (st.format = 1
OR st.format = 17)))
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4565)
1062: Duplicate entry 'submissionKeyword-1048585-4565' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4565)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4565) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4565
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18911 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '15947'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 AND a.include_in_browse = 1 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
(mysql): INSERT INTO controlled_vocabs
(symbolic, assoc_type, assoc_id)
VALUES
('submissionKeyword', 1048585, 4565)
1062: Duplicate entry 'submissionKeyword-1048585-4565' for key 'controlled_vocab_symbolic'
ADOConnection._Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES ('submissionKeyword', 1048585, 4565)) % line 1032, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3]) % line 228, file: DAO.inc.php
DAO.update(INSERT INTO controlled_vocabs (symbolic, assoc_type, assoc_id) VALUES (?, ?, ?), Array[3], true, false) % line 110, file: ControlledVocabDAO.inc.php
ControlledVocabDAO.insertObject(Object:ControlledVocab, false) % line 60, file: ControlledVocabDAO.inc.php
ControlledVocabDAO._build(submissionKeyword, 1048585, 4565) % line 30, file: SubmissionKeywordDAO.inc.php
(mysql): SELECT * FROM controlled_vocabs WHERE symbolic = 'submissionKeyword' AND assoc_type = 1048585 AND assoc_id = 4565
(mysql): SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = 18911 ORDER BY seq
(mysql): SELECT * FROM controlled_vocab_entry_settings WHERE controlled_vocab_entry_id = '15947'
(mysql): SELECT * FROM sections WHERE section_id = 9
(mysql): SELECT * FROM section_settings WHERE section_id = '9'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = '7' OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT i.* FROM issues i WHERE journal_id = 7 AND current = 1
(mysql): SELECT * FROM issue_settings WHERE issue_id = '88'
Collaborative Governance dalam Penataan dan Pembinaan Pedagang Kaki Lima di Pasar Kordon Kota Bandung
Collaborative Governance dalam Penataan dan Pembinaan Pedagang Kaki Lima di Pasar Kordon Kota Bandung
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
Masalah dalam penelitian ini adalah belum optimalnya komunikasi antar pemangku kepentingan, kurangnya kepercayaan PKL kepada unit pemerintah, adanya PKL yang berjualan lebih dari jam yang ditentukan, dan belum tercapainya kesepakatan dengan pemilik lahan pribadi. Penelitian ini bertujuan untuk memahami proses kolaborasi antar pemangku kepentingan dalam menata serta membina Pedagang Kaki Lima yang ada di Pasar Kordon Kota Bandung. Metode yang digunakan dalam penelitian ini adalah metode deskriptif kualitatif dengan berfokus kepada kajian collaborative governance, mengacu kepada Peraturan Daerah Kota Bandung Nomor 04 tahun 2011 tentang Penataan dan Pembinaan PKL. Hasil penelitian ini menunjukkan bahwa penataan dan pembinaan PKL di Pasar Kordon belum optimal, hal ini ditunjukkan dengan beberapa indikator yang diantaranya yaitu dialog tatap muka yang belum optimal, kurangnya tingkat kepercayaan PKL kepada unit pemerintah, lemahnya komitmen, dan lemahnya koordinasi semua pemangku kepentingan. Hambatan yang ditemukan yaitu kurangnya sumber daya manusia, belum tuntasnya negosiasi dengan pemilik lahan pribadi, serta belum adanya keterlibatan pihak swasta. Adapun upaya yang dilakukan berupa monitoring setiap pagi, kembali menegosiasi lahan pribadi dan mencari pihak swasta. Dengan demikian, kolaborasi dalam penataan dan pembinaan PKL di Pasar Kordon masih memerlukan penguatan dari segi komunikasi, komitmen dan keterlibatan berbagai pemangku kepentingan.
(mysql): SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 7 AND setting_name = 'displayStatistics'
(mysql): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = 'usagestatsplugin' AND context_id = 7
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
References
A.S. Retno, dkk. 2020. Collaborative Governance dalam Perspektif Administrasi Publik. Semarang : Universitas Diponogoro Press
Atikah Nursyafni. 2023. Collaborative Governance dalam Upaya Mengoptimalkan Pemanfaatan Pasar Plaza Bangkinang Kabupaten Kampar. INNOVATIVE: Journal Of Social Science ResearchVolume 3 Nomor 2.
D. M. Hardiyansyah (n.d.). Pengantar Ilmu Administrasi Bisnis dan Publik.
Darmanita Zakiah dan M. Yusri. 2020. Pengoperasian Penelitian Naratif dan Etnografi; Pengertian, Prinsip-Prinsip, Prosedur, Analisis, Intepretasi dan Pelaporan temuan. As-Shaff Jurnal Manajemen dan Dakwah Volume 1 Nomor 1.
D. Y. Luh Ni. 2019. Dinamika Collaborative Governance Dalam Studi Kebijakan Publik. Jurnal Ilmiah Dinamika Sosial Vol 3, No. 2, Agustus 2019
Dinas Koperasi dan UMKM. (n.d.). Beranda. Diakses pada 19 Februari 2025, dari https://multisite.bandung.go.id/diskukm/struktur-organisasi/
Hapsari Wulan Septiana. 2023. Collaborative Governance Dalam Percepatan Pencegahan Stunting Di Kabupaten Temanggung. Universitas Tidar
Ika Lenaini. 2021. Teknik Pengambilan Sampel Purposive Dan Snowball Sampling. Historis : Jurnal Kajian, Penelitian & Pengembangan Pendidikan Sejarah. Volume 6 Nomor 1.
J. K. Viosensia, dkk. 2024. Collaborative Governance Dalam Mewujudkan Kota Layak Anak (Kla) Di Kota Surabaya. Journal of Governance and Public Administration (JoGaPA) Volume 1, No 3
K. Bambang, dkk. 2022. Collaborative Governance Dalam Penataan Kawasan Kuliner (Studi Pada Penataan Kawasan Kuliner Di Pasar Lama Kota Tangerang). Jurnal Mozaik Volume XIV Edisi 1 STISIP YUPENTEK.
KBBI. (2024). Arti Kata Dagang. Diakses tanggal 27 September 2024. https://kbbi.web.id/dagang
KBBI. (2024). Arti Kata Kaki Lima. Diakses tanggal 27 September 2024. https://kbbi.web.id/kaki%20lima
M.P.Yitno. 2020. Collaborative Governance Sebagai Basis Pengelolaan Public Affairs. Surakarta : Yuma Pustaka.
Maulana Delly dan Arif Nugroho. 2019. Kebijakan Publik Cara Memahami Kebijakan Publik. Serang : CV. AA Rizky.
N. Farhan Muhammad. 2024. Collaborative Governance Dalam Memanfaatkan Pembangunan Youth Space Di Kota Bandung (Studi Kasus Kecamatan Rancasari). Universitas Islam Negeri Sunan Gunung Djati Bandung.
Pemerintah Kota Bandung. 2011. Peraturan Daerah Kota Bandung Nomor 04 tahun 2011 tentang Penataan dan Pembinaan Pedagang Kaki Lima.
Pemerintah Kota Bandung. 2012. Peraturan Walikota Bandung Nomor 888 Tahun 2012 tentang Petunjuk Pelaksanaan Peraturan Daerah Kota Bandung Nomor 04.
R. A. Farras. 2020. Collaborative Governance Dalam Penanggulangan Hiv/Aids Di Kota Banda Aceh. Universitas Islam Negeri Ar-Raniry Darussalam - Banda Aceh.
S. Sawir Muhammad. 2021. Ilmu Administrasi dan Analisis Kebijakan Publik (Konseptual dan Praktik). Deepublish.
Sulistiyawati. 2023. Buku Ajar Metode Penelitian Kualitatif. Yogyakarta : K-Media.
Sinaga Maddalena. 2021. Collaborative Governance Dalam Pengelolaan Transportasi Umum Di Kota Pekanbaru. Universitas Islam Riau.
Tama Farisa Fasa. 2019. Efektivitas Peraturan Daerah Kabupaten Temanggung Nomor 12 Tahun 2011 Tentang Kebersihan, Keindahan, Ketertiban, Dan Kesehatan Lingkungan (Studi Kasus Terhadap Penertiban Pedagang Kaki Lima). Universitas Muhammadiyah Magelang.
Wardhana Aditya. 2020. Pengantar Ilmu Administrasi dan Manajemen. CV. Media Sains.
Warsono Hardi, dkk. 2019. Teori Administrasi. Semarang : Departemen Administrasi Publik Fakultas Ilmu Sosial dan Ilmu Politik Universitas Diponogoro.
W.D.W Kadek, dkk. 2024. Collaborative Governance. Yogyakarta : Deepublish.
Zakaria, M., Setiawati, I., & Kadarusman, S. (2025). Collaborative Governance dalam Penataan dan Pembinaan Pedagang Kaki Lima di Pasar Kordon Kota Bandung, 2(1). Retrieved from https://ejournal.fisip.unjani.ac.id/index.php/jipolis/article/view/4565
(mysql): SELECT a.*, ug.show_title
FROM authors a
JOIN user_groups ug ON (a.user_group_id=ug.user_group_id)
WHERE a.submission_id = 4565 ORDER BY seq
(mysql): SELECT * FROM author_settings WHERE author_id = '6815'
(mysql): SELECT * FROM author_settings WHERE author_id = '6817'
(mysql): SELECT * FROM author_settings WHERE author_id = '6814'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Mochamad'
AND a.status = 3
AND (aa.middle_name = '' OR aa.middle_name IS NULL)
AND aa.last_name = 'Zakaria'
AND (asl.setting_value = 'Universitas Al-Ghifari')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4565
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4565'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4565
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1626'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Iin'
AND a.status = 3
AND (aa.middle_name = 'Endah')
AND aa.last_name = 'Setiawati'
AND (asl.setting_value = 'Universitas Al-Ghifari')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4565
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4565'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4565
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1626'
(mysql): SELECT DISTINCT
aa.submission_id
FROM authors aa
LEFT JOIN submissions a ON (aa.submission_id = a.submission_id)
LEFT JOIN author_settings asl ON (asl.author_id = aa.author_id AND asl.setting_name = 'affiliation')
WHERE aa.first_name = 'Shaffa'
AND a.status = 3
AND (aa.middle_name = 'Dityani')
AND aa.last_name = 'Kadarusman'
AND (asl.setting_value = 'Universitas Al-Ghifari')
AND (aa.country = 'ID')
(mysql): SELECT ps.*,
s.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_submissions ps
JOIN submissions s ON (ps.submission_id = s.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 = 'en_US')
LEFT JOIN section_settings stl ON (se.section_id = stl.section_id AND stl.setting_name = 'title' AND stl.locale = 'en_US')
LEFT JOIN section_settings sapl ON (se.section_id = sapl.section_id AND sapl.setting_name = 'abbrev' AND sapl.locale = 'en_US')
LEFT JOIN section_settings sal ON (se.section_id = sal.section_id AND sal.setting_name = 'abbrev' AND sal.locale = 'en_US')
WHERE s.submission_id = 4565
(mysql): SELECT * FROM submission_settings WHERE submission_id = '4565'
(mysql): SELECT sf.*, g.*
FROM submission_galleys g
LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)
LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)
WHERE g.submission_id = 4565
AND nsf.file_id IS NULL
ORDER BY g.seq
(mysql): SELECT * FROM submission_galley_settings WHERE galley_id = '1626'
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
(mysql): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND (context_id = 0 OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)
Journal Template
(mysql): UPDATE sessions
SET
user_id = NULL,
ip_address = '216.73.216.103',
user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
created = 1769627381,
last_used = 1769627394,
remember = 0,
data = 'csrf|a:2:{s:9:\"timestamp\";i:1769627395;s:5:\"token\";s:32:\"0a86c31921291b28c59798376dad90f6\";}',
domain = 'ejournal.fisip.unjani.ac.id'
WHERE session_id = '67kundous71arenl0utec1ntq2'
