Defect #7677
closed
Wiki history, diffs and export does not work
0%
Description
When accessing the history version of a Wiki page (e.g. Wiki?version=16), just a string which is not human readable is displayed. It starts like this and is about 5000 characters long:
\x68312e204d532050726f63657373696e6720506970656c696e670d0a0d0a68322e2047656e6572616c2073657475700d0a0d0a57696e646f7773206d616368696e657320617474616368656420746f206d61737370656320617265207573656420746f20636f70792066696c657320746f206365727461696e206c6f636174696f6e732e20402f72
Same result for exporting TXT or HTML of the current version, and a Wiki-diff just diffs between two such strings.
There's no error/warning message in the log
Thanks for your help and Redmine!
Versions:
Redmine 1.1.0
Ruby 1.8.6
Rails 2.3.5
Rack 1.0.1
Postgres 9.0.2, migrated from Redmine 1.0
Log msg:
Processing WikiController#show (for 193.171.186.112 at 2011-02-21 16:55:35) [GET]
Parameters: {"project_id"=>"mspipeline", "action"=>"show", "id"=>"Wiki", "version"=>"4", "controller"=>"wiki"}
Rendering template within layouts/base
Rendering wiki/show
Completed in 570ms (View: 525, DB: 31) | 200 OK [http://head1/redmine/projects/mspipeline/wiki/Wiki?version=4]
Related issues
Updated by Etienne Massip almost 14 years ago
- Status changed from New to Closed
- Resolution set to Invalid
It's a bug with postgres-pr adapter, see this issue.
Either you change your configuration at db level or you use pg adapter (not native but actively maintained).
Updated by Florian Breitwieser almost 14 years ago
Thank you for the hint, Etienne. PostgreSQL 9 introduced a new 'hex' format for bytea data input and output. Default for output is now hex, but it can be easily reverted to the old 'escape' format with the following command:
ALTER DATABASE redmine SET bytea_output TO 'escape';
This affects all Postgres 9.0 users, so I added a HowTo make Wiki history working with Postgres 9.0.
Updated by Etienne Massip almost 14 years ago
I personally chose to switch to pg adapter, most reliable and more actively maintained.