- summary: Cannot enter un comment with single quote in Postgresql --> Cannot enter a comment with single quote in Postgresql
- Group: --> Database
Hello,
We have a serious bug when our users enter a comment with a single quote.
The history of the page is corrupted (this is reproducible), and some strange
things might happen afterwards. For example, in some of our pages, the Table of
Contents is no longer displayed.
If a page is edited and saved with a single quote in the summary, data of this page
(editor, summary, ...) are not displayed when history is requested.
This bug appends when a PostgreSQL server is used.
In this case, function 'set_versiondata' of PearDB.php is called (because
this function doesn't exist in PearDB_pgsql.php) and 'set_versiondata' call
'_serialize' defined in PearDB_pgsql.php.
But this '_serialize' function 'quotes' data while 'set_versiondata' assumes
it is not done.
The lenght of the serialized data is incorrect.
In file PearDB_pgsql.php
comment out function _serialize($data)
Can you please confirm that the correction is OK so that I can commit in CVS?
Thank you in advance.