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

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2024, 08:03:34 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: 99
  • Total: 99

Pasting HTML Article

Started by Lesmond, July 25, 2020, 07:32:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Lesmond

Not sure if this is an error, If I copy/paste some text with smiles in it throws errors.

here is a section of something I pasted..
QuoteCan anyone remember those home Chemistry sets we could buy that contained lots of useful (and dangerous) stuff to experiment with ?😎

Type of error: Database
Database Error: Incorrect string value: '\xF0\x9F\x98\x8E\xF0\x9F...' for column 'body' at row 1
https://xxxxx.pw/index.php?action=tpadmin
/home/lesmond/public_html/forum/Sources/TPortalAdmin.php (Line 3363)


I did try pasting has plain text, but still got the error above.

I ended up going through all the text to remove the smiles and no errors 

lurkalot


lurkalot

Error
Type of error: Database
Error message:
Database Error: Incorrect string value: '\xF0\x9F\x98\x8E</...' for column 'body' at row 1
File: /home/vol11_7/byethost7.com/b7_24299229/htdocs/testsite7/Sources/TPortalAdmin.php
Line: 3364
URL of page causing the error: http://lts4.byethost7.com/testsite7/index.php?action=tpadmin

Backtrace information
#0: smf_db_error()
Called from /home/vol11_7/byethost7.com/b7_24299229/htdocs/testsite7/Sources/Subs-Db-mysql.php on line 489
#1: smf_db_query()
Called from /home/vol11_7/byethost7.com/b7_24299229/htdocs/testsite7/Sources/TPortalAdmin.php on line 3364
#2: do_postchecks()
Called from /home/vol11_7/byethost7.com/b7_24299229/htdocs/testsite7/Sources/TPortalAdmin.php on line 94
#3: TPortalAdmin()
Called from unknown on line -1
#4: call_user_func()
Called from /home/vol11_7/byethost7.com/b7_24299229/htdocs/testsite7/index.php on line 173

tino

SMF 2.0?

That's an entity encoding error.

Lesmond

Quote from: tino on July 25, 2020, 08:46:59 PM
SMF 2.0?

That's an entity encoding error.

Sorry yes "SMF 2.1 RC2 TinyPortal 1.6.7"

lurkalot

Quote from: tino on July 25, 2020, 08:46:59 PM
SMF 2.0?

That's an entity encoding error.

I noticed if you try posting that same piece of text with the smiley in 1.6.7 running on 2.0.17 it strips the smiley out and saves fine, just without the smiley.

lurkalot

And although this topic title suggests this is an article issue the same error occurs if you past it in a html block. 

Lesmond

The item I posted in the article had this ....


You can imagine how long it took me to remove all the smiles :(

Lesmond

Quote from: lurkalot on July 25, 2020, 09:58:57 PM
And although this topic title suggests this is an article issue the same error occurs if you past it in a html block. 
Actually I tried with a BBC article too, same result.

lurkalot

Quote from: Lesmond on July 25, 2020, 10:00:34 PM
The item I posted in the article had this ....


You can imagine how long it took me to remove all the smiles :(

Where were you copying the text from Les?  Just wondering what generated those smiles