Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: AlikaGreen - elokuu 07, 2019, 04:54:07 IP

Otsikko: Incorrect String Value
Kirjoitti: AlikaGreen - elokuu 07, 2019, 04:54:07 IP
I keep getting this error can someone please tell me how to fix it?


Database Error
Incorrect string value: '\x93Home ...' for column `id8765826_sql`.`smf_messages`.`body` at row 1
File: /storage/ssd5/826/8765826/public_html/Sources/Subs-Post.php
Line: 1816
Otsikko: Re: Incorrect String Value
Kirjoitti: Arantor - elokuu 07, 2019, 04:55:09 IP
How are you trying to make that post? Is it one written in Word and copy/pasted?
Otsikko: Re: Incorrect String Value
Kirjoitti: AlikaGreen - elokuu 07, 2019, 05:01:24 IP
Some of it is on Word and others are online sources that are copied and pasted. However, I have seen others using the same boards and do not have this issue so not sure if its something I did or did not do.
Otsikko: Re: Incorrect String Value
Kirjoitti: Arantor - elokuu 07, 2019, 05:06:26 IP
In the default configuration, the way Word makes its quote marks isn't compatible with the way posts are stored in the database.

If you take a backup and use the Convert to UTF-8 option in the admin panel that might fix your problem for future posts.
Otsikko: Re: Incorrect String Value
Kirjoitti: AlikaGreen - elokuu 07, 2019, 05:10:54 IP
Thank you that did it.