Jump to:

7935 Posts in 1536 Topics by 943 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » Image gallery

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: 915 Views
  • cumquat
    Avatar
    Community Member
    191 Posts

    Image gallery Link to this post

    Hi ya,
    Ok been a while but i have a problem with the image-gallery or maybe it has a problem with me :o)
    New install of 2.3.3 go the latest dataobject_manager 310 and version r271 of swfupload, both of them seem fine when i upload version r292 of image gallery my site dies, can't get to any page, can't dev/build or anything. below is the error log, anyone see what i'm doing wrong?

    He waits, he hopes.

    Mick.

    Error: Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `ImageGalleryPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `ImageGalleryPage` ON `ImageGalleryPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *walterandagnes\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'web115-walter.ImageGalleryPage' doesn't exist
    At line 401 in /home/sites/walterandagnes.com/public_html/sapphire/core/model/MySQLDatabase.php
    •   Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `ImageGalleryPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `ImageGalleryPage` ON `ImageGalleryPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *walterandagnes\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'web115-walter.ImageGalleryPage' doesn't exist
    Line 401 of MySQLDatabase.php
    •   MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `ImageGalleryPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `ImageGalleryPage` ON `ImageGalleryPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *walterandagnes\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'web115-walter.ImageGalleryPage' doesn't exist,256)
    Line 102 of MySQLDatabase.php
    •   MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `ImageGalleryPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `ImageGalleryPage` ON `ImageGalleryPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *walterandagnes\.com *(,|$)') ORDER BY Sort LIMIT 1,256)
    Line 120 of DB.php
    •   DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `ImageGalleryPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `ImageGalleryPage` ON `ImageGalleryPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *walterandagnes\.com *(,|$)') ORDER BY Sort LIMIT 1)
    Line 426 of SQLQuery.php
    •   SQLQuery->execute()
    Line 2527 of DataObject.php
    •   DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *walterandagnes\.com *(,|$)',)
    Line 2464 of DataObject.php
    •   DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *walterandagnes\.com *(,|$)')
    Line 64 of RootURLController.php
    •   RootURLController::get_homepage_urlsegment()
    Line 88 of RootURLController.php
    •   RootURLController::should_be_on_root(Page)
    Line 87 of ContentController.php
    •   ContentController->init()
    Line 16 of Page.php
    •   Page_Controller->init()
    Line 299 of Security.php
    •   Security->login(HTTPRequest)
    Line 162 of Controller.php
    •   Controller->handleAction(HTTPRequest)
    Line 129 of RequestHandler.php
    •   RequestHandler->handleRequest(HTTPRequest)
    Line 122 of Controller.php
    •   Controller->handleRequest(HTTPRequest)
    Line 277 of Director.php
    •   Director::handleRequest(HTTPRequest,Session)
    Line 121 of Director.php
    •   Director::direct(/Security/login)
    Line 118 of main.php

  • UncleCheese
    Avatar
    4085 Posts

    Re: Image gallery Link to this post

    "Table 'web115-walter.ImageGalleryPage' doesn't exist"

    ?!

    Does it exist?

  • cumquat
    Avatar
    Community Member
    191 Posts

    Re: Image gallery Link to this post

    cheers for getting back to me, it definitely doesn't exist, this is before I've had a chance to run a dev/build for the image gallery.
    I have installed the dataobject manager and swfupload and dev/build them no worries so far all i have done is ftp'd the folder image_gallery to the site and at that point the site crashes, this has happened on two fresh installs on two separate servers.

    So either there is a problem in the way i'm doing it or a weird issue with the way SS is reading the file structure. Both times completely fresh install and i have taken the modules bit and the version bit off the folder so it is just called image_gallery.

    Mick

    PS the only other module i have on the site is userforms and thats the latest version as well

    915 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.