웹디벨로퍼 노트

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

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

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