I got this strange error.
On my 'dev' it works with:
// Enable Translations
i18n::enable();
i18n::set_locale('nl_NL');
i18n::set_default_lang('nl_NL');
I get an error when I change set_default_lang() to 'nl'
On my 'live' it works with:
// Enable Translations
i18n::enable();
i18n::set_locale('nl_NL');
i18n::set_default_lang('nl');
For example on 'live' I get this error when I change set_default_lang() to nl_NL:
[User Error] Couldn't run query: SELECT `SiteTree_versions`.RecordID FROM `SiteTree_lang_versions` INNER JOIN `SiteTree_versions` ON `SiteTree_lang_versions`.OriginalLangID = `SiteTree_versions`.ID LEFT JOIN `Page_versions` ON `Page_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `GhostPage_versions` ON `GhostPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `Product_versions` ON `Product_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ArticlePage_versions` ON `ArticlePage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SchouwenPage_versions` ON `SchouwenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SleperPage_versions` ON `SleperPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `WachtschepenPage_versions` ON `WachtschepenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `UserDefinedForm_versions` ON `UserDefinedForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SubscribeForm_versions` ON `SubscribeForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID WHERE (`SiteTree_lang_versions`.Lang = 'nl') AND (`SiteTree_versions`.`WasPublished` = 1 AND `URLSegment` = 'home') ORDER BY `LastEdited` DESC, `SiteTree_versions`.`WasPublished` LIMIT 1 Column 'URLSegment' in where clause is ambiguous
GET /
Line 400 in /home/knr11075/domains/waterscouting.com/public_html/frontpage/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_versions`.RecordID FROM `SiteTree_lang_versions` INNER JOIN `SiteTree_versions` ON `SiteTree_lang_versions`.OriginalLangID = `SiteTree_versions`.ID LEFT JOIN `Page_versions` ON `Page_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `GhostPage_versions` ON `GhostPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `Product_versions` ON `Product_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ArticlePage_versions` ON `ArticlePage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SchouwenPage_versions` ON `SchouwenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SleperPage_versions` ON `SleperPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `WachtschepenPage_versions` ON `WachtschepenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `UserDefinedForm_versions` ON `UserDefinedForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SubscribeForm_versions` ON `SubscribeForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID WHERE (`SiteTree_lang_versions`.Lang = 'nl') AND (`SiteTree_versions`.`WasPublished` = 1 AND `URLSegment` = 'home') ORDER BY `LastEdited` DESC, `SiteTree_versions`.`WasPublished` LIMIT 1 Column 'URLSegment' in where clause is ambiguous
Line 400 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree_versions`.RecordID FROM `SiteTree_lang_versions` INNER JOIN `SiteTree_versions` ON `SiteTree_lang_versions`.OriginalLangID = `SiteTree_versions`.ID LEFT JOIN `Page_versions` ON `Page_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `GhostPage_versions` ON `GhostPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `Product_versions` ON `Product_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ArticlePage_versions` ON `ArticlePage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SchouwenPage_versions` ON `SchouwenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SleperPage_versions` ON `SleperPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `WachtschepenPage_versions` ON `WachtschepenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `UserDefinedForm_versions` ON `UserDefinedForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SubscribeForm_versions` ON `SubscribeForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID WHERE (`SiteTree_lang_versions`.Lang = 'nl') AND (`SiteTree_versions`.`WasPublished` = 1 AND `URLSegment` = 'home') ORDER BY `LastEdited` DESC, `SiteTree_versions`.`WasPublished` LIMIT 1 | Column 'URLSegment' in where clause is ambiguous,256)
Line 102 of MySQLDatabase.php
MySQLDatabase->query(SELECT `SiteTree_versions`.RecordID FROM `SiteTree_lang_versions` INNER JOIN `SiteTree_versions` ON `SiteTree_lang_versions`.OriginalLangID = `SiteTree_versions`.ID LEFT JOIN `Page_versions` ON `Page_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `GhostPage_versions` ON `GhostPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `Product_versions` ON `Product_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ArticlePage_versions` ON `ArticlePage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SchouwenPage_versions` ON `SchouwenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SleperPage_versions` ON `SleperPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `WachtschepenPage_versions` ON `WachtschepenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `UserDefinedForm_versions` ON `UserDefinedForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SubscribeForm_versions` ON `SubscribeForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID WHERE (`SiteTree_lang_versions`.Lang = 'nl') AND (`SiteTree_versions`.`WasPublished` = 1 AND `URLSegment` = 'home') ORDER BY `LastEdited` DESC, `SiteTree_versions`.`WasPublished` LIMIT 1,256)
Line 104 of DB.php
DB::query(SELECT `SiteTree_versions`.RecordID FROM `SiteTree_lang_versions` INNER JOIN `SiteTree_versions` ON `SiteTree_lang_versions`.OriginalLangID = `SiteTree_versions`.ID LEFT JOIN `Page_versions` ON `Page_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `GhostPage_versions` ON `GhostPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `Product_versions` ON `Product_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ArticlePage_versions` ON `ArticlePage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SchouwenPage_versions` ON `SchouwenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SleperPage_versions` ON `SleperPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `WachtschepenPage_versions` ON `WachtschepenPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `UserDefinedForm_versions` ON `UserDefinedForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID LEFT JOIN `SubscribeForm_versions` ON `SubscribeForm_versions`.ID = `SiteTree_lang_versions`.OriginalLangID WHERE (`SiteTree_lang_versions`.Lang = 'nl') AND (`SiteTree_versions`.`WasPublished` = 1 AND `URLSegment` = 'home') ORDER BY `LastEdited` DESC, `SiteTree_versions`.`WasPublished` LIMIT 1)
Line 426 of SQLQuery.php
SQLQuery->execute()
Line 106 of ModelAsController.php
ModelAsController->findOldPage(home)
Line 47 of ModelAsController.php
ModelAsController->getNestedController()
Line 25 of ModelAsController.php
ModelAsController->handleRequest(HTTPRequest)
Line 34 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