TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2024, 10:38:07 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,106
  • Total Topics: 21,213
  • Online today: 358
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 111
  • Total: 111

It appears that your database may require an upgrade

Started by Lesmond, February 20, 2023, 10:52:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

tino

What version of UTF-8?

That looks like an error from a 3bit version of UTF-8. Ideally the tables should be utf8mb4.

What version of PHP, MySQL and what language is the default system set to? I assume English.

Lesmond

Collation utf8mb3_general_ci just changed it too utf8mb4_general_ci, before the errors started, all the tables were all different

PHP 7.4

MySQL 8.0

Language system is English

tino

Is the error still there with utf8mb4?

Do you get the error when creating a new article, or just the old ones you try to edit?

Is SMF set to utf8 in its settings

Do you have multibyte enable in PHP?

Lesmond

SMF is showing 'Database character set:utf8mb3'

If I click proceed I get this error, all tables are showing utf8mb4 in PHPMyadmin
Data too long for column 'name' at row 42
File: /home/xxxx/public_html/forums/Sources/ManageMaintenance.php
Line: 664

Quote from: tino on February 21, 2023, 07:27:14 PMDo you have multibyte enable in PHP?
I don't see that in PHP Extensions on EasyApache

This was pasted as plain text, into a new article. (its a HTML article)
If I leave this line like so, no error is shown.


But if I have a line break like so, the error appears again after save.
imageac7238d6bc0cae51.md.png" border="0

Just tried with a bbc article no errors :-\


tino

Then it's how that character is getting encoded. It sounds like SMF thinks the database is in a different format and is adding characters in which causes the problem.

I'll try and cause the same error here later, however I don't have a MySQL 8.0 setup so that might cause some issues.

tino

I can't recreate this. So not sure where we go from here, is there a reason it's not on SMF 2.1 as that handles unicode alot better than 2.0

Lesmond

Quote from: tino on February 23, 2023, 03:41:53 PMI can't recreate this. So not sure where we go from here, is there a reason it's not on SMF 2.1 as that handles unicode alot better than 2.0
Its a friends site I have hosted on my server, its been around for a few years, and has been on lots of other server over the years, I think it started out on SMF 1 and been updated many times.

So this has only shown up on the last server move.

So basically I think the database needs fixing, which I am not clever enough to do :-[

Lesmond

*Update*

I managed to fix the site, I installed a new forum and copied the database over table by table, checking each time, the errors have now gone!

Maybe not the right way, but it worked  O0