SMFHacks.com
Newsletter Pro => Support => Topic started by: Shades on May 01, 2022, 03:11:57 pm
-
SMF 2.1.1
Newsletter Pro 4.0beta2
When trying to view a "List" I get:
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
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
-
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)
-
Which tables did you change?
-
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!
-
Posted a new release for SMF 2.0.x and SMF 2.1x that assumes utf8_general_ci is the default character set.