You are not logged in. Please login or register.
PunBB Forums → PunBB 1.3 troubleshooting → [Open] After installation and upgrading extensions - Profile error!
Installed and upgraded many official extensions. Got this:
An error was encountered
The error occurred on line 40 in D:\Hosting\mywebsite\htdocs-forum\profile.php(1646) : eval()'d code
Database reported: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_latvian_ci,IMPLICIT) for operation '=' (Errno: 1267).
BBCode Buttons have disappeared, too!
I got back part of BBCode buttons. I have two extensions: oficial and "BBCode extended". Disapeared those yellow smilies line on right side a top of post. Left side is back...
Installed and upgraded many official extensions. Got this:
An error was encountered
The error occurred on line 40 in D:\Hosting\mywebsite\htdocs-forum\profile.php(1646) : eval()'d code
Database reported: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_latvian_ci,IMPLICIT) for operation '=' (Errno: 1267).
Anybody? I can not get in any profile - I get error. But I need to change some people groups.
HEEEEEEEEEEEEEEEELP!
Can you change peoples groups if you change back into english language version...? (maybe your installed extensions language files aren't compatible?)
Also as you have such a busy forum, don't you have test environment to turn on and off extensions to see which are causing problems?
Can you change peoples groups if you change back into english language version...? (maybe your installed extensions language files aren't compatible?)
I have two language interfaces.
1) english (default, I am using it, too)
2) russian. We do not have latvian interface or modifications, so I am confused why here is mentioned this:
utf8_latvian_ci,IMPLICITAlso as you have such a busy forum, don't you have test environment to turn on and off extensions to see which are causing problems?
How to have a test environment?
Btw: What exactely did you upgrade from and to? First I understood your post meant you just upgraded extensions, not a complete board?!
How to have a test environment?
I find it useful to have a subdomain which is live where I can play around turning on and off extensions...
If your database is causing problems, maybe your host can help you... (I've had problems with my mysql db in the past and my hosts support team solved it - well they messed something up in the first place 
)
Btw: What exactely did you upgrade from and to? First I understood your post meant you just upgraded extensions, not a complete board?!
Only extensions. Installed several (3-5) and upgraded several (5-9).
I have found one reason why this error may be appearing. The solution is described in the MySQL Lists, but in PunBB "set names" is used on every page.
Could you post a collation for PunBB tables here, please? (You can view it via phpmyadmin).
All is utf8_general_ci except "profile fields", "profile fields entries", log_forums, log_topics, messages, spam_repository who are utf8_latvian_ci.
Table Action RecordsTip Type Collation Size Overhead
answers Browse Structure Search Insert Empty Drop 8 MyISAM utf8_general_ci 2.5 KiB -
attach_files Browse Structure Search Insert Empty Drop 4 MyISAM utf8_general_ci 2.7 KiB -
bans Browse Structure Search Insert Empty Drop 7 MyISAM utf8_general_ci 3.3 KiB 164 B
categories Browse Structure Search Insert Empty Drop 4 MyISAM utf8_general_ci 2.2 KiB -
censoring Browse Structure Search Insert Empty Drop 0 MyISAM utf8_general_ci 1.0 KiB -
config Browse Structure Search Insert Empty Drop 115 MyISAM utf8_general_ci 33.2 KiB 304 B
extensions Browse Structure Search Insert Empty Drop 21 MyISAM utf8_general_ci 11.6 KiB 20 B
extension_hooks Browse Structure Search Insert Empty Drop 254 MyISAM utf8_general_ci 242.9 KiB -
forums Browse Structure Search Insert Empty Drop 12 MyISAM utf8_general_ci 5.8 KiB 708 B
forum_perms Browse Structure Search Insert Empty Drop 40 MyISAM utf8_general_ci 2.5 KiB 12 B
groups Browse Structure Search Insert Empty Drop 19 MyISAM utf8_general_ci 4.1 KiB -
log_forums Browse Structure Search Insert Empty Drop 1,242 MyISAM utf8_latvian_ci 43.8 KiB 204 B
log_topics Browse Structure Search Insert Empty Drop 4,088 MyISAM utf8_latvian_ci 169.6 KiB 782 B
messages Browse Structure Search Insert Empty Drop 7,612 MyISAM utf8_latvian_ci 4.7 MiB 22.3 KiB
online Browse Structure Search Insert Empty Drop 6 MEMORY utf8_general_ci 111.0 KiB 11.8 KiB
posts Browse Structure Search Insert Empty Drop 23,966 MyISAM utf8_general_ci 30.3 MiB -
profile_fields Browse Structure Search Insert Empty Drop 2 MyISAM utf8_latvian_ci 2.0 KiB -
profile_field_entries Browse Structure Search Insert Empty Drop 144 MyISAM utf8_latvian_ci 8.5 KiB -
pun_invitations_only Browse Structure Search Insert Empty Drop 0 MyISAM utf8_general_ci 2.0 KiB -
pun_pm_messages Browse Structure Search Insert Empty Drop 3,850 MyISAM utf8_general_ci 3.4 MiB -
pun_stop_bots_questions Browse Structure Search Insert Empty Drop 2 MyISAM utf8_general_ci 2.1 KiB -
questions Browse Structure Search Insert Empty Drop 2 MyISAM utf8_general_ci 2.2 KiB -
ranks Browse Structure Search Insert Empty Drop 66 MyISAM utf8_general_ci 4.5 KiB -
reports Browse Structure Search Insert Empty Drop 71 MyISAM utf8_general_ci 33.0 KiB -
search_cache Browse Structure Search Insert Empty Drop 3 MyISAM utf8_general_ci 34.7 KiB 30.7 KiB
search_matches Browse Structure Search Insert Empty Drop 2,086,313 MyISAM utf8_general_ci 59.9 MiB -
search_words Browse Structure Search Insert Empty Drop 266,804 MyISAM utf8_general_ci 14.3 MiB -
spam_repository Browse Structure Search Insert Empty Drop 0 MyISAM utf8_latvian_ci 1.0 KiB -
subscriptions Browse Structure Search Insert Empty Drop 33 MyISAM utf8_general_ci 2.3 KiB -
tags Browse Structure Search Insert Empty Drop 1 MyISAM utf8_general_ci 2.2 KiB 148 B
topics Browse Structure Search Insert Empty Drop 382 MyISAM utf8_general_ci 69.4 KiB 56 B
topics_lock Browse Structure Search Insert Empty Drop 0 MyISAM utf8_general_ci 1.0 KiB -
topic_tags Browse Structure Search Insert Empty Drop 2 MyISAM utf8_general_ci 2.1 KiB 39 B
users Browse Structure Search Insert Empty Drop 689 MyISAM utf8_general_ci 150.9 KiB 40 B
voting Browse Structure Search Insert Empty Drop 7 MyISAM utf8_general_ci 2.1 KiB -
35 table(s) Sum 2,395,769 InnoDB utf8_general_ci 113.7 MiB 67.2 KiB
With selected: Check All / Uncheck All / Check tables having overhead
How to change in phpMyAdmin from "profile fields" etc utf8_latvian_ci. to utf8_general_ci ?
PunBB Forums → PunBB 1.3 troubleshooting → [Open] After installation and upgrading extensions - Profile error!
Powered by PunBB, supported by Informer Technologies, Inc.