Guntis

“Contact your host. Maybe an ownership problem. /tmp owned by uid 0 says the temp directory is owned by root.”

Host is me ?? In previous WordPress version 3.1.x I hadn’t this problem. It all started after updating to the latest version 3.3.1. I don’t know where to change what…

SQL is using utf-8. Everything’s fine in the blog itself, just plugin doesn’t work as expected.

https://www.macpasaule.lv

Of course I pressed Save button. Then tried to reset. Tried everything. Nothing helps.

Thanks! This is what I needed! I installed this plugin and I hope my problem will be solved. Unfortunately I didn’t find this plugin before (I did search before posting my suggestion).

By the way, all these years for every WP update I have to change wp-settings.php file by adding two extra lines at the end of the file:

// Everything is loaded and initialized.
do_action(‘init’);
mysql_query(“SET CHARACTER SET utf8”);
mysql_query(“SET NAMES utf8”);
?>

If there are no these mysql_query lines all blog is messing up all Latvian letters. It’s beyond my comprehension why WP team can’t add these lines so that WP would work correctly out of the box. by the way, out of the box it creates db with swedish cp encoding. why?

If I’m correct, that information is stored in ‘wp_options’ table in ‘blogname’ field, and there it is saved properly. Problem seems to be connection & encoding when fetching this data. Looks like encoding is Latin when it should be utf-8.

Actually I had problem also in the previous version, just before the upgrade. And in the latest version (2.7) the same problem.

By the wat, I can’t understand why WordPress is creating database with the Swedish charset as default. I always have to dump database to sql file, change charset info to utf8, then import it back. And those three lines at the end of the wp-settings.php file also are not added, so if I forget to add them after each update manually, I get Latvian text unreadable. If WordPress is going to Unicode, is it hard to make correct database charset setup and establish utf-8 connection with the database? 3 lines of code and it’s done…

There’s nothing in wp-config.php file regarding charsets. In the end of the wp-settings.php I’ve added lines:

do_action(‘init’);
mysql_query(“SET CHARACTER SET utf8”);
mysql_query(“SET NAMES utf8”);

which force UTF-8 connection with the database. I already wrote that all database is UTF-8 (utf8_unicode_ci). User name is properly saved in the database with Latvian characters. In phpMyAdmin I can see it in the wp-usermeta table (nickname and first_name fields). The problem is that those characters in the user names are not displayed by the WordPress properly (in the Admin/Users page and in the main page where the article authors are displayed). If I post anything in Latvian, it’s displayed properly, but user names are not. Why?

I am surprised that Visual removes <p> code! That’s the most basic code!
Thanks for the tip how to turn this mode off. I just think that developers should pay much bigger attention to code preservation. <p> is even more important than <b> or <u> which get preserved…

OK, but what is the reason to write image info in the wp_posts database? Those images are already registered in my blog entry, why they should be registered twice? If that would make image database, then it’s ok, but still useful only for those images which I’d like to show as photo library. Now if I add 32 images to my blog entry, I get 32 unnecesssary db entries… Or even 64 (!!!), if I’ve set ecto to create thumbnails. Absolute wasting of db space and server resources… Plus, post IDs are scattered, I cannot just change post ID in the URL line to browse to the previous or next post, as there could be 10 or 30 or even 64 “empty” IDs in between… I love order, that every new message has next ID number, but this new WP 2.x just creates complete chaos in ID numbers…

Ecto creator asked me to send ecto’s Console log when I upload new entry with images. After log file review he wrote me back:

“The console log is clean. WP is taking the file data and saving it into it’s upload folder. If it’s creating new entries from the uploaded files, I recommend contacting WP support. Show them the console log and a proof that your sql database is filled with extra entries.”

You can see Console log here:
https://bb.infinite-sushi.com/viewtopic.php?p=8647#8647

And this is what’s inserted in wp_posts database:

INSERT INTO wp_posts VALUES (159, 1, ‘2007-05-24 08:32:59’, ‘2007-05-24 06:32:59’, ”, ‘2007.03.26-12.40.11-ted-he-1.jpg’, 0, ”, ‘inherit’, ‘open’, ‘open’, ”, ‘20070326-124011-ted-he-1jpg’, ”, ”, ‘2007-05-24 08:32:59’, ‘2007-05-24 06:32:59’, ”, 0, ‘https://www.adventisti.lv/blog/wp-content/uploads/2007/05/2007.03.26-12.40.11-ted-he-1.jpg&#8217;, 0, ‘attachment’, ‘image/jpeg’, 0);
INSERT INTO wp_posts VALUES (160, 1, ‘2007-05-24 08:33:05’, ‘2007-05-24 06:33:05’, ”, ‘2007.03.17-vislatvijas-jauniesu-dievkalpojums-1.jpg’, 0, ”, ‘inherit’, ‘open’, ‘open’, ”, ‘20070317-vislatvijas-jauniesu-dievkalpojums-1jpg’, ”, ”, ‘2007-05-24 08:33:05’, ‘2007-05-24 06:33:05’, ”, 0, ‘https://www.adventisti.lv/blog/wp-content/uploads/2007/05/2007.03.17-vislatvijas-jauniesu-dievkalpojums-1.jpg&#8217;, 0, ‘attachment’, ‘image/jpeg’, 0);

Why does WP 2.2 insert image info in wp_posts table? I think image info is embedded in the real post entry and there is no reason to have extra line in wp_posts for each image used in the post, and every thumbnail as well.

SORRY!!! It’s not wp-config.php file! It’s wp-settings.php file.
For me these two lines do the trick and Latvian letters appear properly. Could you please include these 2 lines there?

I receive emails about comments, not about trackbacks.
Here’s email content I receive from the WP blog:

A new comment on the post #112 “Leopards dodas Vistu medībās” is waiting for your approval

https://www.adventisti.lv/blog/?p=112

Author : biaxin xl no prescription
-23 (IP: 209.160.64.236 , 209.160.64.236)

E-mail :

URL : https://mynscom.org/biaxin-xl-no-prescription/
Whois : https://ws.arin.net/cgi-bin/whois.pl?queryinput=209.160.64.236

Comment:
biaxin xl no prescription
-23

Approve it: https://www.adventisti.lv/blog/wp-admin/comment.php?action=mac&c=378

Delete it: https://www.adventisti.lv/blog/wp-admin/comment.php?action=cdc&c=378

Spam it: https://www.adventisti.lv/blog/wp-admin/comment.php?action=cdc&dt=spam&c=378

Currently 4 comments are waiting for approval. Please visit the moderation panel:
https://www.adventisti.lv/blog/wp-admin/moderation.php

It has nothing to do with www. The problem is not that I wouldn’t have www, but that I cannot add trailing slash and in the result web server doesn’t show anything without it… Actually it’s redirecting user to another site… Try to enter this URL https://www.adventisti.lv/blog/ and then click on “Guntis’ Blog” and see what I mean!