(postgres7): SELECT * FROM sessions WHERE session_id = ?   [ (0=>'0a21pr2fkka9c1fb6piunv70l1') ]

(postgres7): INSERT INTO sessions (session_id, ip_address, user_agent, created, last_used, remember, data, domain) VALUES (?, ?, ?, ?, ?, ?, ?, ?)   [ (0=>'0a21pr2fkka9c1fb6piunv70l1') (1=>'54.92.173.9') (2=>'CCBot/2.0 (http://commoncrawl.org/faq/)') (3=>'1527427293') (4=>'1527427293') (5=>'0') (6=>'') (7=>'journal.unusa.ac.id') ]

(postgres7): SELECT * FROM journals WHERE path = ?   [ (0=>'mhsj') ]

(postgres7): SELECT * FROM site  

(postgres7): 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 ((journal_id = ?) OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)   [ (journal=>'6') ]
NOTICE: Undefined offset: 0 (/var/www/html/ejournal/lib/pkp/lib/adodb/drivers/adodb-postgres7.inc.php:118)

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'plugins.generic.usageStats.UsageStatsLoader') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'plugins.generic.alm.ArticleInfoSender') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'plugins.generic.pln.classes.tasks.Depositor') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'plugins.importexport.crossref.CrossrefInfoSender') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'plugins.importexport.crossref.CrossrefInfoSender') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'classes.tasks.ReviewReminder') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'classes.tasks.SubscriptionExpiryReminder') ]

(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ?   [ (0=>'classes.tasks.OpenAccessNotification') ]

(postgres7): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa INNER JOIN articles a ON pa.article_id = a.article_id LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = ? AND stpl.locale = ?) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) INNER JOIN article_settings ast ON a.article_id = ast.article_id WHERE ast.setting_name = ? AND ast.setting_value = ? ORDER BY pa.issue_id, a.article_id   [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'pub-id::publisher-id') (9=>'593') ]

(postgres7): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = ? AND stpl.locale = ?) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) WHERE pa.article_id = a.article_id AND a.article_id = ?   [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'593') ]

(postgres7): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = ? ORDER BY g.seq   [ (0=>'593') ]

(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ?   [ (0=>'513') ]

(postgres7): SELECT * FROM article_settings WHERE article_id = ?   [ (0=>'593') ]

(postgres7): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = ? ORDER BY s.seq   [ (0=>'593') ]

(postgres7): SELECT i.* FROM issues i WHERE issue_id = ?   [ (0=>'65') ]

(postgres7): SELECT * FROM issue_settings WHERE issue_id = ?   [ (0=>'65') ]

(postgres7): SELECT iss.subscription_id FROM institutional_subscriptions iss, subscriptions s, subscription_types st WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(?, LENGTH(?)+1, '.'))) != 0 AND iss.domain != '' AND iss.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)   [ (0=>'ec2-54-92-173-9.compute-1.amazonaws.com') (1=>'ec2-54-92-173-9.compute-1.amazonaws.com') (2=>'6') ]

(postgres7): SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND ? >= isip.ip_start AND ? <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND ? = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))   [ (0=>'912043273') (1=>'912043273') (2=>'6') (3=>'912043273') (4=>'6') ]

(postgres7): SELECT * FROM sections WHERE section_id = ?   [ (0=>'7') ]

(postgres7): SELECT * FROM section_settings WHERE section_id = ?   [ (0=>'7') ]

(postgres7): SELECT * FROM sections WHERE section_id = ?   [ (0=>'7') ]

(postgres7): SELECT * FROM section_settings WHERE section_id = ?   [ (0=>'7') ]

(postgres7): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.galley_id = ? AND g.article_id = ?   [ (0=>'513') (1=>'593') ]

(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ?   [ (0=>'513') ]

(postgres7): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa INNER JOIN articles a ON pa.article_id = a.article_id LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = ? AND stpl.locale = ?) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) INNER JOIN article_settings ast ON a.article_id = ast.article_id WHERE ast.setting_name = ? AND ast.setting_value = ? ORDER BY pa.issue_id, a.article_id   [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'pub-id::publisher-id') (9=>'593') ]

(postgres7): SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = ? AND stpl.locale = ?) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) WHERE pa.article_id = a.article_id AND a.article_id = ?   [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'593') ]

(postgres7): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = ? ORDER BY g.seq   [ (0=>'593') ]

(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ?   [ (0=>'513') ]

(postgres7): SELECT * FROM article_settings WHERE article_id = ?   [ (0=>'593') ]

(postgres7): SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = ? ORDER BY s.seq   [ (0=>'593') ]

(postgres7): SELECT i.* FROM issues i WHERE issue_id = ?   [ (0=>'65') ]

(postgres7): SELECT * FROM issue_settings WHERE issue_id = ?   [ (0=>'65') ]

(postgres7): SELECT iss.subscription_id FROM institutional_subscriptions iss, subscriptions s, subscription_types st WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(?, LENGTH(?)+1, '.'))) != 0 AND iss.domain != '' AND iss.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)   [ (0=>'ec2-54-92-173-9.compute-1.amazonaws.com') (1=>'ec2-54-92-173-9.compute-1.amazonaws.com') (2=>'6') ]

(postgres7): SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND ? >= isip.ip_start AND ? <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND ? = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = ? AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2018-05-27 13:21:33' >= s.date_start AND '2018-05-27 13:21:33' <= s.date_end))) AND (st.format = 1 OR st.format = 17)))   [ (0=>'912043273') (1=>'912043273') (2=>'6') (3=>'912043273') (4=>'6') ]

(postgres7): SELECT g.*, a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.galley_id = ? AND g.article_id = ?   [ (0=>'513') (1=>'593') ]

(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ?   [ (0=>'513') ]

(postgres7): SELECT * FROM journals WHERE journal_id = ?   [ (0=>'6') ]

(postgres7): 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 ((journal_id = ?) OR v.sitewide = 1) WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)   [ (journal=>'6') ]
NOTICE: Undefined offset: 0 (/var/www/html/ejournal/lib/pkp/lib/adodb/drivers/adodb-postgres7.inc.php:118)

(postgres7): SELECT a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = ? AND stpl.locale = ?) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) WHERE article_id = ?   [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'593') ]

(postgres7): SELECT * FROM article_settings WHERE article_id = ?   [ (0=>'593') ]

(postgres7): SELECT a.* FROM article_files a WHERE file_id = ? AND article_id = ? ORDER BY revision DESC LIMIT 1   [ (0=>'1824') (1=>'593') ]

(postgres7): UPDATE sessions SET user_id = ?, ip_address = ?, user_agent = ?, created = ?, last_used = ?, remember = ?, data = ?, domain = ? WHERE session_id = ?   [ (0=>'') (1=>'54.92.173.9') (2=>'CCBot/2.0 (http://commoncrawl.org/faq/)') (3=>'1527427293') (4=>'1527427293') (5=>'0') (6=>'') (7=>'journal.unusa.ac.id') (8=>'0a21pr2fkka9c1fb6piunv70l1') ]