Recent Topics

[5.2.0] Posting Error: Incorrect string value: '\xA0...' for column 'iver_content' at row 1(Errno=1366)

Started by on Jan 12, 2015 – Contents updated: Feb 14, 2015

Jan 12, 2015 12:46    

I'm getting an error editing a post:

Code

Incorrect string value: '\xA0...' for column 'iver_content' at row 1(Errno=1366)

Your query: Save a version of the Item

Code

INSERT INTO evo_items__version( iver_ID, iver_itm_ID, iver_edit_user_ID, iver_edit_datetime, iver_status, iver_title, iver_content )
SELECT "3" AS iver_ID, post_ID, post_lastedit_user_ID, post_datemodified, post_status, post_title, post_content
FROM evo_items__item
WHERE post_ID = 312

Recently upgraded to 5.2.0

Jan 12, 2015 13:46

I seem to be able to create posts, but editing them are when the error is thrown...

Jan 15, 2015 19:55

Hi @scribbly,

Please make sure that your locale is properly set to use the utf8 version. If you're upgrading from a lower version of b2evolution, it's possible that this parameter remains set to use the latin1 version, so please verify.

This is the related manual page: http://b2evolution.net/man/locales-tab. Just make sure that your site is configured as in the screenshot ( if you use en-US, of course ). Also check the steps enumerated in this comment: http://forums.b2evolution.net/5-2-0-cyrillic-characters-replaced-by-character#c103562, in order to automatically change the locales to the users and collections as well.

Regards!

Jan 19, 2015 14:35

OK: Thanks.

I've since upgraded to 5.2.1 and have not noticed a problem yet (tho' have not given it much of a chance either).

I did have the default set to en-au that iso-8859-1, not utf-8. Does that mean I can't use en-au?

Jan 24, 2015 13:48

Does that mean I can't use en-au?

Well, then I'm not sure if that is the source of the problem. Please, let us know if you get the same error again.

Thanks.

Jan 26, 2015 10:37

Thanks, will do... have a couple of posts to get off today/tomorrow.

Appreciate the help (not to mention the software)!!

Jan 30, 2015 16:02

Here it is again...

I'd made a couple of posts, multiple updates ok, but this one got around to the 3 or 4th save and then this error.

Code

Additional information about this error:
 
MySQL error!
 
Incorrect string value: '\x85\x0D\x0A\x0D\x0A<...' for column 'iver_content' at row 1(Errno=1366)
 
Your query: Save a version of the Item
 
INSERT INTO evo_items__version( iver_ID, iver_itm_ID, iver_edit_user_ID, iver_edit_datetime, iver_status, iver_title, iver_content )
 
SELECT "2" AS iver_ID, post_ID, post_lastedit_user_ID, post_datemodified, post_status, post_title, post_content
 
  FROM evo_items__item
 
WHERE post_ID = 323
Backtrace:
 
debug_die( "<p class="error">MySQL error!</p>\n<div><p><strong>Incorrect string value: '\x85\x0D\x0A\x0D\x0A<...' for column 'iver_content' at row 1(Errno=1366)</strong></p>\n<p class="error">Your query: Save a version of the Item</p><pre>INSERT INTO evo_items__vers…" )
File: /home/mitup2/public_html/b/inc/_core/model/db/_db.class.php on line 668
DB->print_error( "", "", "Save a version of the Item" )
File: /home/mitup2/public_html/b/inc/_core/model/db/_db.class.php on line 881
DB->query( "INSERT INTO T_items__version( iver_ID, iver_itm_ID, iver_edit_user_ID, iver_edit_datetime, iver_status, iver_title, iver_content )\n  SELECT "2" AS iver_ID, post_ID, post_lastedit_user_ID, post_datemodified, post_status, post_title, post_content\n…", "Save a version of the Item" )
File: /home/mitup2/public_html/b/inc/items/model/_item.class.php on line 4957
Item->dbupdate( )
File: /home/mitup2/public_html/b/inc/items/items.ctrl.php on line 840
require( "/home/mitup2/public_html/b/inc/items/items.ctrl.php" )
File: /home/mitup2/public_html/b/admin.php on line 250
Ignored last: 1

Feb 01, 2015 14:20

One thing I think I've noticed, is that the error gets thrown only when posts contain linked images.

That seems odd, eh? But that seems to be true... Does it help with the error?


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.