Bug 7876 - Submission editing DB syntax error
Submission editing DB syntax error
Status: RESOLVED FIXED
Product: OJS
Classification: Unclassified
Component: Submissions and Publishing
2.4.1
All Linux
: P3 major
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-09-11 03:33 PDT by Giuseppe Digilio
Modified: 2012-09-20 13:15 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:


Attachments
patch for Submission editing DB syntax error (873 bytes, application/octet-stream)
2012-09-11 03:33 PDT, Giuseppe Digilio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Giuseppe Digilio 2012-09-11 03:33:56 PDT
Created attachment 3865 [details]
patch for Submission editing DB syntax error

Hi,
I've obtained a this error while editing submission :

ERROR: syntax error at or near "FROM" LINE 6: ...R(COALESCE(atl.setting_value, atpl.setting_value) FROM 1 FOR... ^

I use PostgreSQL 8.3.17 on x86_64-pc-linux-gnu.
There's a syntax error with function SUBSTR and I've resolved replacing function SUBSTR with SUBTRING in method &_getUnfilteredEditorSubmissions.
Comment 1 Alec Smecher 2012-09-11 09:16:47 PDT
Committed; thanks for contributing!
Comment 2 Alec Smecher 2012-09-11 09:30:02 PDT
SQL standardization for PostgreSQL
https://github.com/pkp/ojs/commit/d6169ff32d6a996b8c127071e0130d9552a59317
Comment 3 Alec Smecher 2012-09-20 13:15:03 PDT
SQL standardization for PostgreSQL
https://github.com/pkp/ojs/commit/0354fedb90e1b84c52dd046dd4e38c4475997e45