Piwigo.org

You are not logged in. (Register / Login)

Announcement

Post a reply

Write your message and submit

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

flop25
2013-04-05 19:22:27

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

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.

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

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 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);
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-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?

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

How can the community plugin is installed manually?

Thanks,
JOSE

soreilly
2013-03-06 19:43:24

Thanks plg Great job

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.

plg
2013-03-06 17:49:49

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

plg
2013-03-06 17:32:48

OK, I reproduce, I investigate.

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

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

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?

Board footer

Powered by FluxBB

About this website · Donate · Contact Piwigo project © 2002-2013