Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 179
Total: 179

Author Topic: Illegal mix of collations  (Read 1050 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: 16436
    • 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: 16436
    • 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
1173 Views
Last post March 14, 2022, 04:06:44 am
by ke

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal