Welcome to the GavickPro Community Member's Area! Lost Password? No account yet? Register
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Re:How do I change Photoslide titles to UTF-8 in 1 (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:How do I change Photoslide titles to UTF-8 in 1
#3764
uno (User)
Fresh Boarder
Posts: 19
graphgraph
User Offline Click here to see the profile of this user
Gender: Male retush.com uno Location: Croatia Birthdate: 1965-03-31
How do I change Photoslide titles to UTF-8 in 1.5 2 Months, 2 Weeks ago Karma: 0  
I am finishing a The News based site in Croatian, and need Photo Slide titles to accept non English characters.

Currently that's not the case.

Everything else is working pretty fine and I wish to congratulate you for fabulous template.
 
Report to moderator   Logged Logged  
 
Taking care!
  The administrator has disabled public write access.
#3766
Dziudek (Moderator)
Moderator
Moderator
Posts: 703
graph
User Offline Click here to see the profile of this user
Gender: Male Dziudek's Jogger
Re:How do I change Photoslide titles to UTF-8 in 1 2 Months, 2 Weeks ago Karma: 9  
I found solution for it

File : class.psdb.php :

after line (line number 38):

Code:

mysql_select_db($db, $this->connection);
add this code:
Code:

mysql_query ('SET NAMES utf8'); mysql_query ('SET CHARACTER_SET utf8_general_ci');
of course probably you should to rewrite text with non English chars
 
Report to moderator   Logged Logged  
 
http://dziudek.jogger.pl - my jogger ;]
  The administrator has disabled public write access.
#3772
uno (User)
Fresh Boarder
Posts: 19
graphgraph
User Offline Click here to see the profile of this user
Gender: Male retush.com uno Location: Croatia Birthdate: 1965-03-31
Re:How do I change Photoslide titles to UTF-8 in 1 2 Months, 2 Weeks ago Karma: 0  
Dziudek wrote:
QUOTE:
I found solution for it :)

File : class.psdb.php :


Thanks, Dziudek,

now it's working fine.
 
Report to moderator   Logged Logged  
 
Taking care!
  The administrator has disabled public write access.
#4616
T_H_A1984 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 0  
Dziudek wrote:
QUOTE:
I found solution for it :)

File : class.psdb.php :

[/code]



I've got the same problem with Bulgarian. Where could I find this file?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4618
Seichinha (Moderator)
Moderator
Posts: 626
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Location: Amadora - Portugal Birthdate: 1973-10-25
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 17  
The file is on .../administrator/components/com_gk_photoslide/class.psdb.php

But there is another way...
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4619
T_H_A1984 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 0  
Seichinha wrote:
QUOTE:
The file is on .../administrator/components/com_gk_photoslide/class.psdb.php

But there is another way...


I found it and put the code after the old code

"mysql_select_db($db, $this->connection);"

but it still doesn't work


What ist the other way?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4620
Seichinha (Moderator)
Moderator
Posts: 626
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Location: Amadora - Portugal Birthdate: 1973-10-25
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 17  
See this video Tutorial (not oficial)

This example was made on J!1.5 db

Video Tutorial Link
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/03/26 04:38 By Seichinha.
  The administrator has disabled public write access.
#4645
T_H_A1984 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 0  
Seichinha wrote:
QUOTE:
See this video Tutorial (not oficial)

This example was made on J!1.5 db

Video Tutorial Link


Dear Support,

I watched the video and made exactly the things you show and then changed the fields in my Photo Slide in my Web-sit Control panel,
but it still doesn't work. Here you can see:





 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4646
Seichinha (Moderator)
Moderator
Posts: 626
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Location: Amadora - Portugal Birthdate: 1973-10-25
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 17  
I suppose that you use Russian Language...
Honestly, i don't know witch encode is Russian language.
If you know, just make the same steps, but select instead of utf8_general_ci the russian one.
That will do it.

Remember, after you do this, you must go to your Photoslide Administration and refrase the characters again, so the changes made on the db may have effect on characters display.

Cheers
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4647
T_H_A1984 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 0  
Seichinha wrote:
QUOTE:
I suppose that you use Russian Language...
Honestly, i don't know witch encode is Russian language.
If you know, just make the same steps, but select instead of utf8_general_ci the russian one.
That will do it.

Remember, after you do this, you must go to your Photoslide Administration and refrase the characters again, so the changes made on the db may have effect on characters display.

Cheers


I use Bulgarian which is also cyrilic language.
If I change everything to cp1251_bulgarian_ci will Photo Slide work?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4648
Seichinha (Moderator)
Moderator
Posts: 626
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Location: Amadora - Portugal Birthdate: 1973-10-25
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 17  
Yes, i don't see why not.

Only change the fields indicated on the video.
They are the ones that are important for you.

Don't forget to refrase again your text, after changes on db.
If you don't do this, it will not show right.

Cheers
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/03/26 15:01 By Seichinha.
  The administrator has disabled public write access.
#4650
T_H_A1984 (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month, 2 Weeks ago Karma: 0  
Seichinha wrote:
QUOTE:
Yes, i don't see why not.

Only change the fields indicated on the video.
They are the ones that are important for you.

Don't forget to refrase again your text, after changes on db.
If you don't do this, it will not show right.

Cheers


Still doesn't work. Probably I must change something in mySQL DB
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4974
arrozdoce (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Gender: Male NETLUSA.COM paulo@netlusa.com Birthdate: 1976-11-11
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month ago Karma: 0  
i try this for portuguese characters but don't works, sample ç
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4976
Seichinha (Moderator)
Moderator
Posts: 626
graphgraph
User Online Now Click here to see the profile of this user
Gender: Male Location: Amadora - Portugal Birthdate: 1973-10-25
Re:How do I change Photoslide titles to UTF-8 in 1 1 Month ago Karma: 17  
"Olá Paulo. Tenho que escrever em inglês."

Hi


The utf8_general_ci should work, but if not, set to latin 1.
So, go to your sql database and change the jos_gk_photoslide_groups and jos_gk_photoslide_images tables and set to latin 1, instead of latin 2.

Return to your text in Portuguese on the Photoslide administration, refrase again and save.
It should work.

If you have any problem, email me: paulo[at]gavick[dot]com

Cheers (Abraço)
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop