Pāriet uz galveno saturu

Duplicate entry '158907bf4554373a530ed160c85ae21b-lv' for key 'swcrt_linguise_urls.hash_translation' (500 Whoops, looks like something went wrong.)

mysqli_sql_exception

HTTP 500 Whoops, looks like something went wrong.

Duplicate entry '158907bf4554373a530ed160c85ae21b-lv' for key 'swcrt_linguise_urls.hash_translation'

Exception

mysqli_sql_exception

Show exception properties

mysqli_sql_exception {#563
  #sqlstate: "23000"
}

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Databases/Mysql.php (line 205)

foreach ($urls as $translation => $source) {
$elements[] = '("'.mysqli_real_escape_string($this->_database, Request::getInstance()->getLanguage()).'", "'.mysqli_real_escape_string($this->_database, $source).'", "'.mysqli_real_escape_string($this->_database, $translation).'", "'.md5($source).'", "'.md5($translation).'")';
}
$query .= implode(',', $elements);
$query .= ' ON DUPLICATE KEY UPDATE source=VALUES(source), translation=VALUES(translation), hash_source=VALUES(hash_source), hash_translation=VALUES(hash_translation)';
$this->_database->query($query);
}
public function removeUrls($urls)
{
$this->reconnectIfNeeded();

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Databases/Mysql.php -> query (line 205)

foreach ($urls as $translation => $source) {
$elements[] = '("'.mysqli_real_escape_string($this->_database, Request::getInstance()->getLanguage()).'", "'.mysqli_real_escape_string($this->_database, $source).'", "'.mysqli_real_escape_string($this->_database, $translation).'", "'.md5($source).'", "'.md5($translation).'")';
}
$query .= implode(',', $elements);
$query .= ' ON DUPLICATE KEY UPDATE source=VALUES(source), translation=VALUES(translation), hash_source=VALUES(hash_source), hash_translation=VALUES(hash_translation)';
$this->_database->query($query);
}
public function removeUrls($urls)
{
$this->reconnectIfNeeded();

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Database.php -> saveUrls (line 232)

public function saveUrls($urls) {
if (empty($urls)) {
return;
}
return $this->_database->saveUrls($urls);
}
public function removeUrls($urls) {
if (empty($urls)) {
return;

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Translation.php -> saveUrls (line 119)

if (isset($result->url_translations)) {
Defer::getInstance()->defer(function() use ($result) {
$new_urls = $result->url_translations;
$new_urls = get_object_vars($new_urls);
Database::getInstance()->saveUrls((array)$new_urls);
});
}
if (isset($result->urls_untranslated)) {
Defer::getInstance()->defer(function() use ($result) {

Translation->Linguise\Script\Core\{closure}()

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Defer.php call_user_func (line 42)

}
public function finalize()
{
foreach ($this->_actions as $action) {
call_user_func($action['function'], $action['args']);
}
}
}

in /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Processor.php -> finalize (line 31)

Helper::prepareDataDir();
// Finalize defer actions on shutdown
// @codeCoverageIgnoreStart
register_shutdown_function(function() {
Defer::getInstance()->finalize();
Database::getInstance()->close();
});
// @codeCoverageIgnoreEnd
}

Processor->Linguise\Script\Core\{closure}()

Stack Trace

mysqli_sql_exception

mysqli_sql_exception:
Duplicate entry '158907bf4554373a530ed160c85ae21b-lv' for key 'swcrt_linguise_urls.hash_translation'

  at /web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Databases/Mysql.php:205
  at mysqli->query()
     (/web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Databases/Mysql.php:205)
  at Linguise\Script\Core\Databases\Mysql->saveUrls()
     (/web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Database.php:232)
  at Linguise\Script\Core\Database->saveUrls()
     (/web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Translation.php:119)
  at Linguise\Script\Core\Translation->Linguise\Script\Core\{closure}()
  at call_user_func()
     (/web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Defer.php:42)
  at Linguise\Script\Core\Defer->finalize()
     (/web/htdocs/www.linfagreen.com/home/plugins/system/linguise/vendor/linguise/script-php/src/Processor.php:31)
  at Linguise\Script\Core\Processor->Linguise\Script\Core\{closure}()