1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PLEASE HELP! Magento store broken, after SQL server crash.

Discussion in 'General Scripting Chat' started by psychodelic2, Mar 31, 2014.

Tags:
  1. psychodelic2

    psychodelic2 Junior Member

    Joined:
    Sep 29, 2011
    Messages:
    157
    Likes Received:
    82
    Home Page:
    Hi
    Our hosting provider had a breakdown, now it is restored, but our magento is still dead. Please help if you can!!




    Code:
    There has been an error processing your request 
    
    
    SQLSTATE[HY000]: General error: 1015 Can?t lock file (errno: 165 - Table is read only)
    
    
    Trace: 
    #0 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Varien\Db\Statement\Pdo\My sql.php(110): Zend_Db_Statement_Pdo->_execute(Array) 
    #1 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Zend\Db\Statement.php(300) : Varien_Db_Statement_Pdo_Mysql->_execute(Array) 
    #2 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Zend\Db\Adapter\Abstract.p hp(479): Zend_Db_Statement->execute(Array) 
    #3 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Zend\Db\Adapter\Pdo\Abstra ct.php(238): Zend_Db_Adapter_Abstract->query(?INSERT INTO `lo...?, Array) 
    #4 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Varien\Db\Adapter\Pdo\Mysq l.php(419): Zend_Db_Adapter_Pdo_Abstract->query(?INSERT INTO `lo...?, Array) 
    #5 C:\HostingSpaces\SleepTech\x.com\wwwroot\lib\Zend\Db\Adapter\Abstract.p hp(574): Varien_Db_Adapter_Pdo_Mysql->query(?INSERT INTO `lo...?, Array) 
    #6 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Model\ Resource\Db\Abstract.php(453): Zend_Db_Adapter_Abstract->insert(?log_visitor?, Array) 
    #7 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Model\ Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor)) 
    #8 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Log\Model\V isitor.php(167): Mage_Core_Model_Abstract->save() 
    #9 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Model\ App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer)) 
    #10 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Model\ App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor ), ?initByRequest?, Object(Varien_Event_Observer)) 
    #11 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\Mage.php(447): Mage_Core_Model_App->dispatchEvent(?controller_acti...?, Array) 
    #12 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Contro ller\Varien\Action.php(528): Mage::dispatchEvent(?controller_acti...?, Array) 
    #13 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Contro ller\Front\Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch() 
    #14 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Contro ller\Varien\Action.php(408): Mage_Core_Controller_Front_Action->preDispatch() 
    #15 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Contro ller\Varien\Router\Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(?index?) 
    #16 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Contro ller\Varien\Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http) ) 
    #17 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\code\core\Mage\Core\Model\ App.php(354): Mage_Core_Controller_Varien_Front->dispatch() 
    #18 C:\HostingSpaces\SleepTech\x.com\wwwroot\app\Mage.php(683): Mage_Core_Model_App->run(Array) 
    #19 C:\HostingSpaces\SleepTech\x\wwwroot\index.php(87): Mage::run(??, ?store?) 
    #20 {main}
    


    Hosting provider is asking us to send them a database file to restore the database, we had taken a complete system back up a few days back, so I went var/backups and go the snapshot file. in the snapshot file there was a _db.tar.gz file, which extracted a _db file with no extension. I asked them to rename this _db file and try to restore, which didnt work. Any ideas what could actually be wrong here and how i can fix it.
     
  2. MrBlue

    MrBlue Senior Member

    Joined:
    Dec 18, 2009
    Messages:
    950
    Likes Received:
    662
    Occupation:
    Web/Bot Developer
    Have you tried running the Magento log & cache maintenance script found here:
    Code:
    http://www.crucialwebhost.com/kb/magneto-log-and-cache-maintenance-script/
     
    • Thanks Thanks x 1
  3. pxoxrxn

    pxoxrxn Supreme Member

    Joined:
    Dec 21, 2011
    Messages:
    1,397
    Likes Received:
    2,066
    I know this is no help to you but, didn't you read other people's reviews of Magento? if you had you would have stayed well away from it.
     
    • Thanks Thanks x 1
  4. MrBlue

    MrBlue Senior Member

    Joined:
    Dec 18, 2009
    Messages:
    950
    Likes Received:
    662
    Occupation:
    Web/Bot Developer
    Out of curiosity, what alternative do you recommend?

     
  5. pxoxrxn

    pxoxrxn Supreme Member

    Joined:
    Dec 21, 2011
    Messages:
    1,397
    Likes Received:
    2,066
    Anything but really. We have had success with Woocommerce, OpenCart and Dripal Commerce with Commerce Kickstart. Each has it's own disadvantages and advantages and what you use should be dependent on the type of store you're making.
     
  6. sommax

    sommax Junior Member

    Joined:
    Feb 11, 2012
    Messages:
    112
    Likes Received:
    27
    Occupation:
    Jackle of all Master of none...! Does that worth s
    Location:
    Nepal
    themefolder\app\etc\local.xml

    Delete local.xml.. Refresh the frontend and fresh installation will show up.. Install the theme using same database, username and pass.. And ther you go with your running up store again :D
     
    • Thanks Thanks x 1
  7. pentag0n

    pentag0n Newbie

    Joined:
    Oct 7, 2012
    Messages:
    25
    Likes Received:
    6
    Location:
    Las Vegas
    Let me help you with that. you will need to have your ssh ready (it is easier to perform commandline at console to quickly locate the error .eg. find ./ ) ftp also will do (slower, and no db access with ftp)

    PM me
     
    • Thanks Thanks x 1
  8. psychodelic2

    psychodelic2 Junior Member

    Joined:
    Sep 29, 2011
    Messages:
    157
    Likes Received:
    82
    Home Page:
    ah well.. we ended up creating the whole site again.. still sad about the 500 customer database we lost. recovering that through "order emails"
    thanks for ur support though! <3
     
  9. imwy2cool

    imwy2cool Newbie

    Joined:
    Oct 21, 2013
    Messages:
    13
    Likes Received:
    4
    Glad to see you got it working. Magento can work very well. I've used it for many clients, and most are very successful. But, you need someone who knows what they're doing. Make sure you are taking regular backups. And, you need a dedicated testing and staging environment. I suggest that you also use a hosting company that specializes in Magento.