Defect #7677

Wiki history, diffs and export does not work

Added by Florian Breitwieser over 8 years ago. Updated over 8 years ago.

Status:ClosedStart date:2011-02-21
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution:Invalid Affected version:

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

Duplicated by Redmine - Defect #13321: Wiki show differences doesn't work Closed

History

#1 Updated by Etienne Massip over 8 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).

#2 Updated by Florian Breitwieser over 8 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.

#3 Updated by Etienne Massip over 8 years ago

I personally chose to switch to pg adapter, most reliable and more actively maintained.

Also available in: Atom PDF