- Chris Nudd
Total Posts: 28
About three weeks ago, I tried deleting a store and have had nothing but dead ends. I keep trying to update thinking its going to help some of my issues, but the last one I did via simple scripts gave me this error:
Error in file: “/home1/posdirec/public_html/store/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘cataloginventory_stock_status’ already exists
#0 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/Resource/Setup.php(292): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/Resource/Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.7.4’, ‘0.7.5’)
#2 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/Resource/Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.7.4’, ‘0.7.5’)
#3 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/Config.php(214): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home1/posdirec/public_html/store/app/code/core/Mage/Core/Model/App.php(242): Mage_Core_Model_Config->init(Array)
#6 /home1/posdirec/public_html/store/app/Mage.php(432): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /home1/posdirec/public_html/store/app/Mage.php(453): Mage::app(’’, ‘store’, Array)
#8 /home1/posdirec/public_html/store/index.php(52): Mage::run(’’)
I tried updating via connect and things just get worse because I can’t downgrade easily.
I am currently running 1.2.2 according to connect but admin still says 22.214.171.124.
I have over 130 categories and 30,000 products, my site is up but I cannot change product visibility or use the layered navigation. I am fine with totally disabling the layered navigation to go live. I don’t know if it is the number of products or what, but trying to change attributes in admin is useless. I think I need to totally reindex, but can’t kill my layered navigation indices. I know there is a bug report for large product lists.
My immediate wish is to have my site reflect the status of my inventory. I did a sql query changing the visibility on 24,000 items to “Search” only and the 6,000 with photos to “Catalog, Search”. But everything is showing. I go to update attributes in admin and try changing everything to “nowhere” and everything still shows up. I have deleted caches, updated search indexes. I’m at a loss. I’m tired and need help.
www.posdirect.com/store is the magento site. I’ll be glad to give any info needed to help.