SiverStripe was working fine for a month or two when, suddenly, I tried to access the site and I got this error:
Website Error
There has been an error
The website server has not been able to respond to your request.
I added "?isDev=1" to the URL to get more info and I got this:
[User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `StaticSidebar`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `StaticSidebar` ON `StaticSidebar`.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 WHERE (HomepageForDomain REGEXP '(, ^) *jaydelp\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'jaydelp_SSjdp.StaticSidebar' doesn't exist
GET /newsite/?isDev=1
Line 400 in /home/jaydelp/public_html/newsite/sapphire/core/model/MySQLDatabase.php
Source
391 }
392
393 function databaseError($msg, $errorLevel = E_USER_ERROR) {
394 // try to extract and format query
395 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
396 $formatter = new SQLFormatter();
397 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
398 }
399
400 user_error($msg, $errorLevel);
401 }
402 }
403
404 /**
405 * A result-set from a MySQL database.
406 * @package sapphire
Trace
* Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `StaticSidebar`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `StaticSidebar` ON `StaticSidebar`.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 WHERE (HomepageForDomain REGEXP '(, ^) *jaydelp\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'jaydelp_SSjdp.StaticSidebar' doesn't exist
Line 400 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `StaticSidebar`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `StaticSidebar` ON `StaticSidebar`.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 WHERE (HomepageForDomain REGEXP '(,|^) *jaydelp\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'jaydelp_SSjdp.StaticSidebar' doesn't exist,256)
Line 102 of MySQLDatabase.php
* MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `StaticSidebar`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `StaticSidebar` ON `StaticSidebar`.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 WHERE (HomepageForDomain REGEXP '(,|^) *jaydelp\.com *(,|$)') ORDER BY Sort LIMIT 1,256)
Line 104 of DB.php
* DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `StaticSidebar`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `StaticSidebar` ON `StaticSidebar`.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 WHERE (HomepageForDomain REGEXP '(,|^) *jaydelp\.com *(,|$)') ORDER BY Sort LIMIT 1)
Line 426 of SQLQuery.php
* SQLQuery->execute()
Line 2374 of DataObject.php
* DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *jaydelp\.com *(,|$)',)
Line 2320 of DataObject.php
* DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *jaydelp\.com *(,|$)')
Line 47 of RootURLController.php
* RootURLController::get_homepage_urlsegment()
Line 31 of RootURLController.php
* RootURLController->handleRequest(HTTPRequest)
Line 277 of Director.php
* Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
* Director::direct(/)
Line 115 of main.php
I get this error when accessing both the main site and admin pages. I have a feeling that this error is related to some module or plugin that I have installed, since I installed a few on 5/21/2009. However I never noticed any problem accessing the site or the CMS. Any help is highly appreciated. Thank you.
Though I doubt that my system specs have anything to do with this server-based error, here they are:
SilverStripe Version: 2.3.1
OS: Mac OS X 10.5.7
Processor: Dual 2 GHz PowerPC G5
Memory: 4.5 GB DDR SDRAM