Add new Organic Group fails to create new Top Level folder

I attempted to recreate this issue following the steps outlined and could not replicate it (everything worked as it should) - I am using the latest dev build of filedepot (and the og modules). Are you still experiencing this issue?

I am unable to recreate this issue following the exact steps you gave - would you be able to give a little more detail regarding your setup (and what modules are installed, etc)?

From the first post it sounded as if the error happened on new folder creation - is that the case, or does it happen when the filedepot module loads (eg. q=filedepot)?

Hello,

I can reproduce with the following setup

infra

drupal 7.14:
Apache 2.2.15
MySQL 5.5.23
PHP 5.3.10

Modules installed and enabled (+ dependencies if any)

• ctools
• views
• views_bulk_operations
• entity
• entityreference
• libraries
• og 7.x-2.0-alpha3 (enabling og, og_ui and og access control
• og_extras
• filedepot (with the js libraries as explained in the readme.txt)
• ...

Filedepot Settings:

'ENABLED' Automatically Create Root Level Folder for New Organic Groups

Content Type:

+ Group content type

OG Field settings:

Add visibility field to the Group Bundle

Create a new private group

Access the page http://yourwebsite/filedepot (w/ friendly URL), I get this error:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node' in 'where clause': SELECT metric from {nextag_metrics} WHERE type=:type OR groupid in (node) ORDER BY metric DESC limit 1; Array ( [:type] => filedepot ) in template_preprocess_filedepot_tagcloud() (line 1704 of therootpathofyoursite/sites/all/modules/filedepot/filedepot.module).

After further tests and config: it is working with the supported og version 7.x-1.4.
It is worth to have a look at the changes in the branch 7.x.-2 of the upcoming OG module.

Hope it helps.

-m

strange, could you give more info about your config and/or steps for your install? I can't make it work with og 7.x-2.0-alpha3.

Thanks

@newmember, do you know what you did to make it work?
Trying to pinpoint what exactly is at fault here and reproduce it :)

I'm having the same issue. I've tried clearing cache and restarting apache with no luck.

I just tested on a fresh install with OG 7.x-2 and "/filedepot" launches without issues but as soon as I create a group it gives me the PDOException error. When I delete the group, the file depot page loads again as expected. This is with the default file depot settings

What version of filedepot are you running?

The latest 7.x-1.0-beta2+11-dev (2012-Jun-26)

Are you running beta2 or dev?

The latest dev with OG 7.x-2.x-dev

Hi,
i've found why this error appear. In the code of filedepot.module there is this line
(L.1699)

$groupids = implode(',', array_keys(og_get_entity_groups('user', $user)));

But og_get_entity_groups('user', $user) return an array with entity type as key, because OG can manage multiple entities types (node, user...) as group and here filedepot need a list of groups id's (maybe this was because OG was only focsed on nodes before...)

to arrange this bug i purpose to loop over the array like that :

if ($filedepot->ogenabled) {
	$groupsUser=og_get_entity_groups('user', $user);
	$entitiesType=array_keys($groupsUser);
	
	$groupids ="";
	foreach($entitiesType as $type){
		$groupids .=implode(',',array_values($groupsUser[$type]));
	}
  }

I'm on windows and i've got some difficulties to generate a patch....

and sorry for my english....

I've added a patch from above comment

But still needs work

I don't have the pdo error anymore, but still no top level folder created when creating new group

It should be noted, the patch in #17 will only work if you are using version 2.x of the organic groups module. Also, there are other compatibility issues with OG 7.x-2.x and I am presently working on a new version of filedepot to support both the 1.x and 2.x version of og.

The changes to support OG v1 and v2 have been committed.