There is an obivous syntax error in the SQL statement in the _filemanager_find_directory() function. MySQL seems to ignore this error. However, PostGreSQL does not allow aliasing of columsn without an "AS" statement.

Attached patch fixes this.

CommentFileSizeAuthor
#1 filemanager.pgsql_0.patch1.25 KBsun
filemanager.pgsql.patch814 bytessun

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
StatusFileSize
new filemanager.pgsql_0.patch1.25 KB

filemanager_get_area_info() also contains a SQL alias which needs the "AS" statement.

Patch updated.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Successfully tested on Windows and Linux, both with PostGreSQL 8.1.

drewish’s picture

drewish commented
Status: Reviewed & tested by the community » Fixed

Applied the same changes from #78749.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)