Image picker not displaying in the edit page

capricorn - October 28, 2009 - 19:00
Project:Image Picker
Version:6.x-2.x-dev
Component:User interface
Category:support request
Priority:critical
Assigned:Unassigned
Status:active
Description

I have installed image picker and seeing in my account was even able to upload the image however when I go to edit the content page nothing is appearing in the Image picker box. In addition I am getting the following errors - 1) warning:pg_query()[function.pg.query]:Query failed:ERROR:column "g.uid" must appear in the GROUP BY clause or be used in an aggregate function in C:\xammp\htdocs\drupal-6.14\includes\database.pgsql.inc on line 139.

2)user warning:query:SELECT g.gid. g.uid, g.group_name, g.group_description, g.state, g.public, COUNT(i.img_id) AS ct,u.name FROM imagepicker_user_groups g LEFT JOIN imagepicker_group_images i USING(gid), users u WHERE g.uid=u.uid GROUP BY g.gid ORDER BY g.group_name ASC in C:\xammp\htdocs\drupal-6.14\modules\imagepicker.admin.inc on line 629

Please help.

#1

hutch - October 29, 2009 - 01:05

First of all, you need to get imagepicker (and any other contributed modules) installed correctly.
Imagepicker should be installed in (on your system)

C:\xammp\htdocs\drupal-6.14\sites\all\modules\imagepicker

so that the path to imagepicker.module is

C:\xammp\htdocs\drupal-6.14\sites\all\modules\imagepicker\imagepicker.module

Same goes for themes, they should be in

C:\xammp\htdocs\drupal-6.14\sites\all\themes

I would strongly recommend that you uninstall imagepicker completely by going to administration > site building > modules, unchecking it, save, then click on the uninstall tab and following that through, then remove the imagepicker files from

C:\xammp\htdocs\drupal-6.14\modules\

As the line number being reported is wrong,
Fetch a fresh copy from drupal.org and unpack it into C:\xammp\htdocs\drupal-6.14\sites\all\modules\

use the stable version, the dev version only has exif in addition and that might not work on Windows.

http://ftp.drupal.org/files/projects/imagepicker-6.x-2.5.tar.gz

Then go back to administration > site building > modules and enable imagepicker
Go to site configuration > imagepicker, set things up as you want them and save.

Then see if this error persists.

If it does report back, but I have never seen that error. To be fair I have not tried Drupal on Windows.

Install the devel module too, it makes flushing the cache easier apart from other things.

 
 

Drupal is a registered trademark of Dries Buytaert.