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

psychodelic2

Junior Member
Joined
Sep 29, 2011
Messages
157
Reaction score
87
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.
 
Have you tried running the Magento log & cache maintenance script found here:
Code:
http://www.crucialwebhost.com/kb/magneto-log-and-cache-maintenance-script/
 
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.
 
Out of curiosity, what alternative do you recommend?

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.
 
Out of curiosity, what alternative do you recommend?

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.
 
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
 
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
 
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
 
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.
 
Back
Top