1

Topic: [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).

2

Re: [Open] After installation and upgrading extensions - Profile error!

BBCode Buttons have disappeared, too!

3

Re: [Open] After installation and upgrading extensions - Profile error!

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...

4

Re: [Open] After installation and upgrading extensions - Profile error!

Ahmed wrote:

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!

Re: [Open] After installation and upgrading extensions - Profile error!

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?

6

Re: [Open] After installation and upgrading extensions - Profile error!

KeyDog wrote:

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,IMPLICIT

KeyDog wrote:

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?

How to have a test environment?

Re: [Open] After installation and upgrading extensions - Profile error!

Btw: What exactely did you upgrade from and to? First I understood your post meant you just upgraded extensions, not a complete board?!

Ahmed wrote:

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 big_smile  )

8

Re: [Open] After installation and upgrading extensions - Profile error!

KeyDog wrote:

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).

Re: [Open] After installation and upgrading extensions - Profile error!

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).

10 (edited by Ahmed 2010-07-14 12:52)

Re: [Open] After installation and upgrading extensions - Profile error!

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

11

Re: [Open] After installation and upgrading extensions - Profile error!

How to change in phpMyAdmin from "profile fields" etc utf8_latvian_ci. to utf8_general_ci ?