[User Error] Couldn't run query: SELECT Distinct Locale FROM SiteTree GROUP BY Locale Unknown column 'Locale' in 'field list'

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 Distinct Locale FROM SiteTree GROUP BY Locale Unknown column 'Locale' in 'field list'
  Line 400 of MySQLDatabase.php
• MySQLDatabase->databaseError(Couldn't run query: SELECT Distinct Locale FROM SiteTree GROUP BY Locale | Unknown column 'Locale' in 'field list',256)
  Line 102 of MySQLDatabase.php
• MySQLDatabase->query(SELECT Distinct Locale FROM SiteTree GROUP BY Locale,256)
  Line 120 of DB.php
• DB::query(SELECT Distinct Locale FROM SiteTree GROUP BY Locale)
  Line 426 of SQLQuery.php
• SQLQuery->execute()
  Line 1133 of Translatable.php
• Translatable::get_existing_content_languages(SiteTree)
  Line 1204 of CMSMain.php
• CMSMain->MultipleLanguages()
  
• call_user_func_array(Array,Array)
  Line 550 of ViewableData.php
• ViewableData->cachedCall(MultipleLanguages,,)
  Line 591 of ViewableData.php
• ViewableData->hasValue(MultipleLanguages)
  Line 308 of .cacheZ..home.non-existent-host.SilverStripeNew.cms.templates.Includes.CMSMain_left.ss
• include(C:\Documents and Settings\ÊÌ\Local Settings\Temp\silverstripe-cacheZ--home-non-existent-host-SilverStripeNew\.cacheZ..home.non-existent-host.SilverStripeNew.cms.templates.Includes.CMSMain_left.ss)
  Line 354 of SSViewer.php
• SSViewer->process(CMSMain)
  Line 773 of ViewableData.php
• ViewableData->renderWith(Array)
  Line 480 of LeftAndMain.php
• LeftAndMain->Left()
  
• call_user_func_array(Array,Array)
  Line 408 of ViewableData.php
• ViewableData->XML_val(Left,,1)
  Line 59 of .cacheZ..home.non-existent-host.SilverStripeNew.cms.templates.LeftAndMain.ss
• include(C:\Documents and Settings\ÊÌ\Local Settings\Temp\silverstripe-cacheZ--home-non-existent-host-SilverStripeNew\.cacheZ..home.non-existent-host.SilverStripeNew.cms.templates.LeftAndMain.ss)
  Line 354 of SSViewer.php
• SSViewer->process(CMSMain)
  Line 175 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(/admin/)
  Line 118 of main.php