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: [Solved]: user name shows as question marks  (Read 3761 times)

0 Members and 1 Guest are viewing this topic.

comrade

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Solved]: user name shows as question marks
« on: January 09, 2009, 07:18:36 pm »

Hi
i just integrated the latest cpg with phpBB3. when i was running them separately, i could register users with russian letters in user id's and they displayed properly. after integration, i assume cpg ignores it's user database and rely on phpBB one. integration itself works fine, but after logging into the forum with userid in russian characters, it displayed as question marks in cpg, as well as question marks are in the galelry name i create, using this user id. Other then that everything works, i can upload files with russian names in them, etc. anyone had similar problems? I converted mySQL to utf8_unicode_ci collation, so both DB's are the same (i dont have to restart mySQL after that, do i?).

thanks

www.russianclubnyc.com/frm
www.russianclubnyc.com/gallery
« Last Edit: January 09, 2009, 11:47:48 pm by Phill Luckhurst »
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: user name shows as question marks
« Reply #1 on: January 09, 2009, 07:37:13 pm »

Have you run charsetmgr.php?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

comrade

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: user name shows as question marks
« Reply #2 on: January 09, 2009, 08:21:39 pm »

it converts cpg database, but after integration, user names are coming from phpBB database. thats what is not working.
Logged

comrade

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: user name shows as question marks
« Reply #3 on: January 09, 2009, 11:44:52 pm »

this worked, modified functions.inc.php

function cpg_db_connect()
{
        global $CONFIG;
        $result = @mysql_connect($CONFIG['dbserver'], $CONFIG['dbuser'], $CONFIG['dbpass']);
        if (!$result) {
                return false;
        }
        if (!mysql_select_db($CONFIG['dbname']))
                return false;
      mysql_query("SET NAMES 'utf8'",$result);
        return $result;
}
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.