Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Problems revering to 1.8 from 2.0
 
aloeroot
Jr. Member
 
Total Posts:  18
Joined:  2008-07-24
 

Hi folks - I made backups of my install before upgrading to 2.0 via Magento Connect. After the upgrade I had 500 errors on every page in the store, so I restored the shop and the mysql database using my restore program, and now I have the following error on every page:

PDOException Object
(
[message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘databasename.catalog_product’ doesn’t exist

Any ideas? This process should have just reverted my store to its previous state.

 
Magento Community Magento Community
Magento Community
Magento Community
 
turbo1
Sr. Member
 
Avatar
Total Posts:  296
Joined:  2008-08-19
Los Angeles, CA
 

ahh. welcome to the 1.2 hell smile Same thing happened to me.  In my case it was a rogue folder under \app\code\core\mage called “downloader” - once I removed that, all was well. I hope this helps..

 
Magento Community Magento Community
Magento Community
Magento Community
 
aloeroot
Jr. Member
 
Total Posts:  18
Joined:  2008-07-24
 

Thank you SO much. For whatever reason, that folder was called Downloadable in my install, but renaming it resurrected my shop. Thanks again.

 
Magento Community Magento Community
Magento Community
Magento Community
 
turbo1
Sr. Member
 
Avatar
Total Posts:  296
Joined:  2008-08-19
Los Angeles, CA
 

You’re very welcome cheese

 
Magento Community Magento Community
Magento Community
Magento Community
 
Danielc1234
Sr. Member
 
Avatar
Total Posts:  175
Joined:  2008-01-09
Miami, FL - United States
 

I am having the exact error, but when I deleted the suggested folder, it still does not work.
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘silkflowersplants.catalogindex_aggregation’ doesn’t exist

Still messing up.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Danielc1234
Sr. Member
 
Avatar
Total Posts:  175
Joined:  2008-01-09
Miami, FL - United States
 

Still having the same problem...any ideas yet?

 
Magento Community Magento Community
Magento Community
Magento Community
 
benzvibes
Jr. Member
 
Total Posts:  24
Joined:  2009-01-12
 

I have the same issue.. I upgraded from 1.1.8 to 1.2.0

That didn’t work so I went back to 1.1.8

Now I have this same issue.

SQLSTATE[42S02]Base table or view not found1146 Table

Strange part is it’s intermittent.. it comes and goes.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Jestore
Member
 
Avatar
Total Posts:  31
Joined:  2008-08-24
UK
 

I am getting a similar issue after upgrading from v1.1.8 to v1.2.

I am now getting :-

PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘catalogindex_aggregation’ already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /home/bigi/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 207
[trace:private] => Array
(
[0] => Array
(
[file] => /home/bigi/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 207
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(

anyone got any ideas of what i should do?..

Its a real nightmare for me as I have invested alot of time and money in building up the DB in this store.

 
Magento Community Magento Community
Magento Community
Magento Community
 
benfrain.com
Sr. Member
 
Total Posts:  142
Joined:  2008-08-15
 

turbo1 - you truly are a prince among men. I was about throw myself out of the window (well at least delete everything on the server and try re-installing) I have managed to get my store back and working to the old 1.1.7 from a VERY non working 1.2.0.2 just by renaming that ‘downloadable’ directory.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lindaw
Sr. Member
 
Total Posts:  201
Joined:  2007-12-25
 

Guys with the Catalog Index problem, try making this file inoperable (I just put the number one at the end of it):

/app/code/core/Mage/CatalogIndex/sql/catalogindex_setup/mysql4-upgrade-0.7.9-0.7.10.php

No idea what else doing this breaks but I don’t care anymore, the site seems to be working. Let me know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
burguefab
Jr. Member
 
Total Posts:  10
Joined:  2010-01-19
 

Avez-vous trouvé une solution, j’ai le même problème, je ne m’en suis pas rendu compte tout de suite, mais le fait est qu’un client ne peut plus ajouter de produits dans le panier. Sans erreurs apparente, lors d’une tentative d’ajout, l’info, Impossible d’ajouter l’article au panier apparaît systématiquement.

url de mon site: 3w point magentoc point preprod point openweb point be

Merci d’avance pour toute piste me permettant d’éviter une réinstallation complète de mon site wink

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top