[Solved]: user name shows as question marks [Solved]: user name shows as question marks
 

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]

Main Menu

[Solved]: user name shows as question marks

Started by comrade, January 09, 2009, 07:18:36 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

comrade

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

phill104

It is a mistake to think you can solve any major problems just with potatoes.

comrade

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

comrade

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;
}