lelion

Sometimes hosting companies DO CHANGE something, and then don’t tell you. It happened to one of our websites not a long ago. They changed a setting in PHP, so the website simply stopped working (it needed this setting)! When we asked, they denied that they have changed something! Doing our own research, we have found the problem and using .htaccess fixed the PHP setting …

So double-check everything!

I hope some of the more experienced users may give more help on this issue, though… :-/

WordPress admin panel, OPTIONS tab, MISCELANNIOUS sub-tab, fill Store uploads in this folder: [TYPE dir for uploads place here].

Hope this helps?… 🙂

// But I guess maybe this isn’t your problem, maybe the directory you’re trying to upload to doesn’t have the right permissions (CHMOD)? Someone?… 🙂

Hi! 🙂

I was searching for help and I stumbled upon this message by Lor_Erik…

I am trying to set up a bi-lingual blog (with the help of the GENGO plugin😉 and all was OK, until the moment I opened phpMyAdmin and found that cyrillic characters, encoded as UTF-8, DO NOT display correctly in the DATABASE.

The strange thing for me was that in the blog all was OK! All characters displayed correctly, encodings (both in the MySQL database and in the blog) were set to Unicode (UTF-8) and collation in the MySQL set to utf8_unicode_ci.

So I searched around and finally have found the following code, which helped me resolve this bug:

First, open wp-includes/wp-db.php

Then find line 43 (WordPress 2.05), press ENTER after the end of the line, and add the following:


mysql_query("SET NAMES 'utf8'");


So the code becomes:

function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_query("SET NAMES 'utf8'");


…instead of:

function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);


This (mysql_query(“SET NAMES ‘utf8′”);) tells WordPress to interact (send data and receive data) with the database, using UTF-8 encoding (that’s my guess). This is a great tip for new WordPress installs; for older ones, though, this might not work, because after you change this encoding setting in wp-db.php, older items no longer will be displayed correctly, only newly posted ones. But if you install WP for the first time, or do a new fresh install, it’s a great fix, because it’ll make EVERYTHING displayed as UTF-8, both in the website with the blog and in the MySQL database – this will help avoid future problems, when backup/restore MySQL database, etc.!

//

One thought, though – is there a difference between using:

1) the method, described by Lor_Erik
(find:
$this->select($dbname);
and then add before that:
$this->query("SET NAMES 'utf8'");
)

and

2) the method which I found
(add code after line 43, so it becomes:

function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
mysql_query("SET NAMES 'utf8'");

)
…?

Someone more experienced than me can maybe tell us the difference (or there’s no diference?)? 🙂

Thank you!

Happy blogging to everyone! :)))