DB Error: Unknown column 'submission_id' in 'where clause'

Hi all,

I have a problem. In my journal there is a new submission but when I click the title link for starting process I take an error message.

I tried to start a new submission like a author and I took a message like this:

I didn’t understand what’s the problem. Now the authors can not submit new submissions.

Thanks in advance.

Hi @BMIJ,

What version of OJS are you using? Have you recently attempted to upgrade your installation? What do you see in your PHP error log?

Regards,
Alec Smecher
Public Knowledge Project Team

My ojs version is 2.4.8.1
No I didnt attempt to upgrade.

31 Mar 2017 03:33 tarihinde “Alec Smecher” pkp@forum.pkp.sfu.ca yazdı:

asmecher http://forum.pkp.sfu.ca/users/asmecher Staff
March 31

Hi @BMIJ http://forum.pkp.sfu.ca/users/bmij,

What version of OJS are you using? Have you recently attempted to upgrade
your installation? What do you see in your PHP error log?

Regards,
Alec Smecher
Public Knowledge Project Team

This message “DB Error: Unknown column ‘submission_id’ in ‘where clause’” appears under the whole articles pages.

Hi Alec,

When I turn on show_stacktrace in config.inc.php I take this too long message:

DB Error: Unknown column ‘submission_id’ in ‘where clause’

Stack Trace:

File: /home/bmij/bmij.org/plugins/generic/dataverse/classes/DataverseStudyDAO.inc.php line 57
Function: DAO->retrieve(“SELECT * FROM dataverse_studies WHERE submission_id = ?”, 89)

File: /home/bmij/bmij.org/plugins/generic/dataverse/DataversePlugin.inc.php line 492
Function: DataverseStudyDAO->getStudyBySubmissionId(“89”)

File: (unknown) line (unknown)
Function: DataversePlugin->submissionOutputFilter("

…", Object(TemplateManager))

File: /home/bmij/bmij.org/lib/pkp/lib/smarty/Smarty.class.php line 1269
Function: call_user_func_array(Array(2), Array(2))

File: /home/bmij/bmij.org/lib/pkp/classes/template/PKPTemplateManager.inc.php line 296
Function: Smarty->fetch(“file:/home/bmij/bmij.org/plugins/blocks/languageToggle/block.tpl”, Null, Null, False)

File: /home/bmij/bmij.org/lib/pkp/classes/plugins/BlockPlugin.inc.php line 147
Function: PKPTemplateManager->fetch(“file:/home/bmij/bmij.org/plugins/blocks/languageToggle/block.tpl”)

File: /home/bmij/bmij.org/plugins/blocks/languageToggle/LanguageToggleBlockPlugin.inc.php line 101
Function: BlockPlugin->getContents(Object(TemplateManager))

File: /home/bmij/bmij.org/lib/pkp/classes/plugins/BlockPlugin.inc.php line 161
Function: LanguageToggleBlockPlugin->getContents(Object(TemplateManager), Object(Request))

File: (unknown) line (unknown)
Function: BlockPlugin->callback(“Templates::Common::RightSidebar”, Array(3))

File: /home/bmij/bmij.org/lib/pkp/classes/plugins/HookRegistry.inc.php line 89
Function: call_user_func(Array(2), “Templates::Common::RightSidebar”, Array(3))

File: /home/bmij/bmij.org/lib/pkp/classes/template/PKPTemplateManager.inc.php line 704
Function: HookRegistry->call(“Templates::Common::RightSidebar”, Array(3))

File: /home/bmij/bmij.org/cache/t_compile/mpgTheme^%%32^32D^32D13D85%%header.tpl.php line 71
Function: PKPTemplateManager->smartyCallHook(Array(1), Object(TemplateManager))

File: /home/bmij/bmij.org/lib/pkp/lib/smarty/Smarty.class.php line 1869
Function: include("/home/bmij/bmij.org/cache/t_compile/mpgTheme^%%32^32D^32D13D85%%…")

File: /home/bmij/bmij.org/lib/pkp/classes/template/PKPTemplateManager.inc.php line 211
Function: Smarty->_smarty_include(Array(2))

File: /home/bmij/bmij.org/cache/t_compile/mpgTheme^%%FE^FEB^FEBE8919%%submission.tpl.php line 6
Function: PKPTemplateManager->_smarty_include(Array(2))

File: /home/bmij/bmij.org/lib/pkp/lib/smarty/Smarty.class.php line 1263
Function: include("/home/bmij/bmij.org/cache/t_compile/mpgTheme^%%FE^FEB^FEBE8919%%…")

File: /home/bmij/bmij.org/lib/pkp/classes/template/PKPTemplateManager.inc.php line 296
Function: Smarty->fetch(“sectionEditor/submission.tpl”, Null, Null, True)

File: /home/bmij/bmij.org/lib/pkp/classes/template/PKPTemplateManager.inc.php line 347
Function: PKPTemplateManager->fetch(“sectionEditor/submission.tpl”, Null, Null, True)

File: /home/bmij/bmij.org/pages/sectionEditor/SubmissionEditHandler.inc.php line 134
Function: PKPTemplateManager->display(“sectionEditor/submission.tpl”)

File: (unknown) line (unknown)
Function: SubmissionEditHandler->submission(Array(1), Object(Request))

File: /home/bmij/bmij.org/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(1), Object(Request))

File: /home/bmij/bmij.org/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(1), False)

File: /home/bmij/bmij.org/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))

File: /home/bmij/bmij.org/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))

File: /home/bmij/bmij.org/index.php line 64
Function: PKPApplication->execute()

Hi @BMIJ,

It looks to me like your Dataverse plugin’s schema is out of date (or otherwise incorrect). Are you using the Dataverse plugin? If not, I’d suggest disabling it.

Regards,
Alec Smecher
Public Knowledge Project Team

Ohhh! Very good. I disabled the dataverse plugin and everything turned to well.

Thanks Alec. You are magnificent :wink:

Hi @BMIJ,

Thanks – glad to hear it’s working again!

Regards,
Alec Smecher
Public Knowledge Project Team

Hi asmecher,
I was upgrading my ojs 3.0 to 3.2 and it did not success.
When i was restoring to my file ojs 3.0 and have problem.

DB Error: Unknown column ‘submission_id’ in ‘where clause’

Could you help it?

Thanks
Iwan