Unknown column 'locale' in 'where clause'SELECT `id_lang` FROM `psmv_lang` WHERE `locale` = 'en' LIMIT 1
at line 769 in file classes/db/Db.php
764. if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
380. $this->result = $this->_query($sql);
381. }
382. }
383.
384. if (_PS_DEBUG_SQL_) {
385. $this->displayError($sql);
386. }
387.
388. return $this->result;
389. }
390.
Argument [0] SELECT `id_lang` FROM `psmv_lang` WHERE `locale` = 'en' LIMIT 1
658.
659. return $result;
660. }
661. }
662.
663. $this->result = $this->query($sql);
664. if (!$this->result) {
665. $result = false;
666. } else {
667. $result = $this->nextRow($this->result);
668. }
Argument [0] SELECT `id_lang` FROM `psmv_lang` WHERE `locale` = 'en' LIMIT 1
692. {
693. if ($sql instanceof DbQuery) {
694. $sql = $sql->build();
695. }
696.
697. if (!$result = $this->getRow($sql, $use_cache)) {
698. return false;
699. }
700.
701. return array_shift($result);
702. }
Argument [0] SELECT `id_lang` FROM `psmv_lang` WHERE `locale` = 'en' LIMIT 1 Argument [1] 1
739. */
740. public static function getIdByLocale($locale, $noCache = false)
741. {
742. $key = 'Language::getIdByLocale_' . $locale;
743. if ($noCache || !Cache::isStored($key)) {
744. $idLang = Db::getInstance()->getValue('SELECT `id_lang` FROM `' . _DB_PREFIX_ . 'lang` WHERE `locale` = \'' . pSQL(strtolower($locale)) . '\'');
745.
746. Cache::store($key, $idLang);
747.
748. return $idLang;
749. }
Argument [0] SELECT `id_lang` FROM `psmv_lang` WHERE `locale` = 'en'
104. /**
105. * {@inheritdoc}
106. */
107. public function getCurrencyByIsoCodeAndLocale($isoCode, $locale)
108. {
109. $idLang = Language::getIdByLocale($locale);
110.
111. return $this->getCurrencyByIsoCode($isoCode, $idLang);
112. }
113.
114. /**
Argument [0] en
86. throw new LocalizationException('First parameter must be an instance of ' . LocalizedCurrencyId::class);
87. }
88.
89. $localeCode = $currencyDataId->getLocaleCode();
90. $currencyCode = $currencyDataId->getCurrencyCode();
91. $currencyEntity = $this->dataProvider->getCurrencyByIsoCodeAndLocale($currencyCode, $localeCode);
92.
93. if (null === $currencyEntity) {
94. return null;
95. }
96.
Argument [0] USD Argument [1] en
85. *
86. * @throws DataLayerException
87. */
88. public function read($id)
89. {
90. $data = $this->doRead($id);
91.
92. // If nothing found, ask lower layer
93. if (null === $data) {
94. $data = $this->propagateRead($id);
95.
Argument [0]
PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId Object
(
[currencyCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => USD
[localeCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => en
)
145. * @throws DataLayerException
146. */
147. protected function propagateRead($field)
148. {
149. if (isset($this->lowerDataLayer)) {
150. return $this->lowerDataLayer->read($field);
151. }
152.
153. return null;
154. }
155.
Argument [0]
PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId Object
(
[currencyCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => USD
[localeCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => en
)
89. {
90. $data = $this->doRead($id);
91.
92. // If nothing found, ask lower layer
93. if (null === $data) {
94. $data = $this->propagateRead($id);
95.
96. // If nothing was found deeper, there is nothing more to do
97. if (null === $data) {
98. return null;
99. }
Argument [0]
PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId Object
(
[currencyCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => USD
[localeCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => en
)
62. /**
63. * {@inheritdoc}
64. */
65. public function getLocalizedCurrencyData(LocalizedCurrencyId $localizedCurrencyId)
66. {
67. return $this->topLayer->read($localizedCurrencyId);
68. }
69.
70. /**
71. * Is this currency available ?
72. * (an available currency is not deleted AND is active).
Argument [0]
PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId Object
(
[currencyCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => USD
[localeCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => en
)
105. */
106. private function formatCurrenciesData(array $currencyCodes, $localeCode)
107. {
108. $currenciesData = [];
109. foreach ($currencyCodes as $currencyCode) {
110. $currenciesData[] = $this->getLocalizedCurrencyData(new LocalizedCurrencyId($currencyCode, $localeCode));
111. }
112.
113. return $currenciesData;
114. }
115. }
Argument [0]
PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId Object
(
[currencyCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => USD
[localeCode:PrestaShop\PrestaShop\Core\Localization\Currency\LocalizedCurrencyId:private] => en
)
92. /**
93. * {@inheritdoc}
94. */
95. public function getAllInstalledCurrenciesData($localeCode)
96. {
97. return $this->formatCurrenciesData($this->installedDataLayer->getAllInstalledCurrencyIsoCodes(), $localeCode);
98. }
99.
100. /**
101. * @param array $currencyCodes
102. * @param string $localeCode
Argument [0]
Array
(
[0] => USD
)
Argument [1]
en
90. /**
91. * {@inheritdoc}
92. */
93. public function getAllInstalledCurrencies($localeCode)
94. {
95. return $this->formatCurrencies($this->dataSource->getAllInstalledCurrenciesData($localeCode));
96. }
97.
98. /**
99. * @param array $currenciesData
100. *
Argument [0] en
202. $cldrLocale = $this->cldrLocaleRepository->getLocale($localeCode);
203. if (null === $cldrLocale) {
204. throw new LocalizationException('CLDR locale not found for locale code "' . $localeCode . '"');
205. }
206.
207. $currencies = $this->currencyRepository->getAllInstalledCurrencies($localeCode);
208.
209. $priceSpecifications = new PriceSpecificationMap();
210. foreach ($currencies as $currency) {
211. // Build the spec
212. $thisPriceSpecification = (new SpecificationFactory())->buildPriceSpecification(
Argument [0] en
145. {
146. if (!isset($this->locales[$localeCode])) {
147. $this->locales[$localeCode] = new Locale(
148. $localeCode,
149. $this->getNumberSpecification($localeCode),
150. $this->getPriceSpecifications($localeCode),
151. new NumberFormatter($this->roundingMode, $this->numberingSystem)
152. );
153. }
154.
155. return $this->locales[$localeCode];
Argument [0] en
184. $this->container = $this->buildContainer();
185. }
186.
187. $localeRepo = $this->get(self::SERVICE_LOCALE_REPOSITORY);
188. $this->context->currentLocale = $localeRepo->getLocale(
189. $this->context->language->getLocale()
190. );
191. }
192.
193. /**
194. * Do the page treatment: process input, process AJAX, etc.
Argument [0] en
266. return;
267. }
268.
269. self::$initialized = true;
270.
271. parent::init();
272.
273. // enable Symfony error handler if debug mode enabled
274. $this->initDebugguer();
275.
276. // If current URL use SSL, set it true (used a lot for module redirect)
268. /**
269. * Starts the controller process (this method should not be overridden!).
270. */
271. public function run()
272. {
273. $this->init();
274. if ($this->checkAccess()) {
275. // setMedia MUST be called before postProcess
276. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
277. $this->setMedia();
278. }
510. if (isset($params_hook_action_dispatcher)) {
511. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
512. }
513.
514. // Running controller
515. $controller->run();
516.
517. // Execute hook dispatcher after
518. if (isset($params_hook_action_dispatcher)) {
519. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
520. }
23. * @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require dirname(__FILE__).'/config/config.inc.php';
28. Dispatcher::getInstance()->dispatch();