QUICK NEWS

{NEW} - A new css video is up.

{OLD} - New video courtesy of Skhilled, Thanks for posting it up.

Video of the moment:


Internal Links

SMF Sites

Quick Info

It appears that your database may require an upgrade

Started by lesmond, Feb 20, 2023, 12:20 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

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?

The only person who got all his work done by Friday was Robinson Crusoe

lesmond

Update...

I managed to run upgrade.php

So now when I edit an article I get this error..
[Incorrect string value: '\xA0File: /home/xxxx/public_html/forums/TinyPortal/Base.php
Line: 285/code]

The only person who got all his work done by Friday was Robinson Crusoe

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

Quote from: shawnb61 on Feb 20, 2023, 04:26 PMThat 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
Data too long for column 'word' at row 144469
File: /home/xxxx/public_html/forums/Sources/ManageMaintenance.php
Line: 664
This is not my forum btw
Its been moved to a new host running MySQL8.0 if that makes any difference.

The only person who got all his work done by Friday was Robinson Crusoe

Skhilled

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

lesmond

Quote from: Skhilled on Feb 20, 2023, 07:24 PM@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 ...

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


The only person who got all his work done by Friday was Robinson Crusoe

Skhilled


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.

The only person who got all his work done by Friday was Robinson Crusoe