Defect #7677

Wiki history, diffs and export does not work

Added by Florian Breitwieser almost 11 years ago. Updated almost 11 years ago.

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


Target version:-
Resolution:Invalid Affected version:


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:


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!

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 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


#1 Updated by Etienne Massip almost 11 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 almost 11 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 almost 11 years ago

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

Also available in: Atom PDF