Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Website down, can’t login to admin side
 
chcholman
Jr. Member
 
Total Posts:  3
Joined:  2008-04-07
 

After trying install the Direct Image Resize module, I received this error on the front end:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key 1
Trace:
#0 /home/mygrowin/public_html/mgttest5/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/mygrowin/public_html/mgttest5/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/mygrowin/public_html/mgttest5/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#3 /home/mygrowin/public_html/mgttest5/lib/Varien/Db/Adapter/Pdo/Mysql.php(199): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /home/mygrowin/public_html/mgttest5/lib/Zend/Db/Adapter/Abstract.php(484): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#5 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(349): Zend_Db_Adapter_Abstract->insert(’log_visitor’, Array)
#6 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Model/Abstract.php(241): Mage_Core_Model_Mysql4_Abstract->save(Object(Mage_Log_Model_Visitor))
#7 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Log/Model/Visitor.php(157): Mage_Core_Model_Abstract->save()
#8 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Model/App.php(1103): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#9 /home/mygrowin/public_html/mgttest5/app/Mage.php(298): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#10 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Controller/Varien/Action.php(391): Mage::dispatchEvent(’controller_acti...’, Array)
#11 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Controller/Front/Action.php(46): Mage_Core_Controller_Varien_Action->preDispatch()
#12 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Core_Controller_Front_Action->preDispatch()
#13 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#14 /home/mygrowin/public_html/mgttest5/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#15 /home/mygrowin/public_html/mgttest5/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch()
#16 /home/mygrowin/public_html/mgttest5/index.php(52): Mage::run()
#17 {main}

The Magento install is still in staging, but the error can be seen live here:

http://www.mygrowingtraditions.com/mgttest5/

Initially I was able to continue working on the admin side, but am now entirely blocked out - I receive “Access Denied.” messages when I try (despite repeatedly resetting the password. I followed several threads to remove the extra users down to just the admin, in hopes that that might solve it - no luck. I’ve tried reuploading the files - no luck. I’ve also tried installing a new copy of Magento and restoring the old database into the new one—I get SQL errors that say this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘“api_assert" (
“assert_id” int(10) unsigned NOT NULL,
“assert_type” varchar(’ at line 1

I’m looking for either a way to restore the original site, or else upload the many hundreds of products that have been entered into the database, and 100+ customers into a clean install. ANY help would be greatly appreciated - thanks in advance!
-cait

 
Magento Community Magento Community
Magento Community
Magento Community
 
chcholman
Jr. Member
 
Total Posts:  3
Joined:  2008-04-07
 

Any ideas guys?

 
Magento Community Magento Community
Magento Community
Magento Community
 
arthur_scholten
Jr. Member
 
Total Posts:  19
Joined:  2013-01-28
 

Disable compilation?
remove cash?
try to login in magentoconnect and uninstall?
just guessing.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top