Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: problem with creating new albums and photos in hebrew characters  (Read 7009 times)

0 Members and 1 Guest are viewing this topic.

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65

I save them and it shows them in question marks
I had problem in the past that the whole database in the new server showed the characters as question marks so I did this:
edied the file
include/functions.inc.php
put this line
      mysql_query("SET CHARACTER SET hebrew",$result);
after  function cpg_db_connect()


I did this to force the database to be in hebrew

but what do I need to do now in the functions file to force new albums and photos to be showed right?

thanks
Logged

papukaija

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Posts: 333
Re: problem with creating new albums and photos in hebrew characters
« Reply #1 on: August 28, 2010, 04:58:01 pm »

Please post a link to your gallery as requested by board rules.
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #2 on: August 28, 2010, 10:10:26 pm »

this is the link to the gallery
http://diet2all.org/gallery/index.php

the strange thing is the second gallery works fine:
http://diet2all.org/dietme/gallery/index.php

but I moved them from different servers


I tried to change the database encode
charcterset
collation
nothing worked
Logged

papukaija

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Posts: 333
Re: problem with creating new albums and photos in hebrew characters
« Reply #3 on: August 28, 2010, 10:37:40 pm »

Why didn't you use this [ur=http://documentation.coppermine-gallery.net/en/configuration.htm#admin_language_charsetl]setting[/url]? Did you read the warnings from that page? You should also upgrade your gallery to cpg 1.5.8

I think that you are now out of support:
Quote
In short terms: Do not change the encoding in Coppermine from utf-8 to anything else unless your really, really know what you're doing and if you understand that this decision will mean that you will get unsupported as far as language issues are concerned.
(from here).

You might be able to solve this issue by setting setting the encoding to utf-8 and then playing with phpmyadmin (be aware, phpmyadsmin is not supported in this forum).
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #4 on: August 29, 2010, 08:59:44 am »

I already upgraded it to the lastest version
so to change it to utf8?
Logged

papukaija

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: 00
  • Offline Offline
  • Posts: 333
Re: problem with creating new albums and photos in hebrew characters
« Reply #5 on: August 31, 2010, 10:20:05 pm »

so to change it to utf8?
Try, but use the setting from your gallery's settings, not in the code.
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #6 on: September 01, 2010, 12:01:39 am »

still not working it shows strange letters
Logged

Αndr

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: problem with creating new albums and photos in hebrew characters
« Reply #7 on: September 01, 2010, 11:20:58 am »

but I moved them from different servers
You need to set the encoding as it was on the old server.
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #8 on: September 01, 2010, 02:22:54 pm »

it was the same...
I tried every possible way that I know to fix it
even changing the encoding inside the database itself (the backup I uploaded)
maybe its a bug?
Logged

Αndr

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: problem with creating new albums and photos in hebrew characters
« Reply #9 on: September 01, 2010, 02:27:47 pm »

It's no bug, but an individual issue. It works for a lot of users (even for one of your galleries). So it depends on your dump file or the export/import. Have you looked directly in your database if the characters are messed up there, too?
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #10 on: September 01, 2010, 03:32:40 pm »

I looked there they look different
the working db has letters like this:
ֳגֳֳֵֻœֳגֲֳ₪ֳֵ
and the one with the problems is like this:
'׳׳ž׳׳׳₪׳œ׳׳ ׳׳œ ׳ž׳ ׳׳׳׳ ׳׳׳׳


I think they have difference right?
Logged

Αndr

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: problem with creating new albums and photos in hebrew characters
« Reply #11 on: September 01, 2010, 03:41:13 pm »

Seems that your source database / dump file and the new database server are using a different encoding. That's no Coppermine issue. I'm not familiar with hebrew. I had some troubles in the past with German umlauts, as my database stored the data in latin1, but Coppermine uses utf-8. So the >1 byte characters get messed up. I'm not sure how I solved that, but I think I tried to use different encodings while exporting/importing my database with MySQLDumper. Good luck :)
Logged

genom

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 65
Re: problem with creating new albums and photos in hebrew characters
« Reply #12 on: September 01, 2010, 04:28:45 pm »

where can I get this mysqldumper?
Logged

Αndr

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.