{"id":828,"date":"2015-05-26T12:54:06","date_gmt":"2015-05-26T15:54:06","guid":{"rendered":"https:\/\/www.kinghost.com.br\/wiki\/?post_type=article&p=828"},"modified":"2021-06-16T13:41:59","modified_gmt":"2021-06-16T16:41:59","slug":"integrity-constraint-violation","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/integrity-constraint-violation\/","title":{"rendered":"Integrity constraint violation"},"content":{"rendered":"\n

Ao acessar o site aparece o erro Integrity constraint violation?
\nEssa dificuldade acontece pois h\u00e1 uma chave duplicada na tabela log_visitor_info<\/strong> do banco de dados Magento.<\/p>\n\n\n\n

O Magento \u00e9 uma solu\u00e7\u00e3o robusta e completa para lojas virtuais. Trata-se de um CMS exclusivo para e-commerce e que pode ser utilizado gratuitamente em sua hospedagem. Assim como a maioria dos CMSs presentes no mercado, trabalha com PHP e MySQL. \u00c9 desenvolvido e mantido pelo Magento Inc, atualmente uma divis\u00e3o do Ebay. Possui tr\u00eas vers\u00f5es: Enterprise Edition (vers\u00e3o paga com suporte especializado), Magento Go (aplica\u00e7\u00e3o em Cloud) e Community Edition (vers\u00e3o gratuita e a mais utilizada).<\/em><\/p>\n\n\n\n

<\/span>Mensagem de erro completa<\/span><\/h2>\n\n\n\nThere has been an error processing your request
SQLSTATE[23000]: Integrity constraint violation: 1062 Entrada ‘281’ duplicada para a chave ‘PRIMARY’

Trace:
0 \/home\/pro-directo\/www\/lib\/Zend\/Db\/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
1 \/home\/pro-directo\/www\/lib\/Zend\/Db\/Adapter\/Abstract.php(468): Zend_Db_Statement->execute(Array)
2 \/home\/pro-directo\/www\/lib\/Zend\/Db\/Adapter\/Pdo\/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `lo\u2026’, Array)
3 \/home\/pro-directo\/www\/lib\/Varien\/Db\/Adapter\/Pdo\/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `lo\u2026’, Array)
4 \/home\/pro-directo\/www\/lib\/Zend\/Db\/Adapter\/Abstract.php(546): Varien_Db_Adapter_Pdo_Mysql->query(‘INSERT INTO `lo\u2026’, Array)
5 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Log\/Model\/Mysql4\/Visitor.php(125): Zend_Db_Adapter_Abstract->insert(‘log_visitor_inf\u2026’, Array)
6 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Log\/Model\/Mysql4\/Visitor.php(79): Mage_Log_Model_Mysql4_Visitor->_saveVisitorInfo(Object(Mage_Log_Model_Visitor))
7 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Model\/Mysql4\/Abstract.php(422): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
8 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Model\/Abstract.php(306): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
9 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Log\/Model\/Visitor.php(149): Mage_Core_Model_Abstract->save()
10 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Model\/App.php(1228): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
11 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Model\/App.php(1209): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), ‘initByRequest’, Object(Varien_Event_Observer))
12 \/home\/pro-directo\/www\/app\/Mage.php(416): Mage_Core_Model_App->dispatchEvent(‘controller_acti\u2026’, Array)
13 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Controller\/Varien\/Action.php(497): Mage::dispatchEvent(‘controller_acti\u2026’, Array)
14 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Controller\/Front\/Action.php(59): Mage_Core_Controller_Varien_Action->preDispatch()
15 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Controller\/Varien\/Action.php(407): Mage_Core_Controller_Front_Action->preDispatch()
16 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Controller\/Varien\/Router\/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
17 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Controller\/Varien\/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
18 \/home\/pro-directo\/www\/app\/code\/core\/Mage\/Core\/Model\/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
19 \/home\/pro-directo\/www\/app\/Mage.php(596): Mage_Core_Model_App->run(Array)
20 \/home\/pro-directo\/www\/index.php(80): Mage::run(”, ‘store’)
21 {main}<\/box-info>\n\n\n\n

<\/p>\n\n\n\n


<\/p>\n\n\n\n

<\/span>Solucionar erro Integrity constraint violation<\/span><\/h2>\n\n\n\n

Basta renomear a tabela log_visitor_info<\/strong> para log_visitor_info2<\/strong> e recri\u00e1-la no banco com o seguinte c\u00f3digo:\n<\/p>\n\n\n\n

CREATE TABLE IF NOT EXISTS `log_visitor_info` (\n  `visitor_id` bigint(20) unsigned NOT NULL DEFAULT '0',\n  `http_referer` varchar(255) DEFAULT NULL,\n  `http_user_agent` varchar(255) DEFAULT NULL,\n  `http_accept_charset` varchar(255) DEFAULT NULL,\n  `http_accept_language` varchar(255) DEFAULT NULL,\n  `server_addr` bigint(20) DEFAULT NULL,\n  `remote_addr` bigint(20) DEFAULT NULL,\n  PRIMARY KEY (`visitor_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Additional information by visitor';\n<\/pre>\n\n\n\n
Para mais artigos sobre Magento, acesse: Central de Ajuda KingHost – Plataformas CMS<\/a>.<\/box-info><\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":27,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/828"}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=828"}],"version-history":[{"count":2,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/828\/revisions"}],"predecessor-version":[{"id":7339,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/828\/revisions\/7339"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=828"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=828"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}