[OJS 2.4.6] How delete a journal, when the delete button from manager interface does not work?

juancure · March 16, 2019, 12:35am

Hi everyone I have an OJS 2.4.6 with 107 journals. I need to delete some journals from this OJS, I have used the Delete button from the manager interface, some of these journals have been removed and the process took me into the list journals view, however with a specific journal this process shows me a white page and the following URL base_url/ojs/index.php/index/admin/deleteJournal/44 and the journal was not been removed and when I come back to the list journals view I can see the journal yet, except the title, I left below an image that shows the scenario. It’s for that I have some questions about, these are my questions:

What is the correct way to delete a journal from database?

Why this journal could not been removed?

%5B1%5Dantropologia_h

I hope someone of the PKP team could help me to resolve this topic.

Best regards

ajnyga · March 17, 2019, 6:53am

I guess you could track down from deleteJournal code what databases are actually removed.

But when you try to delete that journal and get a white page, do you see any errors in error log?

juancure · March 21, 2019, 8:38pm

Hi @ajnyga thanks a lot for your response, however I have some doubts, what did you refer, when you said "track down from deleteJournal code"? How is the way to check that?, with respect to my php error logs, there was not message of error when I clicked the delete button from admin interface.

This is the resulting white page:

Best regards

ajnyga · March 22, 2019, 6:58am

In general white pages should always generate an error. You could check your error settings from config.inc.php.

If you still do not see an error then the function called by deleteJournal is here:

github.com

pkp/ojs/blob/ojs-stable-2_4_8/classes/journal/JournalDAO.inc.php#L147-L200


	function deleteJournalById($journalId) {
		if (HookRegistry::call('JournalDAO::deleteJournalById', array(&$this, &$journalId))) return;

		$journalSettingsDao =& DAORegistry::getDAO('JournalSettingsDAO');
		$journalSettingsDao->deleteSettingsByJournal($journalId);

		$sectionDao =& DAORegistry::getDAO('SectionDAO');
		$sectionDao->deleteSectionsByJournal($journalId);

		$issueDao =& DAORegistry::getDAO('IssueDAO');
		$issueDao->deleteIssuesByJournal($journalId);

		$emailTemplateDao =& DAORegistry::getDAO('EmailTemplateDAO');
		$emailTemplateDao->deleteEmailTemplatesByJournal($journalId);

		$rtDao =& DAORegistry::getDAO('RTDAO');
		$rtDao->deleteVersionsByJournal($journalId);

		$subscriptionDao =& DAORegistry::getDAO('IndividualSubscriptionDAO');
		$subscriptionDao->deleteSubscriptionsByJournal($journalId);

This file has been truncated. show original

You could use that function to track down which tables are affected. But you could also add for example error_log("Got this far"); around here ojs/JournalDAO.inc.php at ojs-stable-2_4_8 · pkp/ojs · GitHub. This will give you a clue where the code crashes.

If you do not see that message in the error log, you can move it for example here ojs/JournalDAO.inc.php at ojs-stable-2_4_8 · pkp/ojs · GitHub and see again if you can see the error message.