Magento Forum

Upgrade from fresh 1.1.6 install on Myhosting.com - Error: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘mgscatalogindex_aggregation
 
NetWorX
Jr. Member
 
Total Posts:  3
Joined:  2008-11-05
 

Did fresh install using myhosting.com applic mgr that setup v 1.1.6 OK......
Then thought to upgrade to latest vers 1.2.0.1 .... using instructions provided http://www.magentocommerce.com/blog/comments/magento-version-120-is-now-available/ using “through the Magento Connect Manager” instructions…

a)I did Backup site via FTP & export MySQL tables via phpMyAdmin
b) Change ALL files/folder write permissions to “777”
b) Use MagentoConnect Manager Instructions....
i) Log into your Magento Connect Manager.
ii) Select the ‘Setting’ tab.
iii) Change the Preferred State to ‘Stable’, and save settings.
iv) For the Mage_All_Latest package select upgrade. ...did not see this so >>> did upgrade tarball installation instructions ... enter “magento-core/Mage_All_Latest in the extension key field & click install....

se attached for details of install which appeared?? OK.....
v) After upgrade is complete click on the ‘Refresh’ button. ...>>- Did click “Refresh” at end
vi)
- Try to Log into front page -
& back end admin -
...>>>gnerated errors SO did next reco step....
vii) Copy your original index.php and .htaccess files back (if needed) ...renamed new files & uploaded old

ones.....

viii) Log into your admin and rebuild search index .... >>>able to see front page & log into admin page

OK… said version 1.2.0.1 on pages..... But unable to find “rebuild search index” ....got to “system” &

changed default country to Canada (from United states) & additional countries to United states & saved

config.....error listing occured again......then following errors after when trying to access:

a) Frontend ( http://store.cleanol.com/shopping/index.php/ ):
There has been an error processing your request.

Error in file:

“/var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/CatalogIndex/sql/catalogindex_setup/my

sql4-upgrade-0.7.9-0.7.10.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table

‘mgscatalogindex_aggregation’ already exists
Trace:
#0 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Resource/Setup.php(287):

Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Resource/Setup.php(179):

Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.7.9’, ‘0.7.10’)
#2 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Resource/Setup.php(146):

Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.7.9’, ‘0.7.10’)
#3 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Resource/Setup.php(121):

Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Config.php(215):

Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/App.php(241):

Mage_Core_Model_Config->init(Array)
#6 /var/www/domains/store.cleanol.com/docs/shopping/app/Mage.php(427): Mage_Core_Model_App->init(’’,

‘store’, Array)
#7 /var/www/domains/store.cleanol.com/docs/shopping/app/Mage.php(446): Mage::app(’’, ‘store’, Array)
#8 /var/www/domains/store.cleanol.com/docs/shopping/index.php(52): Mage::run()
#9 {main}

b) Backend: (try to log into admin >> http://store.cleanol.com/shopping/index.php/madmin/) - generated same errors

Then tried access to MagentoConnect Manager (...shopping/downloader/ )…
- See Errors2-ConnectMagr.txt…

Help Please!
As no data yet should I have all blown away & do myhosting.com Application install back to vers 1.1.6?
What is next best STABLE version to install?? or try to upgrade to??

File Attachments
Events&Errors(01-09-2009)a.txt  (File Size: 24KB - Downloads: 529)
 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

open up /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/CatalogIndex/sql/catalogindex_setup/mysql4-upgrade-0.7.9-0.7.10.php

uncomment the line that tries to create the table and refresh your page

repeat if necessary with other files

 
Magento Community Magento Community
Magento Community
Magento Community
 
NetWorX
Jr. Member
 
Total Posts:  3
Joined:  2008-11-05
 
SimpleHelix.com - 10 January 2009 01:36 PM

open up /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/CatalogIndex/sql/catalogindex_setup/mysql4-upgrade-0.7.9-0.7.10.php

uncomment the line that tries to create the table and refresh your page

repeat if necessary with other files

Thanks this worked (after “commenting out” ALL 3 “create” table instances ...which already existed)....Able to can log
into Admin Panel OK, BUT when accessing ConnectMgr now (or manage extensions) get the following error (NOTE: Connect Manager worked prior for upgrade to 1.2.0.1) :

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/domains/store.cleanol.com/docs/shopping/downloader/pearlib/php/System.php:459) in /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Session/Abstract/Varien.php on line 95
Trace:
#0 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Session/Abstract/Varien.php(95): mageCoreErrorHandler(2, ‘session_start()...’, ‘/var/www/domain...’, 95, Array)
#1 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Session/Abstract/Varien.php(129): Mage_Core_Model_Session_Abstract_Varien->start()
#2 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Session/Abstract.php(53): Mage_Core_Model_Session_Abstract_Varien->init(’adminhtml’)
#3 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Session.php(39): Mage_Core_Model_Session_Abstract->init(’core’, ‘adminhtml’)
#4 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Model/Config.php(790): Mage_Core_Model_Session->__construct(’core’, ‘adminhtml’)
#5 /var/www/domains/store.cleanol.com/docs/shopping/app/Mage.php(317): Mage_Core_Model_Config->getModelInstance(Array)
#6 /var/www/domains/store.cleanol.com/docs/shopping/app/Mage.php(331): Mage::getModel(’core/session’, Array)
#7 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Controller/Varien/Action.php(379): Mage::getSingleton(’core/session’, Array)
#8 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Adminhtml/Controller/Action.php(131): Mage_Core_Controller_Varien_Action->preDispatch(’core/session’, Array)
#9 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Controller/Varien/Action.php(341): Mage_Adminhtml_Controller_Action->preDispatch()
#10 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(143): Mage_Core_Controller_Varien_Action->dispatch()
#11 /var/www/domains/store.cleanol.com/docs/shopping/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Admin->match(’index’)
#12 /var/www/domains/store.cleanol.com/docs/shopping/app/Mage.php(450): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#13 /var/www/domains/store.cleanol.com/docs/shopping/index.php(52): Mage::run()
#14 {main}

Please Assist / Help...Thanks in advance!

File Attachments
Events&Errors(01-10-2009)a.txt  (File Size: 3KB - Downloads: 240)
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top