Welcome to Geeklog, Anonymous Tuesday, December 10 2024 @ 06:16 am EST

Geeklog Forums

There is a very big bug about Chinese Article on Geeklog 1.8.1 and 2.0.0rc1

Page navigation


Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
I am from China.I find that There is a very big bug about Chinese Article on Geeklog 1.8.1 and 2.0.0rc1.
When I write a Chinese Article,my geeklog sites When I finished writing the Chinese article, and then published on my website.Articles become "????????????". I installed the website, check the "UTF-8". Partner has to try Geeklog 1.8.1 and 2.0.0rc1, re-install the site twice I found the MySQL database table article, those Chinese article is displayed as "????????????" I try to comment on the Japanese, the Japanese lettersChinese and Japanese UTF-8 language file for???????. "My Geeklog site I think it should Geeklog program. previous partners seem to install Geeklog 1.7.x, there is no suchproblems.
I hope you will be able to fix this problem is very urgent.
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
I mentioned Forum Geeklog official website, and hair stomach again the Chinese Post, is also showing a lot of "??????????????"?I come from China, I wrote in the January 8, 2013 at 21:00 of the problem posts.?
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
My personal website?http://www.chunxiao.me?owered by wordpress?
http://cn.chunxiao.me(powered by Geeklog )

I support Geeklog ?Welcome to contact me
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Your site displays Chinese characters fine so it is probably your database.

Is your database UTF-8?

Also make sure your geeklog tables are UTF-8. I believe a bug has been reported that on some installs they are not.

