Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

ImageGallery errors


Reply


4 Posts   830 Views

Avatar
Henry24

Community Member, 9 Posts

1 April 2011 at 1:58pm

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?

Avatar
_Vince

Community Member, 162 Posts

3 April 2011 at 12:56pm

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

Avatar
Henry24

Community Member, 9 Posts

6 April 2011 at 3:42pm

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

Avatar
SerenityIT

Community Member, 13 Posts

11 May 2011 at 2:07am

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.