Re: User Groups not synced correctly with PHPbb 2.0.18

[Timofey]

I have a "better" problem. I haven't run the coppermine (hereinafter referred to as C.) for long. I started it the day before yesterday and it worked fine. Later i created accounts for my friends, who were supposed to have the admin rights. And it worked great, too. However, when i integrated the thing with phpBB 2.0.8, the above mentioned friends turned out to have lost their admin priviledges and i couldn access the users list in order to grant them those rights (i kept receiving the message "error while processing the database query". Well, the best thing i could think of is to debridge the two entities, but after that i CAN NO LONGER LOG IN AS THE ADMIN!!! What can i DO ABOUT IT?
PLEASE HELP!!!


I have the following issue when trying to bridge coppermine and XXX:
unable to log in as Admin
couldnt see the users list while the C and phpBB 2.0.8 were integrated:
"error processing the database query"


Coppermine install: http://pasportov.net/album/
Forum install: http://pasportov.net/phpBB2/
Coppermine version: cpg1.4.2
Forum version: phpBB 2.0.8
Test user account: zloy / gthtdjl

BridgeManager settings:
Forum URL:  http://pasportov.net/phpBB2/
Relative path to your BBS's config file:  ../phpBB2/
Use post-based groups?:  1

[Timofey]

And the point is that i don't understand what happens AT ALL!!! The point is that the database entry with my name and CORRECT pasword does exist in the users table in the database.
By the way, my name as the admin of the C and the phpBB were the same. As well as the password. Could it be the cause of the problem?

[Nibbler]

Don't hijack other people's threads with unrelated problems. Temporarily comment out this line in groupmgr.php and then go there directly in your browser to re-sync the groups.

Code Select Expand

if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);

Code Select Expand

//if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);

The older phpbb bridge needs updating with new fixes, please have patience.

[Timofey]

Sorry for having hijacked the other thread.
I've done what you told me to. But i still cant log in under my admin login and i don't have the admin buttons under other users.
is it worth, perhaps, running the install.php again?
Or what else can i do? And why does it happen?
Could you at least tell me what properties should an Admin have in the database (mysql)? Perhaps something got corrupt in the integration process and i could fix it manually?

[Timofey]

Sorry again. It seems to have solved the login problem. However, i still cannot able to view the users list, whether the post groups are enabled or disabled.

[Nibbler]

Please wait for me to post the updated file, I'll need to find and install phpbb 2.0.8 first.

[Timofey]

And, sorry for bothering again, can the fact, that phpBB and the C use different dbs be the cause of the problem?
However, it doesnt seem it can, for i still can see the CORRECT joint list of usergroups from both phpBB and the C. While there is a bug in there, too. For the groups, whose names are in Russian (i am russian) are shown as empty fields. The ones, that have numbers in them, or commas and fullstops, have only these symbols in the fields.
Maybe i could fix the problems myself? What should i be looking for and in which files?

[Timofey]

Here is the message i get in the debug mode.

While executing query "SELECT count(*) FROM `danshin1_past`.phpbb2_users WHERE 1" on 0

mySQL error:


Файл: /pub/home/danshin1/pastol/htdocs/album/include/functions.inc.php - Строка: 248

[Timofey]

I hope that what i write is of some assistance.
The line that is making the dbquery is in the udb_base.inc.php file, #172

Code Select Expand

$result = cpg_db_query("SELECT count(*) FROM {$this->usertable} WHERE 1");

I'm not an advanced php or MySQL programmer, so i have a question: is "WHERE 1" really correct syntax? In fact, i'm more used to "WHERE somethin=something_else". If it is correct, than what does it mean? Or, at least, what is it supposed to mean?

[Nibbler]

Just wait for me to post the updated file. The cause of the error is well understood.

[Timofey]

And there is another thing i thought might be of some importance (sorry for bugging again ). The point is that phpBB and the C use DIFFERENT databases. I mean, they both use MySQLs, but the databases have different names. I tried experimenting with the code and inserted

$new_connexion = cpg_db_connect();

into udb_base.inc.php into the "get_user_count()" function after "if (!$user_count) {" thing. The error message changed into "acces for (the user of the C database) was denied for (the phpBB) database.

So, may the fact that the two things use different dbs pose a problem?

[Nibbler]

I'm going to lock this thread if you keep on posting

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=24357.msg112047#msg112047

[Timofey]

Now then... The fact that the two thingies used different databases turned out to be the cause of my userlist problem. Having unlocked the installation script and having run the script once again, i managed to solve it (now they use the same db). The group problem still persists, but i haven't looked through the thread you directed me to. Thanx for that, anyway. Im going to read it right away. My point is that ALL USERS SHOULD USE THE SAME DBS FOR THE C AND PHPBB. I have never seen this piece of advice anywhere.
Still, i see the correct number of usergroups, even the names that are in latin alphabet. Are you sure the briging works alright with non-latin fonts?

And one more thing: for some unknown reason, i can't see the C unless i have logged in in the phpBB. That is a real mystery . Sorry for having posted the message. Please dont lock it 'Tis sensible, isnt it?

[Timofey]

Ive seen the thread you directed me to, downloaded and uploaded the files you posted there. Thanx for them, but they dont solve the problem. I still don't see the russian names of the groups. And it is really crucial. Thanx in advance.

[Joachim Müller]

http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#lamesupport

Stop speed-posting!