Can G2's Google maps module carry double-byte characters as a query?

masaruikeda

Joined: 2009-02-23
Posts: 5

Posted: Wed, 2009-03-25 07:26

Regarding the search feature of Gallery2, it does not work well and show me the internal server error (http status code 500) only when making a search with the keyword containing double-byte characters like Japanese.

As a result of trial and error I made, it may be caused by the map module or by Google maps API, which may not be able to throw double-byte characters as query in order to find images tagged with Google Map fields specified by the user.

Does the issue depend on the module or on Google Maps API?

Does anyone have a workaround to fix it?

GalleryのURL = http://museum.loveriver.jp/main.php
Gallery バージョン = 2.3 コア 1.3.0
API = コア 7.54 ・モジュール 3.9 ・テーマ 2.6 ・埋め込み 1.5
PHP バージョン = 5.2.6 cgi
ウェブサーバ = Apache
データベース = mysqlt 4.1.22-standard, lock.system=flock
ツールキット = Exif, Gd, ImageMagick
高速化 = full/1800, full/1800
OS = Linux vera.speednoc.com 2.6.18-92.1.13.el5 #1 SMP Thu Sep 4 03:51:01 EDT 2008 i686
デフォルトテーマ = matrix
gettext = 有効
ロケール = ja_JP
ブラウザ = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; GTB5; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
GalleryAccessMap内の行テーブル＝23
GalleryAccessSubscriberMap内の行テーブル＝513
GalleryUser内の行テーブル＝5
GalleryItem内の行テーブル＝510
GalleryAlbumItem内の行テーブル＝22
GalleryCacheMap内の行テーブル＝135

SiliconFiend

Joined: 2006-12-27
Posts: 508

Posted: Fri, 2009-03-27 13:49

I don't know if it can handle it or not. I don't see anything specifically that would make it fail on double-byte characters, unless the table was not created with UTF-8, which is a real possibility. The search function on the Google Maps module really has no purpose, I should remove it. You can search on marker color, zoom level, Google Earth LookAt value, or if you're extremely lucky and happen to type the exact coordinates as they're stored in the database, you'll find a picture by location.

masaruikeda

Joined: 2009-02-23
Posts: 5

Posted: Tue, 2009-03-31 05:35

Thanks for you comment.

Actually my environment is created with UTF-8, so is for the database (mySQL). I confirmed that again.

I will be working on it as you suggested.

masaruikeda Joined: 2009-02-23 Posts: 5	Posted: Wed, 2009-03-25 07:26
	Regarding the search feature of Gallery2, it does not work well and show me the internal server error (http status code 500) only when making a search with the keyword containing double-byte characters like Japanese. As a result of trial and error I made, it may be caused by the map module or by Google maps API, which may not be able to throw double-byte characters as query in order to find images tagged with Google Map fields specified by the user. Does the issue depend on the module or on Google Maps API? Does anyone have a workaround to fix it? GalleryのURL = http://museum.loveriver.jp/main.php Gallery バージョン = 2.3 コア 1.3.0 API = コア 7.54 ・モジュール 3.9 ・テーマ 2.6 ・埋め込み 1.5 PHP バージョン = 5.2.6 cgi ウェブサーバ = Apache データベース = mysqlt 4.1.22-standard, lock.system=flock ツールキット = Exif, Gd, ImageMagick 高速化 = full/1800, full/1800 OS = Linux vera.speednoc.com 2.6.18-92.1.13.el5 #1 SMP Thu Sep 4 03:51:01 EDT 2008 i686 デフォルトテーマ = matrix gettext = 有効ロケール = ja_JP ブラウザ = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; GTB5; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) GalleryAccessMap内の行テーブル＝23 GalleryAccessSubscriberMap内の行テーブル＝513 GalleryUser内の行テーブル＝5 GalleryItem内の行テーブル＝510 GalleryAlbumItem内の行テーブル＝22 GalleryCacheMap内の行テーブル＝135
	XUser login Username: * Password: * Create new account Request new password
SiliconFiend Joined: 2006-12-27 Posts: 508	Posted: Fri, 2009-03-27 13:49
	I don't know if it can handle it or not. I don't see anything specifically that would make it fail on double-byte characters, unless the table was not created with UTF-8, which is a real possibility. The search function on the Google Maps module really has no purpose, I should remove it. You can search on marker color, zoom level, Google Earth LookAt value, or if you're extremely lucky and happen to type the exact coordinates as they're stored in the database, you'll find a picture by location.

masaruikeda Joined: 2009-02-23 Posts: 5	Posted: Tue, 2009-03-31 05:35
	Thanks for you comment. Actually my environment is created with UTF-8, so is for the database (mySQL). I confirmed that again. I will be working on it as you suggested.

Can G2's Google maps module carry double-byte characters as a query?

XUser login