Tom
One of the Geeklog Core Developers.
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
I checked my MySQL database is UTF-8, attach screenshots(http://www.chunxiao.me/xweb/image/a1.png ; http://www.chunxiao.me/xweb/image/A2.png)
I published in Geeklog.net Chinese comments, are also on display???????? "Geeklog is the official website also does not support the Chinese-language content. I recognize Geeklog program may not support the Chinese, perhaps the the Geeklog program PHP file is not strictly support UTF-8.
Could you check the recent the Geeklog program files in the new version to fix the error.
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
To convert your Geeklog to utf-8 you can find inspiration on:

- http://www.geeklog.net/article.php?story=200410120657418

- http://geeklog.fr/wiki/iso-8859-to-utf8
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Your right Geeklog.net doesn't support Chinese characters Oops!

We need to convert our db over.

Your database may be utf-8 but are all the tables? Make sure the tables are utf-8. If you checked the utf-8 option in the install and they still are not then you have come across a bug (which has been submitted already). You will have to manually convert the tables

On my development server the utf-8 option works for me in the install and I can save chinese characters in comments and stories.

Visit Ben's links for more information on how to do this
One of the Geeklog Core Developers.
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
Big Grin Today, I view the MySQL database table, the original codes are "latin1_swedish_ci I modify Stories library table structure will change" latin1_swedish_ci "to" UTF8_general_ci, I re-published the Chinese article, this time can be displayed.
However, when I install Geeklog (installed three or four times), I remember all the UTF-8 option is checked, but still "latin1_swedish_ci" .. I think Geeklog installer appears bugs. Should be checked and corrected.
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
You are correct it is a bug. I cannot reproduce it (I am on a Windows Server) but another person reported similar problems. Can you let us know what OS you are using along with versions of your web server, php and mysql?

Thanks

Tom
One of the Geeklog Core Developers.
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
Server operating system is Linux, the system architecture is X86_64; MySQL version 5.1.66-cll; PHP version 5.2.17; the PERL version is 5.8.8; Apache version is 2.0.63
I also found that the site name and slogan can not be filled in either English or Chinese. But you can modify the database table to fill in either English or Chinese, all OK. Attach screenshots (http://www.chunxiao.me/xweb/image/geeklogbug/01.png
http://www.chunxiao.me/xweb/image/geeklogbug/02.png)
Crawls the web search engine spider simulation, Title is blank. Perhaps this is a new bug.

thanks

chunxiao.

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

ivy

Forum User
Full Member
Registered: 11/25/04
Posts: 314
Location:Tokyo Japan
This is not a bug.
Please install after setting MySQL's collation "utf8_general_ci".

Geeklog works on multi byte languages.
e.g.
http://www.jtb-gts.com (English/Chinese/Korean)
http://www.geeklog.jp (Japanese)

Geeklog Japan https://www.geeklog.jp
 Quote

Status: offline

kobab

Forum User
Regular Poster
Registered: 02/22/10
Posts: 73
According to one of Geeklog Japanese core member, Debian default install makes MySQL's collation latin_swedish_ci. Maybe this occurs depending on server OS' distribution, version or settings etc.

Thus, in case of multi byte language environment, we need to check if MySQL's collation is utf8_general_ci before Geeklog installation. This is our Japanese community's understanding. This is not a Geeklog's bug.


Meanwhile, I am please to know Geeklog has been used for Chinese language as well.
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
Big Grin I recently with Geeklog program, the establishment of a Geeklog Chinese lovers community site (site name Hanyu Pinyin is " Zhi Le Gong Yuan " ).
URL is http://cn.chunxiao.me . Welcome to visit!







The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
I've modified by manually "professional" theme folder under "header.thtml" file, and can show the Title and slogan. Facilitate the search engines crawl and included. Big Grin
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1470
Location:Canada
Quote by: kobab

According to one of Geeklog Japanese core member, Debian default install makes MySQL's collation latin_swedish_ci. Maybe this occurs depending on server OS' distribution, version or settings etc.

Thus, in case of multi byte language environment, we need to check if MySQL's collation is utf8_general_ci before Geeklog installation. This is our Japanese community's understanding. This is not a Geeklog's bug.



At the very least it sounds like we should at least inform the user in the docs to make sure the collation of their database is utf-8.
One of the Geeklog Core Developers.
 Quote

Status: offline

ivy

Forum User
Full Member
Registered: 11/25/04
Posts: 314
Location:Tokyo Japan
Only "utf8_general_ci"

utf8_unicode_ci ... garbled characters in part.
Geeklog Japan https://www.geeklog.jp
 Quote

Status: offline

kobab

Forum User
Regular Poster
Registered: 02/22/10
Posts: 73
At the very least it sounds like we should at least inform the user in the docs to make sure the collation of their database is utf-8.

Indeed. This makes Geeklog more user friendly rather than insisting "this is not a bug". Hope this would be included in wiki.geeklog.net installation page or readme docs in the near future.
 Quote

Status: offline

ivy

Forum User
Full Member
Registered: 11/25/04
Posts: 314
Location:Tokyo Japan
I guess this is all of Japanese CMS user's understanding.

Japanese wiki for installation:
http://wiki.geeklog.jp/index.php?title=Install14

Encode: UTF-8 Unicode (utf8)
Collation: utf8_general_ci

Geeklog Japan https://www.geeklog.jp
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
I think you said it right.Because my website host Server character set UTF-8 Unicode (utf8) ,server connection proofreading "utf8_general_ci". I put my Geeklog site database table structure was revised to "utf8_general_ci", after the test, the successful realization of the Chinese, Japanese, Vietnamese, Korean, Thai, Arabic, Farsi, and other non-Latin alphabet language support, but does not support Lao (a Southeast Asian country, which borders China); Mongolian and Tibetan are not tested.
I use Cpanel host in the United States, not on behalf of the Chinese mainland. Although I come from China mainland, but In the Internet field, the Chinese mainland is a very different very special Internet environment.
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Status: offline

chunxiao

Forum User
Newbie
Registered: 01/08/13
Posts: 13
In the field of Internet, Our mainland China use GBK character set, the main support for Simplified Chinese; Hong Kong and Taiwan use Big5 character set, the main support for Traditional Chinese.
The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me
 Quote

Page navigation

All times are EST. The time is now 06:16 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content