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?

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.

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.