1 Topic by RobvT (edited by Anatoly 2008-11-19 13:24)

  • From: the Netherlands
  • Registered: 2004-12-13
  • Posts: 34

Topic: Incorrect DB collations after upgrading from 1.2

I've updated the forum to 1.3 and had no registrations since.....very strange....

Untill I tried to register myself on the website....I am getting the next error............

An error was encountered

The error occurred on line 1821 in /home/robt/domains/htcclub.net/public_html/include/functions.php

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

PLZ help sad

EDIT: Altered topic subject //Anatoly

HTCClub.net team thx the builders of this great forum.

RobvT's Website

  • From: Tilburg, Netherlands
  • Registered: 2006-02-04
  • Posts: 322

Re: Incorrect DB collations after upgrading from 1.2

What extensions you installed use the hook "fn_check_username_dupe_qr_check_username_dupe" look in there manifext.xml and then in <hook id='fn_check_username_dupe_qr_check_username_dupe">.

kierownik's Website

3 Reply by RobvT

  • From: the Netherlands
  • Registered: 2004-12-13
  • Posts: 34

Re: Incorrect DB collations after upgrading from 1.2

I've let dreamweaver search for "fn_check_username_dupe_qr_check_username_dupe" but it doesn't dind it in any manifext.xml file......

HTCClub.net team thx the builders of this great forum.

RobvT's Website

  • From: Tilburg, Netherlands
  • Registered: 2006-02-04
  • Posts: 322

Re: Incorrect DB collations after upgrading from 1.2

It looks like your database is in two collations. Check your database thru phpmyadmin or something and check if everyting is utf-8.

kierownik's Website

5 Reply by RobvT (edited by RobvT 2008-11-18 21:41)

  • From: the Netherlands
  • Registered: 2004-12-13
  • Posts: 34

Re: Incorrect DB collations after upgrading from 1.2

Hero.....that was the problem indeed.....extensions had other collations then original forum big_smile

Problem solved...topic can close.

HTCClub.net team thx the builders of this great forum.

RobvT's Website

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: Incorrect DB collations after upgrading from 1.2

rob_van_triet wrote:

extensions had other collations then original forum

Still interested in.
What extensions? How did this happen that they had different collations?
Do you DB has latin1_swedish_ci as default collation?

Thanks.

Carpe diem

Anatoly's Website