Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11833
Latest: playwyourlifenotme
New This Month: 1
New This Week: 1
New Today: 1
Stats
Total Posts: 42303
Total Topics: 7379
Most Online Today: 116
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 39
Total: 39

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

0 Members and 1 Guest are viewing this topic.

Offline Shades

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • 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

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • 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: 16037
    • 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

  • Community Suite Customer
  • Full Member
  • ******
  • Posts: 185
  • 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: 16037
    • 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
204 Views
Last post March 14, 2022, 04:06:44 am
by ke

+- Recent Topics

Trying to access array offset on value of type null by SMFHacks
Today at 03:58:54 pm

SMF forum by davejo
June 27, 2022, 01:16:25 am

Quick-moderation checkboxes by davejo
June 22, 2022, 09:27:24 am

Add option to Main Menu bar by Shades
June 21, 2022, 12:23:00 am

Logo and Category? by SMFHacks
June 12, 2022, 03:43:31 pm

prettyurls - TroubleShooting.wiki by GhostHunting
June 12, 2022, 02:52:57 pm

[Mod]Modification Update Version Checker by SMFHacks
June 06, 2022, 09:25:39 pm

Profile Gallery Link by SMFHacks
June 02, 2022, 05:17:45 pm

SMF Store 5.0 Beta Errors - Trying to access array offset on value of type null by Michael Vail
June 01, 2022, 12:48:48 pm

Upgrade Issues? by SMFHacks
May 30, 2022, 06:24:03 pm

Powered by EzPortal