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

1.4.2 -> 1.5.0 = Magento doesn’t work at all anymore! 
 
martInteractive
Jr. Member
 
Total Posts:  14
Joined:  2011-01-27
 

I’ve updated my Magento 1.4.2 installation to 1.5.0..  But this cause in a problem that Magento isn’t working at all anymore! The front-end and back-end doesn’t show up anymore.

The page only shows this error at the top of the screen:

PDOException Object
(
    
[message:protected] => SQLSTATE[42S01]Base table or view already exists1050 Table 'mage_sales_order_status' already exists
    [string
:private] => 
    
[code:protected] => 42S01
    [file
:protected] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/lib/Varien/Db/Adapter/Pdo/Mysql.php
    [line
:protected] => 276
    [trace
:private] => Array
        (
            
[0] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] 
=> 276
                    [function] 
=> query
                    [class] 
=> PDO
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => CREATE TABLE `mage_sales_order_status` (
  `
statusvarchar(32NOT NULL,
  `
labelvarchar(128NOT NULL,
  
PRIMARY KEY (`status`)
ENGINE=InnoDB DEFAULT CHARSET=utf8
                        
)

                )

            
[1] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] 
=> 397
                    [function] 
=> raw_query
                    [class] 
=> Varien_Db_Adapter_Pdo_Mysql
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => CREATE TABLE `mage_sales_order_status` (
  `
statusvarchar(32NOT NULL,
  `
labelvarchar(128NOT NULL,
  
PRIMARY KEY (`status`)
ENGINE=InnoDB DEFAULT CHARSET=utf8
                        
)

                )

            
[2] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 636
                    [function] 
=> multi_query
                    [class] 
=> Varien_Db_Adapter_Pdo_Mysql
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => 
CREATE TABLE `mage_sales_order_status` (
  `
statusvarchar(32NOT NULL,
  `
labelvarchar(128NOT NULL,
  
PRIMARY KEY (`status`)
ENGINE=InnoDB DEFAULT CHARSET=utf8

                        
)

                )

            
[3] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.4.0.22-1.4.0.23.php
                    [line] 
=> 40
                    [function] 
=> run
                    [class] 
=> Mage_Core_Model_Resource_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => 
CREATE TABLE `mage_sales_order_status` (
  `
statusvarchar(32NOT NULL,
  `
labelvarchar(128NOT NULL,
  
PRIMARY KEY (`status`)
ENGINE=InnoDB DEFAULT CHARSET=utf8

                        
)

                )

            
[4] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 376
                    [args] 
=> Array
                        (
                            
[0] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.4.0.22-1.4.0.23.php
                        
)

                    
[function] => include
                )

            
[5] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 289
                    [function] 
=> _modifyResourceDb
                    [class] 
=> Mage_Core_Model_Resource_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => upgrade
                            [1] 
=> 1.4.0.22
                            [2] 
=> 1.4.0.25
                        
)

                )

            
[6] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 233
                    [function] 
=> _upgradeResourceDb
                    [class] 
=> Mage_Core_Model_Resource_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => 1.4.0.22
                            [1] 
=> 1.4.0.25
                        
)

                )

            
[7] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 161
                    [function] 
=> applyUpdates
                    [class] 
=> Mage_Core_Model_Resource_Setup
                    [type] 
=> ->
                    
[args] => Array
                        (
                        )

                )

            
[8] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/App.php
                    [line] 
=> 399
                    [function] 
=> applyAllUpdates
                    [class] 
=> Mage_Core_Model_Resource_Setup
                    [type] 
=> ::
                    
[args] => Array
                        (
                        )

                )

            
[9] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/App.php
                    [line] 
=> 329
                    [function] 
=> _initModules
                    [class] 
=> Mage_Core_Model_App
                    [type] 
=> ->
                    
[args] => Array
                        (
                        )

                )

            
[10] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/Mage.php
                    [line] 
=> 627
                    [function] 
=> run
                    [class] 
=> Mage_Core_Model_App
                    [type] 
=> ->
                    
[args] => Array
                        (
                            
[0] => Array
                                (
                                    
[scope_code] => 
                                    
[scope_type] => store
                                    [options] 
=> Array
                                        (
                                        )

                                )

                        )

                )

            
[11] => Array
                (
                    
[file] => /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/index.php
                    [line] 
=> 80
                    [function] 
=> run
                    [class] 
=> Mage
                    [type] 
=> ::
                    
[args] => Array
                        (
                            
[0] => 
                            
[1] => store
                        
)

                )

        )

    
[errorInfo] => Array
        (
            
[0] => 42S01
            [1] 
=> 1050
            [2] 
=> Table 'mage_sales_order_status' already exists
        
)

)

And this code is placed at the content section of the page.

Error in file"/home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.4.0.22-1.4.0.23.php" SQLSTATE[42S01]Base table or view already exists1050 Table 'mage_sales_order_status' already exists

Trace
:
#0 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.4.0.22', '1.4.0.25')
#2 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.4.0.22', '1.4.0.25')
#3 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/App.php(399): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/code/core/Mage/Core/Model/App.php(329): Mage_Core_Model_App->_initModules()
#6 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#7 /home/wijnbergen/domains/studentsindesign.nl/public_html/janlowin.projects/index.php(80): Mage::run('', 'store')
#8 {main}

Does anyone know a solution for this problem?
Thank you in advance!

 
Magento Community Magento Community
Magento Community
Magento Community
 
haijerome
Member
 
Avatar
Total Posts:  44
Joined:  2010-07-19
 

Hi Brother,

The error is due to reusing the same database instead of creating a new / fresh one for the new Magento installation.

Let me explain it a bit.

1. I hope you had some XYZ earlier which was used by your old magento installation or version.

2. And you have just removed / dropped all the tables in the XYZ database and tried to use the same database (or database name) for your new magento installation. Sadly MySQL won’t remove the indexes and other constraints on the database objects of the XYZ Database. (Though it seems to you everything has been removed) So its very obvious it throws an “view or table already exists”.

*********************************** SOLUTION *********************************************************************

3. Create a new database with or without privileges and run the installation wizard it will work.

BTW i came across the same error when i had tried to reuse the same database after emptying it and just found that this was the reason and fixed it . 

*********************************** SOLUTION *********************************************************************

And Magento 1.5.0.1 is awesome and i had just installed it on my local host (XAMPP on Windows XP) .

Hope this helps you and some one reading this post grin

ALL GLORY GOES TO GOD !!!

Regards,
Jerome Dennis D
MAGENTO DEVELOPMENT | MAGENTO CUSTOMIZATION
haijerome@gmail.com

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