Bug #583

UTF8-conversion fails with PostgreSQL

Added by bb 42 about 2 years ago. Updated about 2 years ago.

Status:Closed Start date:12/10/2009
Priority:Normal Due date:
Assignee:Ryan Gordon % Done:

100%
Category:PostgreSQL
Target version:1.4.12
Reproducibility:Always Database Type:PostgreSQL
Reported In MyBB Version:1.4.10 Database Version:8.1.11
PHP Version:5.2.6 SQA assignments:
Browser:

Description

After setting up MyBB 1.4.10 succesfully with PostgreSQL 8.1 on Debian - I tried to start the UTF8 conversion.

This yielded the following error:
"SQL Error:
42601 - ERROR: syntax error at or near "DEFAULT" LINE 1:
ALTER TABLE mb_adminlog DEFAULT CHARACTER SET utf8 COLLATE u... ^"

The same error occurs when selecting any other single table for conversion.

At the time of creation of the database I already chose the UTF8 encoding - but anyway the explicit converison seems to be obligatory if one wants to use UTF8 encoding.

Associated revisions

Revision 4629
Added by Ryan Gordon about 2 years ago

Fixes UTF8-conversion fails with PostgreSQL (fixes:583)

History

#1
Updated by Ryan Gordon about 2 years ago

It should be disabled for PostgreSQL as there is no supported/tested code to convert PostgreSQL encoding/character sets

#2
Updated by Ryan Gordon about 2 years ago

  • Target version deleted (1.4.10)

#3
Updated by Ryan Gordon about 2 years ago

  • Assignee set to Ryan Gordon
  • Target version set to 1.4.12

#4
Updated by Ryan Gordon about 2 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Applied in changeset r4629.

#5
Updated by Stefan T. about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF