Magento

excellent , looks like your doing great now

Thanks Paul… Still a couple of tables missing though… Got 3 of them, can you tell me what this one means? I can’t find it:

I get this after I try to add to the cart. That’s where I’ve gotten all of them and most tell me where the table is and I just copy the SQL from the newer DB but this one I can’t find.

Any ideas?

Thanks,

I just did a search (duh!) and found it in eav_attribute in the OLD DB but it doesn’t exist in the new one so not sure how to handle it.

customer_dob will be customer date of birth , i will take a look and see what table its in

How bizarre.... This was supposed to paste AFTER your post. 

Thanks,

I just did a search (duh!) and found it in eav_attribute in the OLD DB but it doesn’t exist in the new one so not sure how to handle it.

take a back up of that table and then delete that row out and see if it works

your missing this table as well sales_quote_int

when you add something to the cart its showing that missing

Thanks so much Paul - Wow, I think we’re done!

Bit worried about the hacky database (I now have 1 table more than the newer install and can only assume that I have tables I don’t need and some may still be missing) but I guess I can’t figure out why MAgento didn’t update my DB properly the first time I upgraded.

Bit of a worry and I guess I made an error somewhere along the way but right now all I’m focused on is getting the whole thing working. I don’t think I will ever upgrade though.

Thanks to everyone for helping me throughout.

there is a bunch of sales quote tables in one of the installs i did and this one is still missing from yours , sales_quote_entity_text
add something to the cart and see what happens and also then go to home page and look in your cart

Thanks Paul. Got that one too now. At least now I’ll know how to fix it should another one be spotted.

Thanks for all your help.

Is there anyway I can get a summary of what you did?
I am getting a similar error. I do not have SSH access, but it does not look like you went through with Crucials initial way.

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento3.sales_quote’ doesn’t exist

#0 /home/content/k/i/n/kingkao/html/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/content/k/i/n/kingkao/html/magento/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/content/k/i/n/kingkao/html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/content/k/i/n/kingkao/html/magento/lib/Zend/Db/Adapter/Abstract.php(636): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Checkout/Model/Mysql4/Cart.php(58): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#5 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Checkout/Model/Cart.php(546): Mage_Checkout_Model_Mysql4_Cart->fetchItemsSummary(NULL)
#6 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Checkout/Helper/Cart.php(127): Mage_Checkout_Model_Cart->getSummaryQty()
#7 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Checkout/Block/Links.php(33): Mage_Checkout_Helper_Cart->getSummaryCount()
#8 [internal function]: Mage_Checkout_Block_Links->addCartLink()
#9 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Layout.php(319): call_user_func_array(Array, Array)
#10 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Layout.php(195): Mage_Core_Model_Layout->_generateAction(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#11 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Layout.php(187): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#12 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Layout.php(191): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#13 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(278): Mage_Core_Model_Layout->generateBlocks()
#14 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Cms/Helper/Page.php(76): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#15 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#16 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Cms_IndexController->indexAction()
#17 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#18 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /home/content/k/i/n/kingkao/html/magento/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/content/k/i/n/kingkao/html/magento/index.php(46): Mage::run()
#21 {main}

I did go through Crucial’s way and it was just part of the process. You are missing a table in your DB: sales_quote

In fact, you’re probably missing quite a fwe.

Can you make another (2nd) install with a new, clean DB and take the missing tables from there? That is essentially what I did.

I installed magento on a new database then imported old tables in.
I am getting this error, would appreciate some help

Notice: Undefined index:  0 in /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Mysql4/Config.php on line 86

#0 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Mysql4/Config.php(86): mageCoreErrorHandler(8, ‘Undefined index...’, ‘/home/content/k...’, 86, Array)
#1 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/Config.php(214): Mage_Core_Model_Mysql4_Config->loadToXml(Object(Mage_Core_Model_Config))
#2 /home/content/k/i/n/kingkao/html/magento/app/code/core/Mage/Core/Model/App.php(230): Mage_Core_Model_Config->init(Array)
#3 /home/content/k/i/n/kingkao/html/magento/app/Mage.php(397): Mage_Core_Model_App->init(’’, ‘store’, Array)
#4 /home/content/k/i/n/kingkao/html/magento/app/Mage.php(416): Mage::app(’’, ‘store’, Array)
#5 /home/content/k/i/n/kingkao/html/magento/index.php(46): Mage::run()
#6 {main}

lindaw - 23 July 2008 06:47 PM

Thanks Paul… Still a couple of tables missing though… Got 3 of them, can you tell me what this one means? I can’t find it:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'customer_dob' in 'field list'

#0 /home/spoiltro/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/spoiltro/public_html/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/spoiltro/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query('INSERT INTO `sa...', Array)
#3 /home/spoiltro/public_html/lib/Zend/Db/Adapter/Abstract.php(484): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `sa...', Array)
#4 /home/spoiltro/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1018): Zend_Db_Adapter_Abstract->insert('sales_quote', Array)
#5 /home/spoiltro/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(848): Mage_Eav_Model_Entity_Abstract->_processSaveData(Array)
#6 /home/spoiltro/public_html/app/code/core/Mage/Core/Model/Abstract.php(235): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote))
#7 /home/spoiltro/public_html/app/code/core/Mage/Checkout/Model/Cart.php(396): Mage_Core_Model_Abstract->save()
#8 /home/spoiltro/public_html/app/code/core/Mage/Checkout/controllers/CartController.php(71): Mage_Checkout_Model_Cart->save()
#9 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Checkout_CartController->indexAction()
#10 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch('index')
#11 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#12 /home/spoiltro/public_html/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#13 /home/spoiltro/public_html/index.php(46): Mage::run()
#14 {main}

I get this after I try to add to the cart. That’s where I’ve gotten all of them and most tell me where the table is and I just copy the SQL from the newer DB but this one I can’t find.

Any ideas?

Hi, Im going quietly insane ... I went to upgrade from 1.0.19870.4 to1.1.1 Jesus what a mistake that was… Im going back to 1.0.19870.4. It worked fine. BUT!.... I have everything s back, accept this annoying customer_dod. Ive tried everything. Its not in eav .... If I can get the settings i can put back the field ,manually, where it belongs or docent. Ive read this post and I cant find customer_dob in eav or anywhere. Do I need to put it back?  Can some kind soul help me get back. Sites running fine until I click add to cart!.
Thanks again

Hey, I did a search for “customer_dob” in phpmyadmin, found 2 and deleted them. Mistake? Possibly but it fixed the issue.

Hey..

I’m looking for a little wisdom here.  I followed Crucial’s way to transfer over a site from one URL to another.  Both sites are on the crucial servers.  I think I followed the instructions however I won’t shout about it yet as someone could easily tell me otherwise.

Anyway, having thought i was successful, I now see the old site being displayed with the urls coming up as the new site.

Old url: http://www.mikeyoung.eu
New url: http://www.capitalhairandbeautyspain.com/store/

When I look inside the folder for the old url, it is empty yet still displaying a site.  I am utterly utterly confused and completely stuck.  I’m willing to give pretty much anything a shot.  The only thing I need to keep from the database is the categories!

Hope someone can help, soonish…