Bug 7876 – Submission editing DB syntax error

Bug 7876 - Submission editing DB syntax error

Summary:

Submission editing DB syntax error

Status:	RESOLVED FIXED

Product:	OJS
Classification:	Unclassified
Component:	Submissions and Publishing
Version:	2.4.1
Platform:	All Linux

Importance:	P3 major
Assigned To:	PKP Support

URL:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2012-09-11 03:33 PDT by Giuseppe Digilio
Modified:	2012-09-20 13:15 PDT (History)
CC List:	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
View All Add an attachment (proposed patch, testcase, etc.)

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