웹디벨로퍼 노트

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’

작성자
ItaewonianJiyoung
작성일
2009-08-28 20:40
조회
9006

Guys,

I need some help. I’m new with magento so please bare with me if my question sound silly. Anyway i just installed magento and rite after the installation i clicked view the front end and this error report came out:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’
Trace:
#0 /home/shinigami/public_html/lowyatonline.net/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/shinigami/public_html/lowyatonline.net/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/shinigami/public_html/lowyatonline.net/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#3 /home/shinigami/public_html/lowyatonline.net/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /home/shinigami/public_html/lowyatonline.net/lib/Zend/Db/Adapter/Abstract.php(535): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#5 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(142): Zend_Db_Adapter_Abstract->insert(’log_url’, Array)
#6 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Log/Model/Mysql4/Visitor.php(83): Mage_Log_Model_Mysql4_Visitor->_saveVisitorUrl(Object(Mage_Log_Model_Visitor))
#7 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(373): Mage_Log_Model_Mysql4_Visitor->_afterSave(Object(Mage_Log_Model_Visitor))
#8 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Model/Abstract.php(251): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#9 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Log/Model/Visitor.php(179): Mage_Core_Model_Abstract->save()
#10 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Model/App.php(1239): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#11 /home/shinigami/public_html/lowyatonline.net/app/Mage.php(303): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Controller/Varien/Action.php(483): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Controller/Front/Action.php(56): Mage_Core_Controller_Varien_Action->postDispatch()
#14 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Controller/Varien/Action.php(380): Mage_Core_Controller_Front_Action->postDispatch()
#15 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#16 /home/shinigami/public_html/lowyatonline.net/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /home/shinigami/public_html/lowyatonline.net/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#18 /home/shinigami/public_html/lowyatonline.net/index.php(65): Mage::run()
#19 {main}

Could anyone explain what error is this and how to solve this?

 
Magento Communityhttp://www.magentocommerce.com/img/forum_thread_corner_left.gif" width="9" /> Magento Communityhttp://www.magentocommerce.com/img/forum_row_corner_right.gif" width="9" />
Magento Communityhttp://www.magentocommerce.com/img/forum_thread_corner_left2.gif" width="9" />
Magento Communityhttp://www.magentocommerce.com/img/forum_row_corner_right2.gif" width="9" />

 

Crucial" target="_blank">http://www.magentocommerce.com/boards/member/4921/">Crucial

Guruhttp://www.magentocommerce.com/img/Guru_img.gif" width="16" />

 


 

What happens when you go back to your main domain again, does the error still come up? I get a similar (or same) error when doing fresh installs with sample data, and all it takes is going back to the main URL again to clear the error out.

전체 71
번호 제목 작성자 작성일 추천 조회
46
느려지는 컴퓨터 제 속도 내게 하는 법
ItaewonianJiyoung | 2009.09.04 | 추천 0 | 조회 664
ItaewonianJiyoung 2009.09.04 0 664
45
컴퓨터 시동부터 윈도우 부팅까지 나타나는 증상
ItaewonianJiyoung | 2009.09.04 | 추천 0 | 조회 657
ItaewonianJiyoung 2009.09.04 0 657
44
시스템 복원
ItaewonianJiyoung | 2009.09.04 | 추천 0 | 조회 602
ItaewonianJiyoung 2009.09.04 0 602
43
subdirectory installation htaccess 500 error
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 8851
ItaewonianJiyoung 2009.08.28 0 8851
42
마젠토 커넥트로 새 테마 다운받을 때 에러난 경우
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 16260
ItaewonianJiyoung 2009.08.28 0 16260
41
마젠토 위키
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 7991
ItaewonianJiyoung 2009.08.28 0 7991
40
cgi-bin ftp로 접근 못할때 직접 putty로 파일 업로드하기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 27333
ItaewonianJiyoung 2009.08.28 0 27333
39
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 9006
ItaewonianJiyoung 2009.08.28 0 9006
38
Error: Please check for sufficient write file permissions
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 8744
ItaewonianJiyoung 2009.08.28 0 8744
37
마젠토 디자인 변경
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 12409
ItaewonianJiyoung 2009.08.28 0 12409
36
로컬 호스트로 들어가서 데이터 베이스 생성하기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 48365
ItaewonianJiyoung 2009.08.28 0 48365
35
Magento template
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 6950
ItaewonianJiyoung 2009.08.28 0 6950
34
KOREAIDC lady PHP info file file commend
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 6857
ItaewonianJiyoung 2009.08.28 0 6857
33
특정 디렉토리 하위나 파일의 퍼미션 변경 find 파일찾기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 56228
ItaewonianJiyoung 2009.08.28 0 56228
32
다중언어 해외 쇼핑몰 솔루션의 필수 기능?
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6097
ItaewonianJiyoung 2009.08.25 0 6097
31
extension SSH install via putty, permission 777 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 10887
ItaewonianJiyoung 2009.08.25 0 10887
30
Upgrading Magento Via SSH
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6634
ItaewonianJiyoung 2009.08.25 0 6634
29
리눅스 접속 및 테이블 생성 명령어 (2)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 87007
ItaewonianJiyoung 2009.08.25 0 87007
28
리눅스 압축 해제 명령어
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 8263
ItaewonianJiyoung 2009.08.25 0 8263
27
데이터베이스 생성하기 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 13658
ItaewonianJiyoung 2009.08.25 0 13658
26
리눅스 압축 명령어들 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 24350
ItaewonianJiyoung 2009.08.25 0 24350
25
my PHP admin 설치
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 8289
ItaewonianJiyoung 2009.08.25 0 8289
24
web install error
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6309
ItaewonianJiyoung 2009.08.25 0 6309
23
magento install subdirectory
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 12667
ItaewonianJiyoung 2009.08.25 0 12667
22
su root
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 10820
ItaewonianJiyoung 2009.08.25 0 10820