Jump to:

7940 Posts in 1543 Topics by 946 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » ImageGallery errors

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Page: 1
Go to End
Author Topic: 768 Views
  • Henry24
    Avatar
    Community Member
    9 Posts

    ImageGallery errors Link to this post

    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?

  • _Vince
    Avatar
    Community Member
    161 Posts

    Re: ImageGallery errors Link to this post

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

  • Henry24
    Avatar
    Community Member
    9 Posts

    Re: ImageGallery errors Link to this post

    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

  • SerenityIT
    Avatar
    Community Member
    13 Posts

    Re: ImageGallery errors Link to this post

    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.

    768 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.