Hi,

I installed the dataobjectmanager and uploadify modules, but i seem to be having issues with imagegallery.

after ive created a new image gallery, i use the "add images to default album" button to upload images. after that's done (100% bar, etc), no images are showing up in the photos tab. however, if i go to the files and images tab it shows that the files have been uploaded (image gallery->image gallery->default album)

also, when i go to the image gallery on the published site, it shows 0 images, and clicking on said album throws this error

[User Error] Couldn't run query (42000, 156, [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'File'.): SELECT "ImageGalleryAlbum"."ClassName", "ImageGalleryAlbum"."Created", "ImageGalleryAlbum"."LastEdited", "ImageGalleryAlbum"."AlbumName", "ImageGalleryAlbum"."Description", "ImageGalleryAlbum"."SortOrder", "ImageGalleryAlbum"."CoverImageID", "ImageGalleryAlbum"."ImageGalleryPageID", "ImageGalleryAlbum"."FolderID", "ImageGalleryAlbum"."ID", CASE WHEN "ImageGalleryAlbum"."ClassName" IS NOT NULL THEN "ImageGalleryAlbum"."ClassName" ELSE 'ImageGalleryAlbum' END AS "RecordClassName" FROM "ImageGalleryAlbum" LEFT JOIN File ON File.ID = FolderID WHERE (ImageGalleryPageID = 43 AND File.Name = 'default-album-2') GROUP BY "ImageGalleryAlbum"."ClassName", "ImageGalleryAlbum"."Created", "ImageGalleryAlbum"."LastEdited", "ImageGalleryAlbum"."AlbumName", "ImageGalleryAlbum"."Description", "ImageGalleryAlbum"."SortOrder", "ImageGalleryAlbum"."CoverImageID", "ImageGalleryAlbum"."ImageGalleryPageID", "ImageGalleryAlbum"."FolderID", "ImageGalleryAlbum"."ID", CASE WHEN "ImageGalleryAlbum"."ClassName" IS NOT NULL THEN "ImageGalleryAlbum"."ClassName" ELSE 'ImageGalleryAlbum' END ORDER BY "SortOrder" ASC: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'File'.
GET /about-bby/bby-image-gallery/album/default-album-2

Line 620 in C:\Documents and Settings\hxf\My Documents\My Web Sites\Silverstripe5\sapphire\core\model\Database.php

any ideas?

Taking a bit of a guess here... did you remember to run dev/build?

yes i did, ive since run it a few times after installing a bunch of other modules

maybe i should reinstall it? i still lge etthe "no items found" in my album but i can see the files have been uploaded under the files & images

I am also having upload/import errors.

I attach a file or choose an existing file from the server, click import, looks great.

Choose continue, the frame where the import was, goes to an error 500 page.