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

Software Support
1

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.

2

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

3

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

4

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

5

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()

6

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

7

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

Thanks Alec. You are magnificent :wink:

8

Hi @BMIJ,

Thanks – glad to hear it’s working again!

Regards,
Alec Smecher
Public Knowledge Project Team

9

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

10

Dear Staff

I got the same problem here.
I tried to upgrade my OJS 3.1.2.4 to OJS 3.3.0.14 but was unsuccessful.
I got error after error, first problem was the duplicate column name ‘email_id’, after that context_id didn’t exist, and then assoc_id, assoc_type were not recognized by the system, etc.
I decided not to upgrade and restore my backup, which is the zip file of my public_html folder. My mistake was I didn’t back the database up.

Now, everything looks normal on the outside but when I click on one of the articles shown on the current issue page of my journal I got this same error message "DB Error: Unknown column ‘submission_id’ in ‘where_clause’.

I’m in dire need of someone’s help.

Best Regards
deejournal