Jump to:

4873 Posts in 7171 Topics by 1471 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Errors After GoDaddy Automatic Install of SS 2.3.2

Getting SilverStripe up and running on your computer and on your web server.

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

Page: 1
Go to End
Author Topic: 2042 Views
  • Sophie
    Avatar
    Community Member
    33 Posts

    Errors After GoDaddy Automatic Install of SS 2.3.2 Link to this post

    I'm using GoDaddy and have installed SS 2.3.2 through their Hosting Connection. I've done this a number of times before with no issue. Today I've received the following error when trying to pull up the site for the first time:

    [User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `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 `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 '(, ^) *thegoodnews-paper\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'the0922504304573.UserDefinedForm' doesn't exist
    GET /?isDev=1

    Line 400 in /home/content/48/4801448/html/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`.*, `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 `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 '(, ^) *thegoodnews-paper\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'the0922504304573.UserDefinedForm' doesn't exist
    Line 400 of MySQLDatabase.php
    * MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `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 `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 '(,|^) *thegoodnews-paper\.com *(,|$)') ORDER BY Sort LIMIT 1 | Table 'the0922504304573.UserDefinedForm' doesn't exist,256)
    Line 102 of MySQLDatabase.php
    * MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `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 `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 '(,|^) *thegoodnews-paper\.com *(,|$)') ORDER BY Sort LIMIT 1,256)
    Line 120 of DB.php
    * DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `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 `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 '(,|^) *thegoodnews-paper\.com *(,|$)') ORDER BY Sort LIMIT 1)
    Line 426 of SQLQuery.php
    * SQLQuery->execute()
    Line 2524 of DataObject.php
    * DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *thegoodnews-paper\.com *(,|$)',)
    Line 2461 of DataObject.php
    * DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *thegoodnews-paper\.com *(,|$)')
    Line 64 of RootURLController.php
    * RootURLController::get_homepage_urlsegment()
    Line 41 of RootURLController.php
    * RootURLController->handleRequest(HTTPRequest)
    Line 277 of Director.php
    * Director::handleRequest(HTTPRequest,Session)
    Line 121 of Director.php
    * Director::direct(/)
    Line 118 of main.php

    I haven't a clue about how to proceed. Any advice?

  • Willr
    Avatar
    Forum Moderator
    5462 Posts

    Re: Errors After GoDaddy Automatic Install of SS 2.3.2 Link to this post

    Table 'the0922504304573.UserDefinedForm' doesn't exist

    This is saying your UserDefinedForm table does not exist. Are you trying to install with UserForms or have you added the module on? Have you rebuilt the database - visit site.com/dev/build to rebuild your tables.

  • Sophie
    Avatar
    Community Member
    33 Posts

    Re: Errors After GoDaddy Automatic Install of SS 2.3.2 Link to this post

    willr,

    I got ahead of myself on this. I did the new install, and uploaded the userform module before I'd logged into the tool for the first time. I deleted the userform module files and was then able to login in. Once logged in I re-uploaded the userform module and ran dev/build and everything worked fine. Thanks!

    S.

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