• Ok, I am still new at wordpress I did something really stupid. I had an rss feed that I added into the script, everything was working fine till I noticed the tables on the rss feed was bigger then what I wanted. So I was looking for options to size the text and found something that encoded stuff in option, reading. I think its like UTF-8. Well I thought I would try changing it smaller so I changed it to UTF-7. Well Now the scripts is all messed up. After reading about UTF I see that its for something totaly different then what I thought it was. So now I am worndering how I change it back. I can’t login, cant update the script. The main blog page is all messed up.

    Any help would be great!

Viewing 11 replies - 1 through 11 (of 11 total)
  • did you simply change it back to UTF-8?

    Thread Starter devilschild

    (@devilschild)

    Can’t when I did that and hit update settings. It went to the main settings page. So after a few attemts of that, I closed the window and figured I would try to login in and go to options and read and try to change it again. Now I can’t login to word press. It just keeps going to the login page.

    Thread Starter devilschild

    (@devilschild)

    Is there a way to change it through the php files?

    Thread Starter devilschild

    (@devilschild)

    Can anyone help?

    what file did you make this change to? can you re-upload the original?

    take this as a lesson learned: ALWAYS MAKE BACKUPS!! ??

    If you changed it in the Admin area, you’ll need to directly edit the database to reset it.

    This tutorial will get you in the general area:
    https://www.tamba2.org.uk/wordpress/site-url/

    But to be clear, you don’t want to change the URI’s mentioned in the tutorial, you want to find the encoding value (look for UTF-7).

    But to be clear, you don’t want to change the URI’s mentioned in the tutorial, you want to find the encoding value

    You’re looking for ‘blog_charset’.

    Thread Starter devilschild

    (@devilschild)

    Thanks HandySolo that did the trick!

    So handy and Kafka.

    I might be slow, but can you please specify exactly what to change in the database? As Handy points out, changing the URL’s isn’t really the issue here.

    “You’re looking for ‘blog_charset'”

    Okay, but where do I find that, and what to do then?

    In the same wp_options table (or whatever your table prefix is, if not wp_) – as it is described in the tutorial, just don’t look for home or site_url, but for a row with “blog_charset”.
    In my DB it is row #37.

    EDIT. And again: as described in the tutorial, edit that line: delete utf-7 and type utf-8.
    Done.

    Finally i figured it out. Complete guide to UFT-7 problems:

    1. First open PhpMyAdmin, your domain host can provide you with the adress, in my case it’s https://phpmyadmin.needhost.dk/.

    Login with the username and password you would have specified when creating the database.

    2. A list of your databases will appear. Click the one that is your WordPress database. All the tables in your database will appear. Depending on what prefix you have specified in your wp-config.php file you should find something like wp_options. If you can’t find this table you prefix isn’t wp_. You can look op wp-config.php at the root of your wordpress directory, and find the prefix line.

    example: $table_prefix = ‘anotherprefix’;

    In this case the table in your database would be ilovewordpressbugsoptions.

    Open the table “wp_options” or “anotherprefixoptions”.

    3. Now you should look for the column named option_name. Look through the list and see if you can find an option called “blog_charset”. If you can’t find it it’s because it’s on the next page. Click the next page button.

    4. Now you have found the “blog_charset”. If you look at the value it says “UTF-7”. Because WordPress can’t handle this we are going to change this to UTF-8. Click the pen just before the delete function to edit it.

    5. Find the field where it say “UTF-7” and change it to “UTF-8” and press done, or whatever it’s called in your language, at the bottom of the page.

    6. Thank God. You’re done!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘HELP! UFT-8 Troubles’ is closed to new replies.