웹디벨로퍼 노트

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

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

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 | 조회 694
ItaewonianJiyoung 2009.09.04 0 694
45
컴퓨터 시동부터 윈도우 부팅까지 나타나는 증상
ItaewonianJiyoung | 2009.09.04 | 추천 0 | 조회 684
ItaewonianJiyoung 2009.09.04 0 684
44
시스템 복원
ItaewonianJiyoung | 2009.09.04 | 추천 0 | 조회 623
ItaewonianJiyoung 2009.09.04 0 623
43
subdirectory installation htaccess 500 error
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 8873
ItaewonianJiyoung 2009.08.28 0 8873
42
마젠토 커넥트로 새 테마 다운받을 때 에러난 경우
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 16275
ItaewonianJiyoung 2009.08.28 0 16275
41
마젠토 위키
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 8008
ItaewonianJiyoung 2009.08.28 0 8008
40
cgi-bin ftp로 접근 못할때 직접 putty로 파일 업로드하기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 27357
ItaewonianJiyoung 2009.08.28 0 27357
39
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 9031
ItaewonianJiyoung 2009.08.28 0 9031
38
Error: Please check for sufficient write file permissions
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 8767
ItaewonianJiyoung 2009.08.28 0 8767
37
마젠토 디자인 변경
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 12427
ItaewonianJiyoung 2009.08.28 0 12427
36
로컬 호스트로 들어가서 데이터 베이스 생성하기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 48383
ItaewonianJiyoung 2009.08.28 0 48383
35
Magento template
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 6963
ItaewonianJiyoung 2009.08.28 0 6963
34
KOREAIDC lady PHP info file file commend
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 6872
ItaewonianJiyoung 2009.08.28 0 6872
33
특정 디렉토리 하위나 파일의 퍼미션 변경 find 파일찾기
ItaewonianJiyoung | 2009.08.28 | 추천 0 | 조회 56251
ItaewonianJiyoung 2009.08.28 0 56251
32
다중언어 해외 쇼핑몰 솔루션의 필수 기능?
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6115
ItaewonianJiyoung 2009.08.25 0 6115
31
extension SSH install via putty, permission 777 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 10904
ItaewonianJiyoung 2009.08.25 0 10904
30
Upgrading Magento Via SSH
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6656
ItaewonianJiyoung 2009.08.25 0 6656
29
리눅스 접속 및 테이블 생성 명령어 (2)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 87026
ItaewonianJiyoung 2009.08.25 0 87026
28
리눅스 압축 해제 명령어
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 8278
ItaewonianJiyoung 2009.08.25 0 8278
27
데이터베이스 생성하기 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 13676
ItaewonianJiyoung 2009.08.25 0 13676
26
리눅스 압축 명령어들 (1)
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 24364
ItaewonianJiyoung 2009.08.25 0 24364
25
my PHP admin 설치
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 8308
ItaewonianJiyoung 2009.08.25 0 8308
24
web install error
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 6328
ItaewonianJiyoung 2009.08.25 0 6328
23
magento install subdirectory
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 12679
ItaewonianJiyoung 2009.08.25 0 12679
22
su root
ItaewonianJiyoung | 2009.08.25 | 추천 0 | 조회 10833
ItaewonianJiyoung 2009.08.25 0 10833