It appears that your database may require an upgrade

[lesmond]

SMF 2.0.19

TinyPortal 2.3.0

Incorrect string value: '\xA0 Repo...' for column 'body' at row 1
File: /home/xxxxx/public_html/forums/TinyPortal/Base.php
Line: 285

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.19, while your database is at version 2.0.17. The above error might possibly go away if you execute the latest version of upgrade.php.

This happens when editing an article, the article has strange letters like this  when I try to remove them the above error shows

So I ran upgrade.php the forum refused to come out of maintenance mode. and completely locked me out, even restoring the db didn't help!

Which meant I had to restore the whole site from a backup.

TP was on 2.2.2 and I hoped by upgrading to 2.3.0 would help?

[lesmond]

Update...

I managed to run upgrade.php

So now when I edit an article I get this error..

Code Select Expand

[Incorrect string value: '\xA0File: /home/xxxx/public_html/forums/TinyPortal/Base.php
Line: 285/code]

[shawnb61]

That error means you're trying to store an invalid character for the database's charset/collation.

What is the collation of your smf tables?

What is the collation of your tp tables?

Are you running smf in utf8?

[lesmond]

That error means you're trying to store an invalid character for the database's charset/collation.

What is the collation of your smf tables?

What is the collation of your tp tables?

Are you running smf in utf8?

I have no idea of the collation of the db, but I did try to run utf8 on the db and got this error

Code Select Expand

Data too long for column 'word' at row 144469
File: /home/xxxx/public_html/forums/Sources/ManageMaintenance.php
Line: 664This is not my forum btw
Its been moved to a new host running MySQL8.0 if that makes any difference.

[Skhilled]

@lesmond , Look in phpmyadmin and it will show you the collation for the tables as well as the collation of the server.

[lesmond]

@lesmond , Look in phpmyadmin and it will show you the collation for the tables as well as the collation of the server.

Ok found it and changed them to utf8, there was a mixture of all different collations!

But this error is still there ...

Code Select Expand

Incorrect string value: '\xA0File: /home/xxxx/public_html/forums/TinyPortal/Base.php
Line: 285

[Skhilled]

https://ubiq.co/database-blog/mysql-change-collation-of-all-tables/

[lesmond]

I managed to fix this by creating a new forum and copying the database over, removed all mods and add each one by one.