OlivierF wrote:

plg wrote:

Hi OlivierF,

OlivierF wrote:

Is is normal that all photo's uploaded through the community plugin are listed as "Uploaded by Guest" instead of the user name?
I'm using Apache LDAP authentication, perhaps that changes something?

And when you look at your history, are these users considered as "guest" or their actual user name?

Hi,
Thank you for the quick reply.
They are registered as regular users, after the login, a Piwigo user is generated from their LDAP login.
I used this guide:
http://anotheritblog.net/2014/07/17/piw … ntication/

Also, on the history page, there is 0 reference of guest.

[Github] Piwigo-community issue #9

Hi everyone, I have a problem with the Community plugin: when my users try the flash uploader, at the the end of the upload they get "HTTP Error (500)". How can I resolve this?

Hi all there

nobody around who knows how to solve this privacy-level-issuue? It is really annoying, when I have to login everytime a user as uploaded a photo to change the privacy level. It would be ok for me, to change the code, but I don't know where..

Thanks.

Roswita wrote:

Hi everybody

Community is a great plugin and it works to 99% for me as i wish. Thanks.

However, i have one issue: it seems - as far as i have read in this an the german forum - that for community users the default ulpoad privacy level is "everybody". I would like to change this default permission to "friends". How can i do this (probably changing the code somewhere) ??

Reason: we have a closed gallery (school-mates). All users belong to the privacy level "friends". Nobody outside should be able to see the photos. As it is now, any time a user has uploaded some photos, i need to login as admin and change the privacy-level manually to friends.

Any help or hints are greatly appreciated. Thanks
Roswita

Hello plg.
I have some problems when trying to integrate Community plugin with external authentication from forum software PhpBB3 version 3.0.x  https://www.phpbb.com/downloads/3.0/
I have tried with both Piwigo 2.7.4 and 2.8.1 with old (existing photos) or fresh install (no photos). I have tried with PhpBB 3.0.6 and PhpBB 3.0.14 using a forum that already have few hundreds registered users.

Operating system: Linux
PHP: 5.6.18
MySQL: 5.1.73
Graphics Library: GD bundled (2.1.0 compatible)
Plugins used: Admin Tools, Local Files Editor, Community

I have used this configuration in my Local Files Editor to integrate with PhpBB , inspired from this post http://piwigo.org/forum/viewtopic.php?p … 23#p141623

$conf['users_table'] = 'phpbb_users';
$conf['external_authentification'] = true;
$conf['user_fields'] = array(
  'id' => 'user_id',
  'username' => 'username_clean',
  'password' => 'user_password',
  'email' => 'user_email'
  );
$conf['password_hash'] = create_function('$s', 'return md5($s);');
$conf['password_verify'] = 'pwg_password_verify';
$conf['guest_id'] = 1;
$conf['default_user_id'] = $conf['guest_id'];
$conf['browser_language'] = true;
$conf['webmaster_id'] = 2;
$conf['guest_access'] = true;

then I executed this query to prepare the database (and checked manually to see the tables are empty

delete from piwigo_user_access;
delete from piwigo_user_cache;
delete from piwigo_user_feed;
delete from piwigo_user_group;
delete from piwigo_user_infos;
delete from piwigo_sessions;
delete from piwigo_rate;
update piwigo_images set rating_score = null, added_by = '2';
delete from piwigo_caddie;
delete from piwigo_favorites;

The external authentication seem to work perfect. I can login to Piwigo with both admin or regular PhpBB3 user. No problem so far.
The next step is that I want an album to be created automatic for the registered users from PhpBB3. I installed the Community plugin.
But when I try to access the Community plugin admin panel http://mysite.com/gallery/admin.php?pag … -community
I get this error:

Warning:  [mysql error 1052] Column 'user_id' in field list is ambiguous
SELECT
    user_id AS id,
    username_clean AS username
  FROM phpbb_users AS u
    INNER JOIN piwigo_user_infos AS uf ON uf.user_id = u.user_id
  WHERE uf.status IN ('normal','generic')
; in /...../gallery/include/dblayer/functions_mysqli.inc.php on line 830

Fatal error: Call to a member function fetch_assoc() on boolean in /....../gallery/include/dblayer/functions_mysqli.inc.php on line 211

this kind of error seem to appear because they are 2 identical column names in the query but table is not specified
http://stackoverflow.com/questions/6638 … -ambiguous
but I see "u." (as phpbb_users) is specified in the table alias before the column name. so I do not understand where is the problem.

an user already reported this kind of problem
http://piwigo.org/forum/viewtopic.php?p … 26#p141626

however his fix don't seem to work for me. maybe he used an older version and you added something new to the plugin. maybe a similar query is executed again in another place, or maybe is because different MySQL versions.

Last edited by eliz82 (2016-05-20 12:23:04)

Well the problems are not finished yet. now I see all users list correctly in plugin Comunity (when i try to access Permissions=>Who=>Specific user ... all users in my PhpBB forum are displayed correctly).

But when I try to access Administration=>Users=>Manage
an javascript alert box appear with an error

DataTables warning (table id = 'userList'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error

and the user list is empty.

The error seem to be generated in the themes\default\js\plugins\jquery.dataTables.js

The strange thing is even the user list is empty the "Select all" link is working normally , selecting all the users. See the print screen.

Makis wrote:

Hi,

I cannot find how a specific user will be able to modify the names of the photos.

As admin, I have uploaded thousands of photos, but I now want from the users of my community to be able to change the name in each photo .

Is it possible?

if they are uploaded by them (they are the owner) ... yes, they can. but the interface is vary basic.
just install plugin Admin Tools, that will give user option to modify they own pictures title.

if they are not uploaded by them (they are not the owner) use this plugin http://piwigo.org/ext/extension_view.php?eid=563
from what i tested is compatible with 2.8.1 and 2.7.4, it did not give me error, but the plugin is more hard to configure

Last edited by eliz82 (2016-06-24 22:19:22)