After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Captain P-H-P-BB
Registered User
Posts: 20
Joined: Wed Mar 05, 2014 11:45 am

After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Captain P-H-P-BB »

Support Request Template
What version of phpBB are you using? phpBB 3.3.3
What is your board's URL? https://www.ufc-filmforum.de
Who do you host your board with? hosteurope.de
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.3.2
What extensions do you have installed? 3Di - Online Since, Advanced BBCode Box, Avatars on Memberlist, Contact Admin, External Links Open in New Window, Favicon, Header Banner, Lightbox, Mark Post Unread, OneAll Social Login, Pages, Precise Similar Topics, Privacy protection, Recent Topics, Selective mass emails, SEO Metadata, Separate Users and Bots, Share On, Simple Spoiler BBCode, Sortables Captcha, Topic Description, Topic Preview, User Merge
What styles do you currently have installed? prosilver
What language(s) is your board currently using? German
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I have updated my board from 3.3.2 to 3.3.3
Please describe your problem.

A: The main page of the ACP cannot be accessed. >>> solved after applying fix
B: main page of the ACP contains message "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN"


After the upgrade nearly everything works fine. At least I did not yet encouter any additional errors, except for not being able to access the ACP general page, and the subsequent error message after applying the SQL error fix.
Sub-pages of the ACP (administration of forums, topics, users, etc.) can also still be accessed and all seem to work fine.

Initially, on ACP main I received the error message:

Code: Select all

    SQL ERROR [ mysqli ]

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-ufc' at line 2 [1064]

    SQL

    SHOW TABLE STATUS FROM db1186963-ufc

    BACKTRACE

    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/phpbb/db/driver/driver.php
    LINE: 1023
    CALL: trigger_error()

    FILE: [ROOT]/phpbb/db/driver/mysqli.php
    LINE: 195
    CALL: phpbb\db\driver\driver->sql_error()

    FILE: [ROOT]/phpbb/db/driver/factory.php
    LINE: 345
    CALL: phpbb\db\driver\mysqli->sql_query()

    FILE: [ROOT]/includes/functions_admin.php
    LINE: 2851
    CALL: phpbb\db\driver\factory->sql_query()

    FILE: [ROOT]/includes/acp/acp_main.php
    LINE: 562
    CALL: get_database_size()

    FILE: [ROOT]/includes/functions_module.php
    LINE: 676
    CALL: acp_main->main()

    FILE: [ROOT]/adm/index.php
    LINE: 81
    CALL: p_master->load_active()
Generated by SRT Generator

So I have applied the fix that has been described in here:
https://github.com/phpbb/phpbb/pull/6121/files
and now my phpBB/includes/functions_admin.php looks like this on the lines 2836 - 2865

Code: Select all

