1 Topic by x-byte (edited by x-byte 2006-07-09 13:03)

  • x-byte
  • Junior Member
  • Offline
  • Registered: 2006-02-22
  • Posts: 6

Topic: User registration error

I have this problem when a user is trying to register on my forum. Seems it's an issue when I tried using UTF8 encoding for the forum.

The error I get is this (debuging on)

File: /usr/home/web/wno65308/wii-fan.net/forum/register.php
Line: 135

PunBB reported: Unable to fetch user info 

Database reported: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (Errno: 1267)

edit: I've done this modification:
http://punbb.org/forums/viewtopic.php?id=9146

Also, I did upgrade from 1.2 to 1.2.11 a while ago. Could have something to do with this.

2 Reply by x-byte (edited by x-byte 2006-07-09 16:56)

  • x-byte
  • Junior Member
  • Offline
  • Registered: 2006-02-22
  • Posts: 6

Re: User registration error

Hmm.. Seems that I found a solution.

What I did is that I change the username encoding to be the same as the database: "utf8_general_ci" instead of "Latin1_swedish_ci". Sems to work.

Is there any concerns about this?

EDIT: I now get a lot of overhead in my database. Also now I get an error about that it can't fetch subrscribtions... Looks like it affects only new users.