Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4268
Latest: Butiks
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43583
Total Topics: 7566
Most Online Today: 27
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 30
Total: 30

Author Topic: Illegal mix of collations  (Read 1202 times)

0 Members and 1 Guest are viewing this topic.

Offline Shades

  • Full Member
  • ***
  • Posts: 219
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Illegal mix of collations
« on: May 01, 2022, 03:11:57 pm »
SMF 2.1.1
Newsletter Pro 4.0beta2

When trying to view a "List" I get:

Code: [Select]
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
File: /home2/*****/public_html/*****/Themes/default/NewsPro2.1.template.php
Line: 477

Code: [Select]
Error
Type of error
Database
Error message
Database Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
File
/home2/*****/public_html/*****/Themes/default/NewsPro2.1.template.php
Line
477
URL of page causing the error
https://*****.com/index.php?action=admin;area=newspro;sa=viewlist;id=1

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Themes/default/NewsPro2.1.template.php on line 477
#2: template_view_list()
Called from /home2/*****/public_html/*****/Sources/Load.php on line 2744
#3: loadSubTemplate()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 4147
#4: obExit()
Called from /home2/*****/public_html/*****/index.php on line 190

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline Shades

  • Full Member
  • ***
  • Posts: 219
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Illegal mix of collations
« Reply #1 on: May 06, 2022, 03:40:49 pm »
Quote
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
File: /home2/*****/public_html/*****/Themes/default/NewsPro2.1.template.php
Line: 477
Really not sure why I posted this except for the simple fact that I forgot I could change the collations in phpadmin! ::)

So this one is solved! ;D  8)

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16580
    • View Profile
Re: Illegal mix of collations
« Reply #2 on: May 06, 2022, 04:08:20 pm »
Which tables did  you change?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Shades

  • Full Member
  • ***
  • Posts: 219
  • Community Suite Customer
    • View Profile
    • Bikerhound.com
Re: Illegal mix of collations
« Reply #3 on: May 06, 2022, 08:27:31 pm »
I changed newslist_01_05_22_1_38_16 table from utf8_unicode_ci to utf8_general_ci since all the other table were set to utf8_general_ci. Did I do it right? I have no more errors yet since I changed it!

ShadesWeb.com - Custom Logos
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16580
    • View Profile
Re: Illegal mix of collations
« Reply #4 on: May 07, 2022, 02:25:37 pm »
Posted a new release for SMF 2.0.x and SMF 2.1x that assumes utf8_general_ci  is the default character set.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/
Like Like x 1 View List

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
1532 Views
Last post March 14, 2022, 04:06:44 am
by ke

+- Recent Topics

Weird setup by SMFHacks
November 07, 2024, 06:37:41 am

Restoring a deleted photo by Monocero
November 01, 2024, 04:23:56 am

Gallery Pro reinstalation by Lirorobert
October 14, 2024, 01:43:43 am

Move picture from main gallery to user gallery by SMFHacks
October 11, 2024, 09:11:00 pm

quoting part of message by Lirorobert
October 04, 2024, 03:21:40 pm

Does SMF Gallery support by SMFHacks
October 02, 2024, 06:14:26 am

Item count on Gallery Tab shows double by SMFHacks
September 26, 2024, 12:59:20 pm

Forum post missing when image over 4000x pixels is uploaded to gallery by Michel68
September 24, 2024, 01:37:17 pm

Setting a photo as invisible by Monocero
September 17, 2024, 02:11:56 pm

Two gallery names by SMFHacks
September 15, 2024, 02:17:49 pm

Powered by EzPortal