function get_database_size()
{
	global $db, $user;

	$database_size = false;

	switch ($db->get_sql_layer())
	{
		case 'mysqli':
			$mysql_engine	= ['MyISAM', 'InnoDB', 'Aria'];
			$db_name		= $db->get_db_name();
			$database_size	= 0;

			$sql = 'SHOW TABLE STATUS
				FROM ' . $db->sql_quote($db_name);
			$result = $db->sql_query($sql, 7200);

			while ($row = $db->sql_fetchrow($result))
			{
				if (isset($row['Engine']) && in_array($row['Engine'], $mysql_engine))
				{
					$database_size += $row['Data_length'] + $row['Index_length'];
				}
			}

			$db->sql_freeresult($result);

			$database_size = $database_size ? $database_size : false;

		break;
After that, the ACP general page can be accessed again.
But now I see the message "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN"
error_default.png

Thank you very much in advance for your support.
User avatar
david63
Registered User
Posts: 19702
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by david63 »

You need to update your language pack
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Dler
Registered User
Posts: 28
Joined: Sun Oct 28, 2018 2:21 pm

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Dler »

I have the same problem.

I made the update from 3.3.2 to 3.3.3 with the complete package.

Default charset is improperly configured
default_charset must be set to UTF-8. You can check the current value on the PHP information page.

My database looks like this.

Image
rxu
Extensions Development Team
Posts: 3537
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact:

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by rxu »

This is not about database but default_charset PHP core php.ini directive https://www.php.net/manual/en/ini.core. ... lt-charset
Dler
Registered User
Posts: 28
Joined: Sun Oct 28, 2018 2:21 pm

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Dler »

I don't have access to php.ini because I don't have my own server. I am on a web host.
Captain P-H-P-BB
Registered User
Posts: 20
Joined: Wed Mar 05, 2014 11:45 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Captain P-H-P-BB »

Hi,
thanks a lot for the hints and the quick support! :)
After changing the board language to English, I received a more meaningful error message: "phpbb Default charset is improperly configured default_charset must be set to UTF-8. You can check the current value on the PHP information page."

The PHP Info in ACP has confirmed this.

So, I changed the PHP Charset default setting in my webhosting configuration from "none" to "server standard" (which mean UTF-8 in my case).
And now the message no longer appears in ACP.
Dler
Registered User
Posts: 28
Joined: Sun Oct 28, 2018 2:21 pm

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Dler »

Captain P-H-P-BB wrote:
Sat Jan 30, 2021 3:18 pm
So, I changed the PHP Charset default setting in my webhosting configuration from "none" to "server standard" (which mean UTF-8 in my case).
And now the message no longer appears in ACP.
Where did you change that with you please? I am hosted at all-incl.
Captain P-H-P-BB
Registered User
Posts: 20
Joined: Wed Mar 05, 2014 11:45 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Captain P-H-P-BB »

I am at Hosteurope. I found the setting under:
Webhosting > Configuration > Scripts & Databases > Script Settings > Charset

I don't know how this is working at your hosting service. But if you do not find any possibility to change the charset settings yourself, I'd recommend to contact them.
Dler
Registered User
Posts: 28
Joined: Sun Oct 28, 2018 2:21 pm

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Dler »

OK thank you. I contacted my web host.
TheGardner
Registered User
Posts: 24
Joined: Sat Nov 19, 2016 12:20 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by TheGardner »

Captain P-H-P-BB wrote:
Sat Jan 30, 2021 3:18 pm
So, I changed the PHP Charset default setting in my webhosting configuration from "none" to "server standard" (which mean UTF-8 in my case).
And now the message no longer appears in ACP.
thanks much! This also fixed all errors for me too! Have the same hosting service.
Maclobster
Registered User
Posts: 176
Joined: Sun Feb 10, 2013 7:12 pm
Location: Netherlands
Contact:

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Maclobster »

Having the same problem, provider strato, but they say they cant help, so dont know what to do, the accepting it
''A man searching for lost paradise can seem a fool to those who have never sought the other world''
-JM
User avatar
Mick
Support Team Member
Support Team Member
Posts: 23459
Joined: Fri Aug 29, 2008 9:49 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Mick »

Please start your own topic if you have a similar issue especially as this one is marked solved (Image)
"The more connected we get the more alone we become" - Kyle Broflovski©
User avatar
apollodriver
Registered User
Posts: 134
Joined: Tue Jan 21, 2020 11:35 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by apollodriver »

hi there - well this is a pretty interesting topic

one question though - if we did an update-: are we able to see in the database which versions acutally runs now!`?

in other words: can we see the version number in the database!?


that would be great ! which table where to find it`?!
for Wordpress-development - i use the Toolset: http://wpgear.org/
User avatar
Mick
Support Team Member
Support Team Member
Posts: 23459
Joined: Fri Aug 29, 2008 9:49 am

Re: After upgrade from 3.3.2 to 3.3.3: "ERROR_DEFAULT_CHARSET ERROR_DEFAULT_CHARSET_EXPLAIN" in ACP General

Post by Mick »

Mick wrote:
Fri Feb 05, 2021 10:19 am
Please start your own topic
"The more connected we get the more alone we become" - Kyle Broflovski©
Post Reply

Return to “[3.3.x] Support Forum”