Its works for "Members today", but not for "This week/Last 7 days"...
:-(

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

Reinstalled and it works. Thanks.

It still rejects to be downloaded...
:-(

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

31

(61 replies, posted in PunBB 1.3 extensions)

zergnm wrote:
Ahmed wrote:

"Colored usergroups" does not work in "Improved online list"
It works all outside, but where is "Users today" or "Users this week" there is no colors except default.

How to solve it?

http://punbb.informer.com/forums/topic/ … ps/page/2/

Error 404 - File Not Found

32

(1 replies, posted in PunBB 1.3 troubleshooting)

Ahmed wrote:

This is old one error. Extension "Move post" for some reason do not work. I got:

PHP Notice:  Undefined index:  Destination forum in D:\Hosting\mywebsite\htdocs-forum\extensions\pun_move_posts\move_posts.php on line 97


I have PunBB 1.32

No one have an idea what is wrong?

zergnm wrote:

I hadnt wait until someoe will make that, and did it by myself

http://img684.imageshack.us/img684/8241/qweg.png

There's the new manifest.xml file for Impoved Online List extension by YonasH.
manifest.rar - 0.00MB

Replace the old file with this new one, then go to
Administration -> Extensions -> Impoved Online List -> Refresh hooks.

That's all. Sorry for my English.

Error 404 - File Not Found

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

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?

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!

37

(7 replies, posted in PunBB 1.3 troubleshooting)

Slavok wrote:

You need to update Pun Poll to the latest 1.1.10 version.

Upgrading and leaving emtpty those fields for vote limiti and time worked. Managed to post a poll.
Spasiba.

38

(1 replies, posted in PunBB 1.3 troubleshooting)

This is old one error. Extension "Move post" for some reason do not work. I got:

PHP Notice:  Undefined index:  Destination forum in D:\Hosting\mywebsite\htdocs-forum\extensions\pun_move_posts\move_posts.php on line 97


I have PunBB 1.32

39

(61 replies, posted in PunBB 1.3 extensions)

"Colored usergroups" does not work in "Improved online list"
It works all outside, but where is "Users today" or "Users this week" there is no colors except default.

How to solve it?

It works all outside, but where is "Users today" or "Users this week" there is no colors except default.

How to solve it?

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

BBCode Buttons have disappeared, too!

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

44

(7 replies, posted in PunBB 1.3 troubleshooting)

What is DB server? This info?
MySQL Standard 5.1.25

All other things in forum and website works.

45

(7 replies, posted in PunBB 1.3 troubleshooting)

No ideas?

46

(7 replies, posted in PunBB 1.3 troubleshooting)

Forum version: 1.3.2.


Pun poll
* Version v1.1.2.

47

(7 replies, posted in PunBB 1.3 troubleshooting)

I receive this message:

An error was encountered

The error occurred on line 177 in D:\Hosting\mywebsite\htdocs-forum\edit.php(125) : eval()'d code

Database reported: Incorrect integer value: 'NULL' for column 'votes_count' at row 1 (Errno: 1366).

People complainig about getting this error while trying to post new topic:

PHP Notice:  Undefined index:  user_locked in D:\Hosting\islammuslim\htdocs-forum\post.php(90) : eval()'d code on line 10
Slavok wrote:

This checking is needed to avoid CSRF, we are not recommended to you to take it off.
But if you want to do this, just add this line to config.php to skip security checking:

define('FORUM_DISABLE_CSRF_CONFIRM', 1);

Does not work:

Warning! The following errors must be corrected before your message can be posted:Unable to confirm security token. A likely cause for this is that some time passed between when you first entered the page and when you posted the form. Clicking "Submit" again should solve the problem.

I am amazed that nobody have made this mod. As for me, it is maybe one of most important mod. Since upgrading from 1.2.x my forum is full with mess becouse I do not have such mod for moving seperate posts to another topics...

Nobody is making this mod?

sad