Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#4157] - [29550] disable escape_string_warning option postgres

? Success

User tests: Successful: Unsuccessful:

avatar brianteeman
brianteeman
23 Aug 2014

With Joomla 3.0.1, using Postgresql 9.1, the following warning appears in PostgreSQL logs many many times:

WARNING: nonstandard use of \ in a string literal at character 187
HINT: Use the escape string syntax for backslashes, e.g., E'\'.

These warnings appears because Joomla use backslashes as escape characters (ie standard_conforming_strings is disabled).

This PR disables "escape_string_warning" option. This option is supported since PostgreSQL 8.1

avatar brianteeman brianteeman - open - 23 Aug 2014
avatar jissues-bot jissues-bot - change - 23 Aug 2014
Status Pending ⇒ New
Labels Added: ?
avatar brianteeman brianteeman - change - 24 Aug 2014
Title
…
[29550] disable escape_string_warning option
[29550] disable escape_string_warning option postgres
avatar brianteeman brianteeman - change - 24 Aug 2014
Status New ⇒ Pending
avatar brianteeman brianteeman - change - 25 Aug 2014
Category ⇒ Postgresql
avatar nicksavov nicksavov - change - 16 Oct 2014
Labels Added: ?
avatar waader
waader - comment - 16 Oct 2014

@test
I tested with Joomla 3.3.7-dev and Postgresql 9.3.5 and could reproduce the issue. The proposed patch solves the issue.

avatar waader waader - test_item - 16 Oct 2014 - Tested successfully
avatar wilsonge
wilsonge - comment - 19 Oct 2014

@test
Tested with staging and Postgres 9.3.5 after a nightmare trying to find the error log in windows found it, saw the notices described. Patch stopped anymore from appearing doing some brief browsing around which should generate queries. Sucessful Result. RTC.

avatar wilsonge wilsonge - test_item - 19 Oct 2014 - Tested successfully
avatar wilsonge wilsonge - change - 19 Oct 2014
Status Pending ⇒ Ready to Commit
avatar Bakual Bakual - change - 24 Oct 2014
Milestone
avatar Bakual Bakual - close - 24 Oct 2014
avatar Bakual Bakual - close - 24 Oct 2014
avatar Bakual Bakual - change - 24 Oct 2014
Status Ready to Commit ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2014-10-24 14:04:24
avatar Bakual
Bakual - comment - 24 Oct 2014

Merged into staging. Thanks!

avatar mbabker mbabker - change - 22 Nov 2014
Milestone
avatar mbabker mbabker - change - 22 Nov 2014
Milestone Added:
avatar mbabker mbabker - change - 22 Nov 2014
Milestone Added:
avatar mbabker mbabker - change - 22 Nov 2014
Milestone
avatar brianteeman brianteeman - head_ref_deleted - 20 Dec 2014

Add a Comment

Login with GitHub to post a comment