1 Topic by thtang (edited by thtang 2005-07-11 15:41)

  • Registered: 2005-07-11
  • Posts: 1

Topic: Cannot register new user. Error: Unable to fetch user info.

I have justed setup the punbb for 2-3 days...i don't know since when it cannot register successfully....

here is my url:
http://georgetang.servehttp.com/punbb/upload/index.php

after register..

the system reports

Error: Unable to fetch user info.


I suspect it's because of the database... but i have no idea how to tackle this...

can anybody advice me? thank you.

(my forum contains some traditional chinese font)

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Cannot register new user. Error: Unable to fetch user info.

http://punbb.org/docs/faq.html#faq2_7

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by Natasha15 (edited by Natasha15 2005-08-15 15:54)

  • Registered: 2005-08-15
  • Posts: 2

Re: Cannot register new user. Error: Unable to fetch user info.

Hello,

I've got the same problem, and activated the debug-mode. Now, following error-message shows up everytime someone wants to register:

An error was encountered
File: /www/7/site9477/wwwroot/board/register.php
Line: 128

PunBB reported: Unable to fetch user info

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

Unfortunately, i don't know what to do. Can anyone help me solving this problem?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Cannot register new user. Error: Unable to fetch user info.

Might I ask which version of MySQL you're using?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-08-15
  • Posts: 2

Re: Cannot register new user. Error: Unable to fetch user info.

Hello,

Of course, I am using the following versions:

- MySQL 4.1.12
- phpMyAdmin 2.6.2

  • From: Dolní Lutyně, Karviná CZ-
  • Registered: 2005-08-21
  • Posts: 3

Re: Cannot register new user. Error: Unable to fetch user info.

I've got absolutely the same problem: File: /www/6/site13206/wwwroot/forum/register.php
Line: 128

PunBB reported: Unable to fetch user info

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

What's new to a solution, Rickardo, can you give me a short Re on how to solve it?

E.mail: dolnilutyne@seznam.cz

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Cannot register new user. Error: Unable to fetch user info.

Are you running the same version of MySQL?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: Dolní Lutyně, Karviná CZ-
  • Registered: 2005-08-21
  • Posts: 3

Re: Cannot register new user. Error: Unable to fetch user info.

I'm using Operating system: Linux, PHP: 5.0.4, Accelerator: N/A
Database: MySQL 4.1.12, Rows: 177, Size: 255.46 KB.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Cannot register new user. Error: Unable to fetch user info.

Mmm, could be this (from the 4.1.12 changelog)

Previously in MySQL 4.1, an Illegal mix of collations error occurred when mixing strings from same character set when one had a non-binary collation and the other a binary collation. Now the binary collation takes precedence, so that both strings are treated as having the binary collation. This restores compatibility with MySQL 4.0 behavior.

  • From: Dolní Lutyně, Karviná CZ-
  • Registered: 2005-08-21
  • Posts: 3

Re: Cannot register new user. Error: Unable to fetch user info.

You wrote:

Mmm, could be this (from the 4.1.12 changelog)
Previously in MySQL 4.1, an Illegal mix of collations error occurred when mixing strings from same character set when one had a non-binary collation and the other a binary collation. Now the binary collation takes precedence, so that both strings are treated as having the binary collation. This restores compatibility with MySQL 4.0 behavior.

-------------------------------------------------------------------
I don't think so, I haven't mixed it, all is standartized and of the same character. What to change or what to do with, those were the questions we miss the answers...

11 Reply by x-byte

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

Re: Cannot register new user. Error: Unable to fetch user info.

I'm having this problem now. What's the solution?