News: Welcome to the TinyPortal Support site.

Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

December 12, 2019, 10:53:21 PM

Login with username, password and session length


  • Total Posts: 189280
  • Total Topics: 20775
  • Online Today: 70
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 1
Guests: 55
Total: 56

Author Topic: Database Error Illegal mix of collations  (Read 3613 times)

0 Members and 1 Guest are viewing this topic.

Offline imissu

  • Newbie
  • *
  • Posts: 4
Database Error Illegal mix of collations
« on: May 08, 2011, 02:36:42 PM »
Link to my site:
SMF version: SMF ver. 2.0RC5
TP version: TP ver. 1.0RC1
Default Forum Language: English
Theme name and version: Anecdota by, Crip
Browser Name and Version: Firefox 4.01
Mods installed: TinyPortal
Related Error messages: Error message here

Additional language is Indonesian (Non utf-8) (not default)

Database Error
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: /home/xxx/public_html/Sources/TPortalAdmin.php
Line: 1294  :tickedoff:

Could you help me ?
Thank you

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Database Error Illegal mix of collations
« Reply #1 on: May 09, 2011, 09:33:33 AM »
This has been brought up a few times before. Please take a look at some of the topics HERE