Magento

Damn thats a long way around the problem, i have done two installs where that same problem happened.
All you need to do is create this table sales_quote with the following sql in phpmyadmin and it will install ok
copy and paste it to notepad first then into phpmyadmin - hope this gets you fixed it did for me

CREATE TABLE IF NOT EXISTS sales_quote (
entity_id int(10) unsigned NOT NULL auto_increment,
entity_type_id smallint(8) unsigned NOT NULL default ‘0’,
attribute_set_id smallint(5) unsigned NOT NULL default ‘0’,
parent_id int(10) unsigned NOT NULL default ‘0’,
store_id smallint(5) unsigned NOT NULL default ‘0’,
created_at datetime NOT NULL default ‘0000-00-00 00:00:00’,
updated_at datetime NOT NULL default ‘0000-00-00 00:00:00’,
converted_at datetime NOT NULL default ‘0000-00-00 00:00:00’,
is_active tinyint(1) unsigned default ‘1’,
is_virtual tinyint(1) unsigned default ‘0’,
is_multi_shipping tinyint(1) unsigned default ‘0’,
is_multi_payment tinyint(1) unsigned default ‘0’,
customer_note_notify tinyint(1) unsigned default ‘1’,
customer_is_guest tinyint(1) unsigned default ‘0’,
quote_status_id int(10) unsigned default ‘0’,
billing_address_id int(10) unsigned default ‘0’,
orig_order_id int(10) unsigned default ‘0’,
customer_id int(10) unsigned default ‘0’,
customer_tax_class_id int(10) unsigned default ‘0’,
customer_group_id int(10) unsigned default ‘0’,
items_count int(10) unsigned default ‘0’,
items_qty decimal(12,4) default ‘0.0000’,
store_to_base_rate decimal(12,4) default ‘0.0000’,
store_to_quote_rate decimal(12,4) default ‘0.0000’,
grand_total decimal(12,4) default ‘0.0000’,
base_grand_total decimal(12,4) default ‘0.0000’,
custbalance_amount decimal(12,4) default ‘0.0000’,
checkout_method varchar(255) default NULL,
password_hash varchar(255) default NULL,
coupon_code varchar(255) default NULL,
giftcert_code varchar(255) default NULL,
base_currency_code varchar(255) default NULL,
store_currency_code varchar(255) default NULL,
quote_currency_code varchar(255) default NULL,
customer_email varchar(255) default NULL,
customer_firstname varchar(255) default NULL,
customer_lastname varchar(255) default NULL,
customer_note varchar(255) default NULL,
remote_ip varchar(255) default NULL,
applied_rule_ids varchar(255) default NULL,
reserved_order_id varchar(64) default ‘’,
PRIMARY KEY (entity_id),
KEY FK_SALES_QUOTE_STORE (store_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

lindaw - 22 July 2008 07:32 PM

Hey Crucial,

Everything went well up to installation -

Front end had another table error (different one)
Backend was fine (with my data) but admin menus weren’t working (this happens every time and I know how to fix)

You may have already overwritten tables in your old database.  In which case, if you don’t have a backup database, you are probably screwed.

My method would be:
Get all old files off old working version of site, download to local.  Make sure you download and overwrite your local copy.  There will be new files on the server you didn’t upload.
Using phpmyadmin export old database, or hopefully you have backup copy.
Unwrap new (same version as old version) copy of magento in a differnent local folder.  point ftp at that as your local copy.
Create a new database.
Upload all new files to server.  set permissions.  connect to new clean database.  Install without sample data.
Now you should have a good clean working copy of magento, clean with nothing in it.  Default template, none of your stuff.  Check it.  Make sure it works.  If it doesn’t you’ve got server problems. 

Point your ftp program to your old magento directory as local.  Overwrite all files on server with your old files.

Go into phpmyadmin and delete all tables from the new database.  Import the old database.

This is all dependent on if you still have a good database.  Good luck.  This takes a lot of time.  I sympathize.

Well this just adds another problem as at first glance (before the server error) I was missing a new and different table!

My database is good as I was able to see all the products and everything in the backend before I changed poermissions and got the server error.

Ramedia- That’s pretty much what I just did with Crucial. It all went pear shaped when I changed permissions.

----

Shopenz - Would this work for any other table that I’m missing? I will be able to see what table it is as soon as I fix the server error. Does anyone have any ideas on that?

My index file is set to 644 which I thought was all I needed.

well you will need the correct sql to add the table for any that are missing.
I always have a duplicate db setup so you can copy the data and structure back if you mess it up
1st one is eg. mag1 and backup is mag2 and i use the operations menu in phpmyadmin to copy all data and structure and increments to the mag2 db

Did you try adding the table structure that i posted above?
Whats missing after you have done that.

Have you only got products added to the db or have you got cutomers and orders as well .
What version was the install you added all the data to?

cheers
Paul

Hey thanks Paul -

I’m getting the Hosting company to fix the server error and then I will have all those answers. Please come back and check!!

Your questions -

1. I’m missing a different table now and will update you

2. I only have products so far

3. the version is the latest stable version - 4

Ok got the site back up and here is my error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘catalog_category_entity.is_active’ 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(Object(Varien_Db_Select), Array)
#3 /home/spoiltro/public_html/lib/Zend/Db/Adapter/Abstract.php(711): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/spoiltro/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php(134): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select))
#5 /home/spoiltro/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php(117): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Tree->_getItemIsActive(’3’)
#6 /home/spoiltro/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php(92): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Tree->_getDisabledIds(Object(Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Collection))
#7 /home/spoiltro/public_html/app/code/core/Mage/Catalog/Helper/Category.php(60): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Tree->addCollectionData(NULL, false, ‘2’, true, true)
#8 /home/spoiltro/public_html/app/code/core/Mage/Catalog/Block/Navigation.php(58): Mage_Catalog_Helper_Category->getStoreCategories()
#9 /home/spoiltro/public_html/app/design/frontend/default/default/template/catalog/navigation/top.phtml(32): Mage_Catalog_Block_Navigation->getStoreCategories()
#10 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(131): include(’/home/spoiltro/...’)
#11 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#12 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#13 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#14 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Text/List.php(37): Mage_Core_Block_Abstract->toHtml()
#15 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Text_List->_toHtml()
#16 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#17 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml(’topMenu’, true)
#18 /home/spoiltro/public_html/app/design/frontend/default/default/template/page/html/header.phtml(39): Mage_Core_Block_Abstract->getChildHtml(’topMenu’)
#19 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(131): include(’/home/spoiltro/...’)
#20 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#21 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#22 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#23 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#24 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml(’header’, true)
#25 /home/spoiltro/public_html/app/design/frontend/default/default/template/page/3columns.phtml(36): Mage_Core_Block_Abstract->getChildHtml(’header’)
#26 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(131): include(’/home/spoiltro/...’)
#27 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#28 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#29 /home/spoiltro/public_html/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#30 /home/spoiltro/public_html/app/code/core/Mage/Core/Model/Layout.php(505): Mage_Core_Block_Abstract->toHtml()
#31 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(319): Mage_Core_Model_Layout->getOutput()
#32 /home/spoiltro/public_html/app/code/core/Mage/Cms/Helper/Page.php(77): Mage_Core_Controller_Varien_Action->renderLayout()
#33 /home/spoiltro/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(26): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#34 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Cms_IndexController->indexAction()
#35 /home/spoiltro/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#36 /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))
#37 /home/spoiltro/public_html/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#38 /home/spoiltro/public_html/index.php(46): Mage::run()
#39 {main}

lindaw , is this your shop, if it is i see a home page now but no products or categories
http://www.spoiltrottenpets.com.au/index.php/

I’m in the middle of re-installing for the 10th time… the message above you is what i will get when i import my own database. do you know what that means?

I’m about to give up.

LOL dont give up.  calm down and work through it slowly and think things through .

Did you do an export of all your products from the old store, if you can maybe do that and then import them into the new install

You know Paul - I just want to do it right the first time (for the 1oth time!)… Argh…

How do I export my products, categories, images, prices etc?

Well hopefully you have the old installed version still in a working condition, so you can export them.
use admin>>system>>import/export>>profiles>>export all products

use file manager in cpanel to move or copy your images or zip all your local copies up ,
upload and unzip in the media\import folder before you import all products xml sheet
I found the best results for importing all products was to use an excel 2003 xml saved sheet.

If anyone else has a better solution for lindaw please let her know

Hey Paul,

Thanks.

I did all of that and the shop is up in a format I’’m happy with but I can’t get the products in. When I upload them it says there all missing things which I don’t how how is possible given I merely exported and then tried to import into a new DB.

Does it not import all of the attribute sets or anything?

Is there any other way to get the products in with attributes and all?

I just realised that I also had all of the pages done which took many many hours so I really want to use the existing DB.

This is the error I get when I run the installer to connect to it:

I tried pasting yuor SQL statement but it says there’s an error. Can you see it?

This is the error:

Ok, I fixed that one by getting the SQL from a new DB I had installed but now I get a front end with this:

This is where all my categories are so obviously I’m reluctant to overwrite it with the other SQL.

Does anyone know what this means?

Ok, so my old DB was missing a column in catalog_category_entity

So I went in there and created:

is_active
tinyint (1)
unsigned
default = 1

And now I have products and no errors so far. Will post back any other issues.