adding post – failed with polish characters

  • Hi,
    i’ve tried today to add some post and everytime when i clicked publish or save i was getting blank page. No post was shown when i get back to dashboard.
    After few attempts i’ve noticed that everything works fine when i don’t use polish characters eg ó ? ? ?.

    Looking at db charset for wordpress i see it uses latin2_general_ci but i have no idea if that’s ok, how it was before (gotta check some backups) and if thats a cause of problems.

    Any ideas what’s going on because it’s hard to write with my language without those characters ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    i’ve tried today to add some post and everytime when i clicked publish or save i was getting blank page.

    That’s not good. Have you tried the usual troubleshooting steps?

    * Deactivate all of your plugins.
    * Switch to the Twenty Fifteen theme.
    * Clear your browser’s cache and cookies.
    * Log in again and try to save a post with Polish characters in it.

    These are only temporary steps and once you’ve tested you can put it all back the way it was.

    If it works when you have no plugins activated and the default Twenty Fifteen theme then you may have a conflict.

    Thread Starter pakos

    (@pakos)

    Yes, sorry but forgot to mention.

    Tried all of them, even tried to upgrade it once again since latest one was done automatically bu no effect, still same blank page.

    Unfortunately my hosting provider doesn’t allow me to edit php config myself so i’m not able to enable showing logs, that could give some idea maybe.

    Is there other way to see whats wrong from wordpress level?

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    Tried all of them, even tried to upgrade it once again since latest one was done automatically bu no effect, still same blank page.

    I think the best option would be to get the error_log for your site from your hosting provider. When you get a blank page like that it means that your web server’s PHP is tossing 500 errors. That log file can help you identify why that is.

    Thread Starter pakos

    (@pakos)

    First i found how to enable debug in wp itself, (sorry for asking before searching ;)). There’s a database error:

    WordPress database error: [Something is wrong in your syntax obok ') AS x_post_content' w linii 1]
SELECT CONVERT( LEFT( CONVERT( '??' USING binary ), 4294967295 ) USING ) AS x_post_content

WordPress database error: [Something is wrong in your syntax obok ') AS x_post_content' w linii 1]
SELECT CONVERT( LEFT( CONVERT( '??' USING binary ), 4294967295 ) USING ) AS x_post_content

Catchable fatal error: Object of class WP_Error could not be converted to string in /home/pakos/public_html/blog/wp-includes/formatting.php on line 1608
    Thread Starter pakos

    (@pakos)

    any ideas or reinstallation is my last option?

    Thread Starter pakos

    (@pakos)

    ok somehow i managed to fix it myself, i did fresh test install and saw that all db elements have charset set to utf8mb4_unicode_ci so i changed it for post_title and post_content and i can use polish characters now.

    ALTER TABLEwp_postsCHANGEpost_titlepost_title` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ;
    ALTER TABLE wp_posts CHANGE post_content post_content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ;`

    now the question is, all other tables still have: latin2_general_ci
    should i change them aswell? and what if there’s an error like for wp_commentmeta – meta_key #1071 – defined key is too long

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘adding post – failed with polish characters’ is closed to new replies.