Piwigo.org

Wade · 2013-02-19 17:45:32

I'm having a problem with the album permissions while using this plug-in. In general it works fine but it is not inheriting the album permissions from the parent album. I have users set to upload images into a specific album. They can do that. However the parent album is set to private and is only viewer to certain groups. The users are members of that group but the only default permissions that are created in the album they created are those for administrators. Is there a way to set it so it can inherit the group permissions from its parent album?

Derrick Hawkins · 2013-03-05 20:11:55

I upgraded my Piwigo to 2.5 this morning (over 2.4.7). When I went to the Plugins it says that the Community Plugin was not compatible so I went to the Extensions page (http://piwigo.org/ext/index.php?page=19) and got the Community Plugin (and noticed its the same version as the one that says not compatible). Then I went to the Plugins Available just to check and the same version was there so I installed it. It went fine until I tried to activate it.:

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"piwi_community_permissions" (
"id" INTEGER NOT NULL,
"type" VARCHAR(255) NO' at line 1

CREATE TABLE "piwi_community_permissions" (
"id" INTEGER NOT NULL,
"type" VARCHAR(255) NOT NULL,
"group_id" INTEGER,
"user_id" INTEGER,
"category_id" INTEGER,
"recursive" BOOLEAN default true,
"create_subcategories" BOOLEAN default false,
"moderated" BOOLEAN default true,
PRIMARY KEY ("id")
)
; in /home/nudefrog/fixshun.com/piwi/include/dblayer/functions_mysqli.inc.php on line 813

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"piwi_community_pendings" (
image_id INTEGER NOT NULL,
state VARCHAR(255) NO' at line 1

CREATE TABLE "piwi_community_pendings" (
image_id INTEGER NOT NULL,
state VARCHAR(255) NOT NULL,
added_on TIMESTAMP NOT NULL,
validated_by INTEGER
)
; in /home/nudefrog/fixshun.com/piwi/include/dblayer/functions_mysqli.inc.php on line 813

Notice: Undefined index: local_data_dir in /home/nudefrog/fixshun.com/piwi/plugins/community/maintain.inc.php on line 149

Warning: [mysql error 1146] Table 'nudefrog_piwi344.piwi_community_permissions' doesn't exist

SELECT
COUNT(*)
FROM piwi_community_permissions
; in /home/nudefrog/fixshun.com/piwi/include/dblayer/functions_mysqli.inc.php on line 813

Fatal error: Call to a member function fetch_row() on a non-object in /home/nudefrog/fixshun.com/piwi/include/dblayer/functions_mysqli.inc.php on line 165

soreilly · 2013-03-06 16:35:23

My upgrade to 2.5 failed from 2.47, so I installed a clean 2.5 then installed (for the first time) community and am getting the same messages on activate.

Source code from error page uploaded below

plg · 2013-03-06 17:32:48

OK, I reproduce, I investigate.

plg · 2013-03-06 17:49:49

New version 2.5.b available. Thank you for the feedback.

bnl552 · 2013-03-06 18:30:46

On Monday I upgraded to Piwigo 2.5 (From 2.47) and since the upgrade I have been having issues with Community and the mobile app. Users have access to upload photos from the website itself but using the android app it does not list any albums. It just lists "-----" and "undefined". Everything was working fine prior to the update and all albums were showing in the list. I am using Community version 2.5.b.

soreilly · 2013-03-06 19:43:24

Thanks plg Great job

Jose Coronado · 2013-03-21 19:54:59

How can the community plugin is installed manually?

Thanks,
JOSE

MrTall · 2013-03-26 00:04:58

I get this error from the admin control panel:

Code:

Warning:  [mysql error 1052] Column 'user_id' in field list is ambiguous

SELECT
    user_id AS id,
    username AS username
  FROM phpbb_users AS u
    INNER JOIN piwigo_user_infos AS uf ON uf.user_id = id
  WHERE uf.status IN ('normal','generic')

The only difference is that my piwigo installation doesn't work of a piwigo user database, but a phpbb user database. Is there anything I can do?

MrTall · 2013-03-31 00:12:40

Well I found where the query comes from (plugins/community/admin_permissions.php line 247 onwards):

Code:

$query = '
SELECT
    '.$conf['user_fields']['id'].' AS id,
    '.$conf['user_fields']['username'].' AS username
  FROM '.USERS_TABLE.' AS u
    INNER JOIN '.USER_INFOS_TABLE.' AS uf ON uf.user_id = id
  WHERE uf.status IN (\'normal\',\'generic\')
;';
$result = pwg_query($query);

Anyone know what I could change to prevent the error in my previous post? Thanks for any help! :D

MrTall · 2013-03-31 10:31:12

If anyone is having the same problem, this is the fixed query:

Code:

$query = '
SELECT
    u.'.$conf['user_fields']['id'].' AS id,
    '.$conf['user_fields']['username'].' AS username
  FROM '.USERS_TABLE.' AS u
    INNER JOIN '.USER_INFOS_TABLE.' AS uf ON uf.user_id = u.user_id
  WHERE uf.status IN (\'normal\',\'generic\')
;';
$result = pwg_query($query);

plg · 2013-03-31 19:58:26

Thank you MrTall, I will change the code. Is it the only bug of this kind you have encountered?

MrTall · 2013-03-31 21:53:51

plg wrote:
Thank you MrTall, I will change the code. Is it the only bug of this kind you have encountered?

At the moment it's the only bug I've found, I suppose many people operate from the piwigo user database table as opposed to third party user databases like phpbb. I'll report back if I see anything else! Great plugin btw exactly what I wanted for the gallery. :D

artcien · 2013-04-05 18:55:00

I'm having some problems with Community and IE 9. It does work with other browsers but not IE. Anyone else has this issue? I have search for answers but no luck yet.

flop25 · 2013-04-05 19:22:27

You might be in "compatible mode" Could you check?

Piwigo.org

Announcement

#106 2013-02-19 17:45:32

Re: Community plugin, new generation for Piwigo 2.2+

#107 2013-03-05 20:11:55

Re: Community plugin, new generation for Piwigo 2.2+

#108 2013-03-06 16:35:23

Re: Community plugin, new generation for Piwigo 2.2+

#109 2013-03-06 17:32:48

Re: Community plugin, new generation for Piwigo 2.2+

#110 2013-03-06 17:49:49

Re: Community plugin, new generation for Piwigo 2.2+

#111 2013-03-06 18:30:46

Re: Community plugin, new generation for Piwigo 2.2+

#112 2013-03-06 19:43:24

Re: Community plugin, new generation for Piwigo 2.2+

#113 2013-03-21 19:54:59

Re: Community plugin, new generation for Piwigo 2.2+

#114 2013-03-26 00:04:58

Re: Community plugin, new generation for Piwigo 2.2+

Code:

#115 2013-03-31 00:12:40

Re: Community plugin, new generation for Piwigo 2.2+

Code:

#116 2013-03-31 10:31:12

Re: Community plugin, new generation for Piwigo 2.2+

Code:

#117 2013-03-31 19:58:26

Re: Community plugin, new generation for Piwigo 2.2+

#118 2013-03-31 21:53:51

Re: Community plugin, new generation for Piwigo 2.2+

plg wrote:

#119 2013-04-05 18:55:00

Re: Community plugin, new generation for Piwigo 2.2+

#120 2013-04-05 19:22:27

Re: Community plugin, new generation for Piwigo 2.2+

Board footer