DB Error on Reviewer search

[JohnGrobler]

Good day,

When trying to perform a search on the Select Reviewer screen (/director/selectReviewer), I receive the following error:
DB Error: Unknown column 'p.paper_id' in 'order clause'

This error occurs on OCS version 2.3.0.0 and 2.3.2.0 on our site upgraded from version 2.1.1.2. Can anyone confirm if they also receive this error on the reviewer search function please? The function can be accessed from User Home > Director > Unassigned > Select any title > Paper Review > Select Reviewer > Search for anything.

Thank you,
John Grobler

[jmacgreg]

Hi John,

Can you confirm that you are experiencing this error in a fully-upgraded OCS 2.3.2? I believe this was fixed in OCS 2.3.2 -- see http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=5384. You may want to take a look at the patch attached to that report and double-check that the fix has been applied to your install.

Cheers,
James

[JohnGrobler]

Hi James,

Thanks for the reply. I've redownloaded OCS 2.3.2 from the PKP download page and looked at the file classes/submission/trackDirector/TrackDirectorSubmissionDAO.inc.php. The additional line added by bugfix 5384 (http://pkp.sfu.ca/bugzilla/attachment.c ... ction=edit) is not in the OCS 2.3.2 code. I've manually added the line to this file on my server which resolved the issue. Can this line be added to the file in the next release of OCS?

Thanks,
John Grobler

[jmacgreg]

Hi John,

It looks like I mis-read when that was added to the repository -- it didn't make it into 2.3.2, but it's included for sure now. Glad to hear everything is working!

Cheers,
James

[mendesrocha]

Hi!

I found a very similar error.

As "Conference Director" I try to edit metadata of a submission, I can insert a new author, but when I click to save the information, OCS 2.3.3.1 returns the following:

DB Error: Column 'paper_id' cannot be null

[mendesrocha]

Same error again. As an "author" when I try to add a second author in editing submission metadada.

[davidsorfa]

In 2.3.3.1 I get the same error when trying to add a second author to metadata (both as director and as author):

DB Error: Column 'paper_id' cannot be nul

There does not appear to be a fix in the "Recommended Patches" wiki (http://pkp.sfu.ca/wiki/index.php/OCS_2. ... ed_Patches)

David

[mendesrocha]

Hi

I think I found the solution for this bug:

As "Conference Director" I try to edit metadata of a submission, I can insert a new author, but when I click to save the information, OCS 2.3.3.1 returns the following:

DB Error: Column 'paper_id' cannot be null

The solution is in ocs/classes/submission/form/MetadataForm.inc.php at line 217

is to replace the

Code: Select all

   } else {
            // Create a new author
-            $author = new Author();


for

Code: Select all

   } else {
            // Create a new author
+            $author = &new Author();


Can anyone from PKP confirm it?

[asmecher]

Hi all,

See http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=6552.

Regards,
Alec Smecher
Public Knowledge Project Team