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

Image gallery


Reply

3 Posts   932 Views

Avatar
cumquat

24 October 2009 at 3:25am Community Member, 198 Posts

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

Avatar
UncleCheese

24 October 2009 at 4:56am 4085 Posts

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

?!

Does it exist?

Avatar
cumquat

24 October 2009 at 5:04am (Last edited: 24 October 2009 5:24am), Community Member, 198 Posts

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