Image picker not displaying in the edit page
| Project: | Image Picker |
| Version: | 6.x-2.x-dev |
| Component: | User interface |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
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
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.