7921 Posts in 1359 Topics by 933 members
DataObjectManager Module
SilverStripe Forums » DataObjectManager Module » ImageGallery errors
Discuss the DataObjectManager module, and the related ImageGallery module.
Moderators: martimiz, UncleCheese, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 621 Views |
-
ImageGallery errors
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-2Line 620 in C:\Documents and Settings\hxf\My Documents\My Web Sites\Silverstripe5\sapphire\core\model\Database.php
any ideas?
-
Re: ImageGallery errors
3 April 2011 at 12:56pm
Taking a bit of a guess here... did you remember to run dev/build?
-
Re: ImageGallery errors
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
-
Re: ImageGallery errors
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.
| 621 Views | ||
|
Page:
1
|
Go to Top |
