How to install Magento on WAMP server localhost/localcomputer ?

In this post I will show you how to install Magento on WAMP server in your local computer.

Installing Magento on WAMP can be pretty painful for beginners, as magento requires a lot of server configurations which are not set by default.

*For those who are wondering, Why a server ? Well, for running a website you have to host the site in any server so that people in the internet can find it. In this case you will be turning your computer into a server and will host your website in it, so that you can see how your website behaves. But in this case your website will open only from the server i.e. your local computer.

Before you start installing you need the following:
1. WAMP server installed in your computer
2. Magento Community Edition Files.

If you don’t have WAMP installed in your computer, then follow as explained below:

 

integrate magento with erp

Installing WAMP:

    1. Download WAMP from http://www.wampserver.com/en/.
      [responsive] Download Wampserver and install Magento on WAMP
      [/responsive]
    2. Install and start the WAMP server.
      [responsive] wamp-icon
      [/responsive]
    3. Make sure that your wamp icon is green, if it’s not green then it’s not active.
      To make it active click on it and “Restart All Services”
      [responsive] restart-wamp
      [/responsive]
    4. Open any browser and type localhost or 127.0.0.1 on the address bar and you will see your WAMP server dashboard page.
      [responsive] wamp-dashboard
      [/responsive]


integrate magento with erp

Download Magento CE:

You can download magento community edition from this link. You can select your format of choice and download.
[responsive] download magento
[/responsive]

Installing Magento:-

Now that you have the server all set, you can start the process of installing Magento.
Extract the downloaded Magento file. Inside the extracted file you will see a folder named “magento”. You have to copy this folder in the root directory of your WAMP server. To get to the root directory, click on green WAMP icon and click “www directory”, your server root directory will open up.
[responsive] www root folder
[/responsive]

Copy the “magento” folder in this directory.
Ok, so now you have the magento files ready for installation. But before you start installation, you have to create database for your site.
Create Database:
In your WAMP server Dashboard click on phpMyadmin link in Tools section.
[responsive] create-database phpmyadmin
[/responsive]

This will open the phpMyAdmin Page.
Click on the database tab and type in the database name (suppose we name it magento1) and create the new database.

integrate magento with erp

[responsive] phpmyadmin-database creation
[/responsive]

Your database creation is complete.

Server configuration:

For error-free installation you have to change some settings of your WAMP server.
[list] [list_item icon=”ok”]

Enable curl extension

  1. Click on your green WAMP icon -> PHP -> PHP extensions -> php_curl (at the top of the list) and click on it to make it active. Click on WAMP icon and Restart all services.
[/list_item]

[responsive] php_curl
[/responsive]

[responsive] rewrite-module
[/responsive]

[list_item icon=”ok”]

Enable Apache rewrite module

  1. Click on WAMP icon -> Apache -> Apache Modules -> rewrite_module(towards the bottom of the list). Click on WAMP icon and Restart all services.
[/list_item]

 

integrate magento with erp

[list_item icon=”ok”]

Modify php.ini file

    1. Click on WAMP icon -> PHP -> php.ini
[responsive] php-ini-file
[/responsive]
  1. This will open up your php.ini file in a text editor. Search for “ max_execution_time “ in the file and you will find something like max_execution_time = 30 , change 30 to some arbitrary large value such as 1500. This change means we are changing the Maximum execution time of our server from 30 seconds to 1500 seconds.
  2. Similarly search for “ max_input_time ” and you will find “max_input_time = 60 ”, change 60 to 1500. Save the php.ini file.
[/list_item] [/list] Now you are all set to install magento.

    1. Click on WAMP icon and Restart all services.Wait till the icon turs green.
    2. Open your WAMP dashboard and click on magento folder in Your Project section.
[responsive] magento-projects
[/responsive]
    1. The Magento installation wizard opens up. Accept the terms and conditions and click on continue.

integrate magento with erp

[responsive] Install-wizard
[/responsive]
    1. The Localization settings page appears. No need to change anything here, you can change settings from backend later.
      Click on continue.
    2. Next the Configuration settings page appears. You have to give the Host name which will be “localhost” in this case. The Database name would be the one that we created earlier.
    3. User Name should be the Database user name. If you haven’t changed anything then it should be “root” and the password section would be blank.
[responsive] database-connection
[/responsive]
  1. Keep others as it is and click on continue. This step will take some time as Magento will be creating the Database Tables.
  2. After this the Admin Account creation page appears. Fill in the details and remember the Username and Password, it will be required to access the Admin section. You can leave the Encryption Key section Blank. Click on continue.
  3. That’s it. You are done and have set up your first Magento Webstore.

General errors while installing Magento
[custom_table style=”2″]

Errors Solution
PHP extension “curl” must be loaded Server Configuration Point 1
Maximum execution time of 30 seconds exceeded in ‘Installation path of WAMP/WWW/magento/lib/ZendDB/Statement/Pdo.php Server Configuration Point 3
[/custom_table]

integrate magento with erp

 

If you face any other issue while trying to install Magento on WAMP, please feel free to post it in the comment and I will be more than happy to help you.
If you want any other Magento related post you can request that too. I will try my best to write a post on your requests.  Keep an eye here for the upcoming posts.

Subrata Bauri

I am a Magento developer at InSync and spend most of my time reading books(weird ones). Ask me anything on Twitter @SubrataBauri and I will answer it personally.

  • Shineeth Sureshbabu

    Hi all,

    while trying to install magento this error comes up

    [ERROR] PDOException: SQLSTATE[HY000] [1045] Access denied for user ”@’localhost’ (using password: NO) in C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php:128 Stack trace: #0 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(128): PDO->__construct(‘mysql:dbname=in…’, ”, ”, Array) #1 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoMysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(398): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterAbstract.php(460): MagentoFrameworkDBAdapterPdoMysql->_connect() #4 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT version(…’, Array) #5 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT version(…’, Array) #6 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(580): MagentoFrameworkDBAdapterPdoMysql->_query(‘SELECT version(…’, Array) #7 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterAbstract.php(828): MagentoFrameworkDBAdapterPdoMysql->query(‘SELECT version(…’, Array) #8 C:wampwwwmagento_1setupsrcMagentoSetupValidatorDbValidator.php(93): Zend_Db_Adapter_Abstract->fetchOne(‘SELECT version(…’) #9 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(1205): MagentoSetupValidatorDbValidator->checkDatabaseConnection(”, ”, ”, ”) #10 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(770): MagentoSetupModelInstaller->assertDbAccessible() #11 [internal function]: MagentoSetupModelInstaller->installSchema() #12 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(342): call_user_func_array(Array, Array) #13 C:wampwwwmagento_1setupsrcMagentoSetupControllerInstall.php(109): MagentoSetupModelInstaller->install(Array) #14 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcControllerAbstractActionController.php(82): MagentoSetupControllerInstall->startAction() #15 [internal function]: ZendMvcControllerAbstractActionController->onDispatch(Object(ZendMvcMvcEvent)) #16 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(490): call_user_func(Array, Object(ZendMvcMvcEvent)) #17 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(214): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #18 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcControllerAbstractController.php(118): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #19 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcDispatchListener.php(93): ZendMvcControllerAbstractController->dispatch(Object(ZendHttpPhpEnvironmentRequest), Object(ZendHttpPhpEnvironmentResponse)) #20 [internal function]: ZendMvcDispatchListener->onDispatch(Object(ZendMvcMvcEvent)) #21 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(490): call_user_func(Array, Object(ZendMvcMvcEvent)) #22 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(214): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #23 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcApplication.php(314): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #24 C:wampwwwmagento_1setupindex.php(35): ZendMvcApplication->run() #25 {main} Next Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user ”@’localhost’ (using password: NO) in C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php:144 Stack trace: #0 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoMysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(398): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterAbstract.php(460): MagentoFrameworkDBAdapterPdoMysql->_connect() #3 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT version(…’, Array) #4 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT version(…’, Array) #5 C:wampwwwmagento_1vendormagentoframeworkDBAdapterPdoMysql.php(580): MagentoFrameworkDBAdapterPdoMysql->_query(‘SELECT version(…’, Array) #6 C:wampwwwmagento_1vendormagentozendframework1libraryZendDbAdapterAbstract.php(828): MagentoFrameworkDBAdapterPdoMysql->query(‘SELECT version(…’, Array) #7 C:wampwwwmagento_1setupsrcMagentoSetupValidatorDbValidator.php(93): Zend_Db_Adapter_Abstract->fetchOne(‘SELECT version(…’) #8 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(1205): MagentoSetupValidatorDbValidator->checkDatabaseConnection(”, ”, ”, ”) #9 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(770): MagentoSetupModelInstaller->assertDbAccessible() #10 [internal function]: MagentoSetupModelInstaller->installSchema() #11 C:wampwwwmagento_1setupsrcMagentoSetupModelInstaller.php(342): call_user_func_array(Array, Array) #12 C:wampwwwmagento_1setupsrcMagentoSetupControllerInstall.php(109): MagentoSetupModelInstaller->install(Array) #13 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcControllerAbstractActionController.php(82): MagentoSetupControllerInstall->startAction() #14 [internal function]: ZendMvcControllerAbstractActionController->onDispatch(Object(ZendMvcMvcEvent)) #15 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(490): call_user_func(Array, Object(ZendMvcMvcEvent)) #16 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(214): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #17 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcControllerAbstractController.php(118): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #18 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcDispatchListener.php(93): ZendMvcControllerAbstractController->dispatch(Object(ZendHttpPhpEnvironmentRequest), Object(ZendHttpPhpEnvironmentResponse)) #19 [internal function]: ZendMvcDispatchListener->onDispatch(Object(ZendMvcMvcEvent)) #20 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(490): call_user_func(Array, Object(ZendMvcMvcEvent)) #21 C:wampwwwmagento_1vendorzendframeworkzend-eventmanagersrcEventManager.php(214): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #22 C:wampwwwmagento_1vendorzendframeworkzend-mvcsrcApplication.php(314): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #23 C:wampwwwmagento_1setupindex.php(35): ZendMvcApplication->run() #24 {main}

    Can you help me ?

  • Ashutosh Tiwari

    I am using XAMPP local host and completed installation of magento. But after installing Magento I am unable to click on any menu items in the Admin Panel. The page is not loaded properly and I am unable to change any configuration settings through admin panel. Can you please help.

    • Arijit De

      Hello Ashutosh,

      Are you installing Magento 2 or Magento 1?

      • Ashutosh Tiwari

        Magento 2

        • Arijit De

          Ok.
          So, static files are not loaded.
          You just need to go through the following steps:-
          1) Login to the server using SSH credentials and go to the magento root directory.
          2) Run command : –
          1st – chmod -R 777 var pub vendor
          2nd – php bin/magento setup:static-content:deploy
          3rd – php bin/magento cache:clean
          4th – php bin/magento cache:flush
          5th – chmod -R 777 var pub vendor

          After then, check once again.

        • Arijit De

          Ok. Noted.

          So, static files are not loaded that is causing the problem.

          Process the following steps:-
          1) Login to the server using SSH credentials and go to the Magento root directory.
          2)Run the following commands one after another:-
          a)chmod -R 777 var pub vendor
          b)php bin/magento setup:static-content:deploy
          c)php bin/magento cache:clean
          d)php bin/magento cache:flush
          e)chmod -R 777 var pub vendor

          After then, check once again.

          Thanks

    • Biplab Rout

      GO to the console tab and check if you are getting any javascript error

      • Ashutosh Tiwari

        [main] Initializing Control Panel
        [main] Windows Version: Enterprise 64-bit
        [main] XAMPP Version: 5.6.31
        [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
        [main] XAMPP Installation Directory: “c:xampp”
        [main] Checking for prerequisites
        [main] All prerequisites found
        [main] Initializing Modules
        [main] Starting Check-Timer
        [main] Control Panel Ready
        [Apache] Attempting to start Apache app…
        [Apache] Status change detected: running
        [mysql] Attempting to start MySQL app…
        [mysql] Status change detected: running

        No errors are there.

  • when i open the installation page, the css, js and images are not loaded. any ideas why?

    • Arijit De

      Hello Seth,

      I hope you are installing magento 1.If yes, please check whether your skin, media and js directory has the proper permission to get executed.

      Thanks

  • Alvar

    Can’t access the installation page!

    The requested URL /magento was not found on this server. Also tried as http://localhost/magento
    Still the same…

  • Pak Taza
  • hirosh

    Hi Mr. Bauri, I am new to megento, This is my first attempt, I tried to install magento 2.1.3 on wamp 2.5 server, did all the configuration parts as you told. After configuration part I tried to install magento by typing localhost/giftcart (my project name is giftcart). it says “Parse error: syntax error, unexpected ‘.’ in C:wampwwwgiftcartvendormagentoframeworkObjectManagerFactoryAbstractFactory.php on line 93”, screen shot attached, Please check this error and reply me https://uploads.disquscdn.com/images/1cb44d80ba6f2681500ad89c21d159bf88008a7a703e34c849fd7c972a5fbcf7.jpg

  • venu

    Hi I am Getting this Error in magento 1.9.3 After the sample data is inserted can anyone help please…

    Error:

    a:5:{i:0;s:698:”SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘sales_bestsellers_aggregated_yearly.product_type_id’ in ‘field list’, query was: SELECT COUNT(*) FROM (SELECT MAX(DATE_FORMAT(period, ‘%Y-%m-%d’)) AS `period`, SUM(qty_ordered) AS `qty_ordered`, `sales_bestsellers_aggregated_yearly`.`product_id`, MAX(product_name) AS `product_name`, MAX(product_price) AS `product_price`, `sales_bestsellers_aggregated_yearly`.`product_type_id` FROM `sales_bestsellers_aggregated_yearly` WHERE (EXISTS (SELECT 1 FROM `catalog_product_entity` AS `existed_products` WHERE (sales_bestsellers_aggregated_yearly.product_id = existed_products.entity_id))) AND (store_id IN(0)) GROUP BY `product_id` LIMIT 5) AS `t`”;i:1;s:5063:”#0 D:xampp1htdocsdownloaderlibVarienDbStatementPdoMysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 D:xampp1htdocsdownloaderappcodecoreZendDbStatement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 D:xampp1htdocsdownloaderlibZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array)
    #3 D:xampp1htdocsdownloaderlibZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(*)…’, Array)
    #4 D:xampp1htdocsdownloaderlibVarienDbAdapterPdoMysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(*)…’, Array)
    #5 D:xampp1htdocsdownloaderlibZendDbAdapterAbstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
    #6 D:xampp1htdocsdownloaderlibVarienDataCollectionDb.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
    #7 D:xampp1htdocsdownloaderlibVarienDataCollection.php(225): Varien_Data_Collection_Db->getSize()
    #8 D:xampp1htdocsdownloaderlibVarienDataCollection.php(211): Varien_Data_Collection->getLastPageNumber()
    #9 D:xampp1htdocsdownloaderlibVarienDataCollectionDb.php(522): Varien_Data_Collection->getCurPage()
    #10 D:xampp1htdocsdownloaderlibVarienDataCollectionDb.php(569): Varien_Data_Collection_Db->_renderLimit()
    #11 D:xampp1htdocsdownloaderappcodecoreMageReportsModelResourceReportCollectionAbstract.php(285): Varien_Data_Collection_Db->load(false, false)
    #12 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockWidgetGrid.php(550): Mage_Reports_Model_Resource_Report_Collection_Abstract->load()
    #13 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockDashboardTabProductsOrdered.php(66): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
    #14 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockWidgetGrid.php(643): Mage_Adminhtml_Block_Dashboard_Tab_Products_Ordered->_prepareCollection()
    #15 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockWidgetGrid.php(649): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
    #16 D:xampp1htdocsdownloaderappcodecoreMageCoreBlockAbstract.php(922): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
    #17 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockDashboardGrids.php(64): Mage_Core_Block_Abstract->toHtml()
    #18 D:xampp1htdocsdownloaderappcodecoreMageCoreBlockAbstract.php(297): Mage_Adminhtml_Block_Dashboard_Grids->_prepareLayout()
    #19 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
    #20 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlBlockDashboard.php(75): Mage_Core_Model_Layout->createBlock(‘adminhtml/dashb…’)
    #21 D:xampp1htdocsdownloaderappcodecoreMageCoreBlockAbstract.php(297): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
    #22 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
    #23 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(472): Mage_Core_Model_Layout->createBlock(‘adminhtml/dashb…’, ‘dashboard’)
    #24 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(239): Mage_Core_Model_Layout->addBlock(‘adminhtml/dashb…’, ‘dashboard’)
    #25 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
    #26 D:xampp1htdocsdownloaderappcodecoreMageCoreModelLayout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #27 D:xampp1htdocsdownloaderappcodecoreMageCoreControllerVarienAction.php(344): Mage_Core_Model_Layout->generateBlocks()
    #28 D:xampp1htdocsdownloaderappcodecoreMageCoreControllerVarienAction.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #29 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlControllerAction.php(275): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
    #30 D:xampp1htdocsdownloaderappcodecoreMageAdminhtmlcontrollersDashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
    #31 D:xampp1htdocsdownloaderappcodecoreMageCoreControllerVarienAction.php(418): Mage_Adminhtml_DashboardController->indexAction()
    #32 D:xampp1htdocsdownloaderappcodecoreMageCoreControllerVarienRouterStandard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #33 D:xampp1htdocsdownloaderappcodecoreMageCoreControllerVarienFront.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #34 D:xampp1htdocsdownloaderappcodecoreMageCoreModelApp.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #35 D:xampp1htdocsdownloaderappMage.php(684): Mage_Core_Model_App->run(Array)
    #36 D:xampp1htdocsdownloaderindex.php(83): Mage::run(”, ‘store’)
    #37 {main}”;s:3:”url”;s:96:”/downloader/index.php/admin/dashboard/index/key/7b4851410e543fb3fd9d188423aadf35/images/logo.gif”;s:11:”script_name”;s:21:”/downloader/index.php”;s:4:”skin”;s:5:”admin”;}

  • Qadri Quraishi

    downloaded ver 2.1.2 but after extracting didnt find any magento folder please help me

  • Sanjaya Pasanna

    Hi I try to install Magento on wamp server. I have error found like below. Please help me to solved.

    Installing data…
    [ERROR] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’ in C:wampwwwMagentovendormagentozendframework1libraryZendDbStatementPdo.php:228 Stack trace: #0 C:wampwwwMagentovendormagentozendframework1libraryZendDbStatementPdo.php(228): PDOStatement->execute(Array) #1 C:wampwwwMagentovendormagentoframeworkDBStatementPdoMysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #2 C:wampwwwMagentovendormagentozendframework1libraryZendDbStatement.php(303): MagentoFrameworkDBStatementPdoMysql->_execute(Array) #3 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array) #4 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `cu…’, Array) #5 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(459): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `cu…’, Array) #6 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(514): MagentoFrameworkDBAdapterPdoMysql->_query(‘INSERT INTO `cu…’, Array) #7 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterAbstract.php(576): MagentoFrameworkDBAdapterPdoMysql->query(‘INSERT INTO `cu…’, Array) #8 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(1790): Zend_Db_Adapter_Abstract->insert(‘customer_group’, Array) #9 C:wampwwwMagentovendormagentomodule-customerSetupInstallData.php(50): MagentoFrameworkDBAdapterPdoMysql->insertForce(‘customer_group’, Array) #10 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(844): MagentoCustomerSetupInstallData->install(Object(MagentoSetupModuleDataSetup), Object(MagentoSetupModelModuleContext)) #11 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(796): MagentoSetupModelInstaller->handleDBSchemaData(Object(MagentoSetupModuleDataSetup), ‘data’) #12 [internal function]: MagentoSetupModelInstaller->installDataFixtures() #13 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(344): call_user_func_array(Array, Array) #14 C:wampwwwMagentosetupsrcMagentoSetupControllerInstall.php(109): MagentoSetupModelInstaller->install(Array) #15 C:wampwwwMagentovendorzendframeworkzend-mvcsrcControllerAbstractActionController.php(82): MagentoSetupControllerInstall->startAction() #16 [internal function]: ZendMvcControllerAbstractActionController->onDispatch(Object(ZendMvcMvcEvent)) #17 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent)) #18 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(205): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #19 C:wampwwwMagentovendorzendframeworkzend-mvcsrcControllerAbstractController.php(118): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #20 C:wampwwwMagentovendorzendframeworkzend-mvcsrcDispatchListener.php(93): ZendMvcControllerAbstractController->dispatch(Object(ZendHttpPhpEnvironmentRequest), Object(ZendHttpPhpEnvironmentResponse)) #21 [internal function]: ZendMvcDispatchListener->onDispatch(Object(ZendMvcMvcEvent)) #22 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent)) #23 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(205): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #24 C:wampwwwMagentovendorzendframeworkzend-mvcsrcApplication.php(314): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #25 C:wampwwwMagentosetupindex.php(31): ZendMvcApplication->run() #26 {main} Next Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’, query was: INSERT INTO `customer_group` (`customer_group_id`, `customer_group_code`, `tax_class_id`) VALUES (?, ?, ?) in C:wampwwwMagentovendormagentozendframework1libraryZendDbStatementPdo.php:235 Stack trace: #0 C:wampwwwMagentovendormagentoframeworkDBStatementPdoMysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #1 C:wampwwwMagentovendormagentozendframework1libraryZendDbStatement.php(303): MagentoFrameworkDBStatementPdoMysql->_execute(Array) #2 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterAbstract.php(480): Zend_Db_Statement->execute(Array) #3 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterPdoAbstract.php(238): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `cu…’, Array) #4 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(459): Zend_Db_Adapter_Pdo_Abstract->query(‘INSERT INTO `cu…’, Array) #5 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(514): MagentoFrameworkDBAdapterPdoMysql->_query(‘INSERT INTO `cu…’, Array) #6 C:wampwwwMagentovendormagentozendframework1libraryZendDbAdapterAbstract.php(576): MagentoFrameworkDBAdapterPdoMysql->query(‘INSERT INTO `cu…’, Array) #7 C:wampwwwMagentovendormagentoframeworkDBAdapterPdoMysql.php(1790): Zend_Db_Adapter_Abstract->insert(‘customer_group’, Array) #8 C:wampwwwMagentovendormagentomodule-customerSetupInstallData.php(50): MagentoFrameworkDBAdapterPdoMysql->insertForce(‘customer_group’, Array) #9 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(844): MagentoCustomerSetupInstallData->install(Object(MagentoSetupModuleDataSetup), Object(MagentoSetupModelModuleContext)) #10 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(796): MagentoSetupModelInstaller->handleDBSchemaData(Object(MagentoSetupModuleDataSetup), ‘data’) #11 [internal function]: MagentoSetupModelInstaller->installDataFixtures() #12 C:wampwwwMagentosetupsrcMagentoSetupModelInstaller.php(344): call_user_func_array(Array, Array) #13 C:wampwwwMagentosetupsrcMagentoSetupControllerInstall.php(109): MagentoSetupModelInstaller->install(Array) #14 C:wampwwwMagentovendorzendframeworkzend-mvcsrcControllerAbstractActionController.php(82): MagentoSetupControllerInstall->startAction() #15 [internal function]: ZendMvcControllerAbstractActionController->onDispatch(Object(ZendMvcMvcEvent)) #16 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent)) #17 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(205): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #18 C:wampwwwMagentovendorzendframeworkzend-mvcsrcControllerAbstractController.php(118): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #19 C:wampwwwMagentovendorzendframeworkzend-mvcsrcDispatchListener.php(93): ZendMvcControllerAbstractController->dispatch(Object(ZendHttpPhpEnvironmentRequest), Object(ZendHttpPhpEnvironmentResponse)) #20 [internal function]: ZendMvcDispatchListener->onDispatch(Object(ZendMvcMvcEvent)) #21 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent)) #22 C:wampwwwMagentovendorzendframeworkzend-eventmanagersrcEventManager.php(205): ZendEventManagerEventManager->triggerListeners(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #23 C:wampwwwMagentovendorzendframeworkzend-mvcsrcApplication.php(314): ZendEventManagerEventManager->trigger(‘dispatch’, Object(ZendMvcMvcEvent), Object(Closure)) #24 C:wampwwwMagentosetupindex.php(31): ZendMvcApplication->run() #25 {main}

  • Chuks Evaristus Stanley

    i got this exception magento 2.1.1

    [Exception]
    Missing write permissions to the following paths:
    C:/wamp/www/Magento2/pub/mediadownloadablefileslinksluluma_background_-_model_against_fence_4_sec_.mp4
    C:/wamp/www/Magento2/pub/mediadownloadablefilessamplesluluma_background_-_model_against_fence_4_sec_.mp4

  • Avjeet Singh Mangat

    sir am using xampp with linux OS.. can i install magento here too??

  • Nemo Phin

    Thanks for your great sharing but I do not understand when start to run http://localhost/magento/admin/ it try to occupy many hard disk space and I do not know what is being execute and to where those files or record in being saved to. I have tried to check folder property of the magento folder but it seems not taking those big of size.

    Any suggestion? I am new to magento environment.

    Best regards,

    Nemo

  • Mathan Kumar

    plz send me a download link for wamp and mageto download.

  • Mathan Kumar

    Magento supports PHP 5.5.0 or later. Please read

    Magento System Requirements i got tis error while install Magento plz help me.

    • which Magento version are you trying to install ? always check magento version specific requirement and PHP version of your wamp/xampp install

  • Danny Tzall

    please help..
    i get this error
    ” Cannot log in to the MySQL server ”
    what should i do?

    • try corrent credentials with magento install. If you don’t know the credentials, try “root” as username and a blank password.

  • Danny Tzall

    hello Subrata
    how can i update my php from 5.3.5
    to the required 5.5 ?
    plz help

    i tried downloading better versions of the wamp but all files were coruptted…

    • Danny Tzall

      i found one. solved

      • Sorry for the late buddy, can you share here your slution so that other can get benefit.

  • Ray P

    Hello, I have had some issues loading Magento but have worked through some of them already. However, this one has me confused. I’ve found some information stating it should be an issue within the config.xml file, but I cannot find, or its more like I really don’t know what I’m looking for.

    When I get to one of the last steps to installing Magento it is stating I have “Fatal error: Class ‘MagentoFrameworkDBHelper’ not found in C:wamp2wwwvendormagentoframeworkDBHelper.php on line 12”

    Attached is the screen shot. Can you please provide some detail or fix to what the actual issue is?

    Thank you in advance for your time. -Ray

    • which magento version are installing. I guess you have downloaded Magento 2.

  • Rajeev subramanya

    Subrata Bauri sir i have downloaded and installed wamp as you directed above then i downloaded the magento folder and placed in the wamp directory as you have instructed. then i created the database named it as megento 1 then i restarted the wamp then if i click on the magento in the my project menu it is showing the Error That

    “This webpage is not available

    ERR_NAME_NOT_RESOLVED”

    please help me to find the solution

  • Ambala

    check these screen shots also

    error showing while setup

    • Please edit your php.ini, uncomment required extensions and restart your localhost. Cheers

  • Ambala

    Great Help

    But still I am unable to install Magento
    when i click on phpmyadmin link then u can check this is the screen shot

    Plz suggest

  • dounia

    heeeeeeeeeeeeeeelp

  • dounia

    hello please help … i’ve this probleme “Database connection error.” to instal magento … what i have to do …. please help

  • meena

    Exception printing is disabled by default for security reasons.

    Error log record number: 1142651265——-this is my error..pls give me a solution

    • please look into var/reports folder and search for exact record number. Open that file, there you can see the error.

  • CMWOO

    Hi, i unable to install Magento 1.7 in WampServer version 2.5. Anyone can help to install?

  • Sameer Malik

    hi sir,
    my magento folder is not opening. can u please help me out ?

  • Tommy BossHogg Banky

    Trying to install magento on wamp, but keep getting error: please enter a valid URL, tried every possible protocol, even tried using but still dsame pls help out.
    Thanks

  • Ayush Sharma

    You don’t have permission to access /magento/
    on this server.

    • may be you have appropriate permissions on the folder. Sometimes when you unzip the Magento folder it needs some permission to access it. I suggest, please check on file permissions. Thanks

  • Tanuj Mohan

    i am unable to install megento after doing all settings as mentioned here when i am clicking on megento1 i got this blank page server not found. please tell what to do for next step

  • Keyur

    after following all the step accurately, when I click on magento folder under project section. It shows “Server not Found.”

  • Rajesh Verma

    Hi Subrata,

    Presently i am using Magento v 1.9.2.1 and now few days i am unable not able to send any mail and not received any information on my dashboard. please intimate to me how i can solve it.

    Waiting for your reply hope you will hear soon.

    • in Magento 1.9.2.1, transactional emails are hit by cron job. Please set a crontab on your server.

  • Pooja Vats

    I installed locally magento BUT i cannot login to admin panel!

  • jay ryan

    i want to bring my live website to my localhost..i have downloaded the files and placed it on d root folder. but when i open localhost host it shows the files path

    • Didnt get you. please share screenshot or skype me at a.nu.rag

  • Oluwadamilare Ayorinde Odusany

    After installing correctly, I can’t login with my username and password

  • sonal jain

    hello sir,

    when i fill configuration page it returns back on same page. my database name is in samll letters and when i write in base url “http://localhost/magento/” it shows error “Please enter a valid URL. Protocol is required (http://, https:// or ftp://)” but when i write 127.0.0.1:100 instead of localhost it back to same page.
    what should i do?
    thanks,

  • angel

    sir i find the solution.

    • Hi @disqus_0xwk7b0K3l:disqus – Nice to hear that. What exact error you were getting?. Please share here, so that other readers can solve their problems.

  • angel

    hello sir while installing magento on wamp i am getting the error ‘database connection error’

    • @disqus_0xwk7b0K3l:disqus – Hi, what error you are getting ?

  • ABHIMANYU SINGH

    Hi Subrata,

    I have been trying to install magento from a very long time but getting similar problem every time, already tried installing two or three different versions of magento but no result….Getting this error after changing base path from http://localhost/magento to as it was showing invalid path error.

    please help…

    Magento ver 1.9.2.1

    • Hi ABHIMANYU SINGH, Thanks for sharing it with us.

      Please edit your app/code/core/Mage/SalesRule/sqlsalesrule_setup/install-1.6.0.0.php
      around line number 333,

      Replace

      ->addColumn(‘period’, Varien_Db_Ddl_Table::TYPE_DATE, null, array(
      ‘nullable’ => false,
      ), ‘Period’)

      to

      ->addColumn(‘period’, Varien_Db_Ddl_Table::TYPE_DATE, null, array(
      ‘nullable’ => true,
      ), ‘Period’)

      Clear your Database and delete “app/etc/local.xml” file before re-installing Magento.

      Good luck 🙂

      • ABHIMANYU SINGH

        Thank You…It has been resolved.

  • ABHIMANYU SINGH

    Hi Subrata,

    I have been trying to install magento from a very long time but getting similar problem every time, already tried installing two or three different versions of magento but no result….Getting this error please help…

    Magento ver 1.9.2.1

    There has been an error processing your request

    Error in file: “C:wampwwwmagentoappcodecoreMageSalesRulesqlsalesrule_setupupgrade-1.6.0.0-1.6.0.1.php” – SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘period’, query was: CREATE TABLE `coupon_aggregated_updated` (
    `id` int UNSIGNED NOT NULL auto_increment COMMENT ‘Id’ ,
    `period` date NOT NULL default ” COMMENT ‘Period’ ,
    `store_id` smallint UNSIGNED NULL COMMENT ‘Store Id’ ,
    `order_status` varchar(50) NULL COMMENT ‘Order Status’ ,
    `coupon_code` varchar(50) NULL COMMENT ‘Coupon Code’ ,
    `coupon_uses` int NOT NULL default ‘0’ COMMENT ‘Coupon Uses’ ,
    `subtotal_amount` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Subtotal Amount’ ,
    `discount_amount` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Discount Amount’ ,
    `total_amount` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Total Amount’ ,
    `subtotal_amount_actual` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Subtotal Amount Actual’ ,
    `discount_amount_actual` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Discount Amount Actual’ ,
    `total_amount_actual` decimal(12,4) NOT NULL default ‘0.0000’ COMMENT ‘Total Amount Actual’ ,
    PRIMARY KEY (`id`),
    UNIQUE `UNQ_COUPON_AGGRED_UPDATED_PERIOD_STORE_ID_ORDER_STS_COUPON_CODE` (`period`, `store_id`, `order_status`, `coupon_code`),
    INDEX `IDX_COUPON_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
    CONSTRAINT `FK_COUPON_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
    ) COMMENT=’Coupon Aggregated Updated’ ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci

    Trace:
    #0 C:wampwwwmagentoappcodecoreMageCoreModelResourceSetup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 C:wampwwwmagentoappcodecoreMageCoreModelResourceSetup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘upgrade’, ‘1.6.0.0’, ‘1.6.0.3’)
    #2 C:wampwwwmagentoappcodecoreMageCoreModelResourceSetup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(‘1.6.0.0’, ‘1.6.0.3’)
    #3 C:wampwwwmagentoappcodecoreMageCoreModelResourceSetup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 C:wampwwwmagentoappcodecoreMageCoreModelApp.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 C:wampwwwmagentoappcodecoreMageCoreModelApp.php(354): Mage_Core_Model_App->_initModules()
    #6 C:wampwwwmagentoappMage.php(684): Mage_Core_Model_App->run(Array)
    #7 C:wampwwwmagentoindex.php(83): Mage::run(”, ‘store’)
    #8 {main}

  • @disqus_2pL3biwZmI:disqus please check app/etc/lcoal.xml for your correct admin frontname

  • Problem in installation magento on window 7

    • @deepak – go to your installed location and open the directory var/report and find the file with the name same as the number showing in the screen. There you will be able to see the exact error.

  • Raza Rahman

    Hello if I want to install Magento it shows me a ERR_NAME_NOT_RESOLVED error.

    • I think you are using Google chrome. if you are please enter “chrome://net-internals/#dns” in url bar and clear your host cache. I hope you will be able to solve this.

  • Shambhu Siwakoti

    I have studied all the information from you and maintained all the instructions but I am stuck with this problem.
    my os: windows 8, 64bit
    wamp version: 2.5
    magento version:1.9.1.1

    please help me, I am suffering form this from week ….. 🙁

    Thanks in Advance.

    • I suspect there is some error while installing the magento, it failed during execution of Mage_Directory install script. Check correct database permissions, clear data from core_resource table and delete app/etc/local.xml file. Restart the installation again.

  • isa abu

    i follow the instruction up to when i am suppose to click on magneto for to install the file from the project session but am getting error

  • Jesper Flindt

    Hi Subrata,
    I have followed your guide and set up a local installation of Magento on WAMP.

    All went great until I wanted to login to the Magento backend.
    When entering my login and pass it merely reloads the login page.

    If I (on purpose) use the wrong username or password Magento prompts me that it is wrong.
    But if I use the correct one nothing happens.

    Any input on why this might be?

  • Aakash Garg

    I have done everything the same way you told
    but still i”m getting a database connection error
    would you please help me

    • try 127.0.0.1 or 127.0.0.1:3306 in your database credentials section while installation.

  • Kevin Arrieta

    el error es este 559977281
    y dentro de la carpeta de wamp ese error aparece asi:

    a:5:{i:0;s:1080:”Error in file: “C:wampwwwmagento1appcodecoreMageOauthsqloauth_setupinstall-1.0.0.0.php” – SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘oauth_consumer’ already exists, query was: CREATE TABLE `oauth_consumer` (

    `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT ‘Entity Id’ ,

    `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT ‘Created At’ ,

    `updated_at` timestamp NULL default NULL COMMENT ‘Updated At’ ,

    `name` varchar(255) NOT NULL COMMENT ‘Name of consumer’ ,

    `key` varchar(32) NOT NULL COMMENT ‘Key code’ ,

    `secret` varchar(32) NOT NULL COMMENT ‘Secret code’ ,

    `callback_url` varchar(255) NULL COMMENT ‘Callback URL’ ,

    `rejected_callback_url` varchar(255) NOT NULL COMMENT ‘Rejected callback URL’ ,

    PRIMARY KEY (`entity_id`),

    UNIQUE `UNQ_OAUTH_CONSUMER_KEY` (`key`),

    UNIQUE `UNQ_OAUTH_CONSUMER_SECRET` (`secret`),

    INDEX `IDX_OAUTH_CONSUMER_CREATED_AT` (`created_at`),

    INDEX `IDX_OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)

    ) COMMENT=’OAuth Consumers’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci”;i:1;s:920:”#0 C:wampwwwmagento1appcodecoreMageCoreModelResourceSetup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)

    #1 C:wampwwwmagento1appcodecoreMageCoreModelResourceSetup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘install’, ”, ‘1.0.0.0’)

    #2 C:wampwwwmagento1appcodecoreMageCoreModelResourceSetup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘1.0.0.0’)

    #3 C:wampwwwmagento1appcodecoreMageCoreModelResourceSetup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()

    #4 C:wampwwwmagento1appcodecoreMageCoreModelApp.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()

    #5 C:wampwwwmagento1appcodecoreMageCoreModelApp.php(343): Mage_Core_Model_App->_initModules()

    #6 C:wampwwwmagento1appMage.php(684): Mage_Core_Model_App->run(Array)

    #7 C:wampwwwmagento1index.php(87): Mage::run(”, ‘store’)

    #8 {main}”;s:3:”url”;s:46:”/magento1/index.php/install/wizard/configPost/”;s:11:”script_name”;s:19:”/magento1/index.php”;s:4:”skin”;s:7:”default”;}

    que debo hacer gracias

    • @disqus_vrJeeHoZW6:disqus – Please delete your existing table ‘oauth_consumer’ from database OR Edit the file “C:wampwwwmagento1appcodecoreMageOauthsqloauth_setupinstall-1.0.0.0.php”.

      replace “CREATE TABLE” with “CREATE TABLE IF NOT EXISTS”

  • beckon

    Hello Subrata…
    I have successfully installed magento on my local wamp server.. really thanks for that.
    But I am not able to login on admin panel, its giving me error of wrong credentials.
    Would You please tell me the solution of this?

    • try executing “UPDATE `admin_user` SET `password` = MD5(‘NEWPASSWORD’) WHERE `username` = ‘ADMINUSERNAME’;” in your database. This will reset your password to new password.

  • Eyüp

    Hi Subrata, I’m new in this and bought a ready magento theme. Now trying to make my website ready. I download wamp server 2.5 and magento 1.9. I know above pictures are for different versions but I did everthing you wirtten above. At the end when I click “magento” under my project, I can not get into magento installation wizard. Can you help me with this. Thanx a lot

    • Try locating your index.php file under magento folder.
      e.g. Enter “localhost/magento/index.php” in browser.

  • Trupti Mulajkar Deshmukh

    Trying to use Magento on localhost using WAMP 2.5 – It is an unusual error i get. I was able to install Magento by creating an alias to the firectory since it is installed in the d:/ drive of my computer along with WAMP. when I am trying to do http://localhost/magento/ I get an error saying file not found but when i type http://localhost/magento/index.php/ i go to the home page of Magento – what am i doing wrong? Should i continue working on it from the Aliases in WAMP

    • open you admin panel, go to System > Configuration > General > Web > Search Engines Optimization. Set Use Web Server Rewrites to yes. Check your .htaccess file also.

  • Rahul Singh

    Hello, i followed your instructions but i faced some issue in configuration page.when i continue this page, it will redirect in same configuration page.i have uploaded screen shots. check this.

  • ravi

    hello sir ! i have some problem in creating admin account .
    when i submit data than return again this page.

    • Please check into your magento installation folder. go to var/log folder and check exception.log and system.log for any errors.

  • sonia

    hello sir,

    I m nt getting this error..pls help me..

    There has been an error processing your request

    Error in file: “C:wampwwwmagento3appcodecoreMageSalesRulesqlsalesrule_setupupgrade-1.6.0.0-1.6.0.1.php” – SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘period’

    Trace:
    #0 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘upgrade’, ‘1.6.0.0’, ‘1.6.0.2’)
    #2 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(‘1.6.0.0’, ‘1.6.0.2’)
    #3 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 C:wampwwwmagento3appcodecoreMageCoreModelApp.php(412): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 C:wampwwwmagento3appcodecoreMageCoreModelApp.php(338): Mage_Core_Model_App->_initModules()
    #6 C:wampwwwmagento3appMage.php(649): Mage_Core_Model_App->run(Array)
    #7 C:wampwwwmagento3index.php(87): Mage::run(”, ‘store’)
    #8 {main}

    Error log record number: 1017508510

    • Hi @disqus_tw3PCXRxPu:disqus
      Try replacing in the file magentoappcodecoreMageSalesRulesqlsalesrule_setupinstall-1.6.0.0.fp
      lines 333-335:

      -> addColumn (’period’, Varien_Db_Ddl_Table :: TYPE_DATE, null, array (
      ‘nullable’ => false,
      ), ‘Period’)

      on

      -> addColumn (’period’, Varien_Db_Ddl_Table :: TYPE_DATE, null, array (
      ‘nullable’ => true,
      ), ‘Period’)

  • Hammad Aarora

    dear mr. subrata.

    i have a problem during installation of magento (configuration).

    http://localhost:2120/magento/index.php/install/wizard/installDb/

    please give me soulution,

    1. error

    [xdebug_message] => ( ! ) PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 La table ‘rating_entity’ existe déjà in C:wampwwwmagentolibZendDbStatementPdo.php on line 228
    Call Stack

    [xdebug_message] => ( ! ) PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 La table ‘rating_entity’ existe déjà in C:wampwwwmagentolibZendDbStatementPdo.php on line 228
    Call Stack

    ( ! ) Zend_Db_Statement_Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 La table ‘rating_entity’ existe déjà , query was: CREATE TABLE `rating_entity` (
    `entity_id` smallint UNSIGNED NOT NULL auto_increment COMMENT ‘Entity Id’ ,

    • Please delete table “rating_entity” from magento databasre and restart the installation.
      If you are facing problem, Please delete all the tables and “local.xml ” from app/etc folder of your magento installation folder and restart the installation.

  • balbeer

    Hi,

    I am getting the below error while installation. I have also tried by giving the URL as and it is not working. Can you please help me out here.

    Database connection error.

    • Subrata Bauri

      Have you tried ?

      • balbeer

        Yes that is also not working..

  • Anand

    Hi Subrata, This is Anand. I want to create only Android Mobile Application for Magento Community edition. Could you please help me out with this because I do not have any experience to create Android Mobile Application for Magento. Regards, Anand

    • If you are interested on integration with magento application. Please ping me.

  • ER Shubham Agrawal

    after installing magento successfully,it gives me no error msg but i am unable to login to admin area . what should i do. plz help

    • Subrata Bauri

      Hello Shubham,
      If you install fresh Magento and are not able to LogIn to Admin then it’s a cookie issue. Make sure cookie is enabled in the browser you are trying to access. Check out this blog, http://appseconnect.com/how-to-install-magento-on-wamp-server/
      Download the “Installation problems and solution pdf” in that blog. It have the solution for the cookie issue.
      Let me know if it solves your problem.

  • Prasanth

    Still I am getting error after installing in wamp both frontend and back ends are not loading time out error as many redirections

    • Subrata Bauri

      What is the exact error? Are you using sample data or extensions? Which version of Magento?

      • Prasanth K

        I managed installing the Magento latest version and i have a Custom theme to be installed, and when i install it i get

        Home Page not configured or not found only home page does not work.

        i could find the Home.phtml file in app/design/frontend/base/default/template/cms/default/home.phtm

        Tried configuring in home page in back end also, but i am not able to rectify it.

        I have multiple Language in the magento theme.

        • Subrata Bauri

          You need to check the documentation of the Theme. You must be doing something wrong there. Check the documentation for configuring the home page for that particular theme.

      • mohd amjad

        install theme live hosting but new customer register . error showing is the minimum password length is 6. localserver for same theme is proper working but live hosting password is not accept .

        • Subrata Bauri

          Hi Amjad,
          It’s not totally clear what you wanted to know, but from what I understand, please reinstall your magento in live hosting and check if it is taking the new username and password that you give.

          • mohd amjad

            Dear subrata , I have done that 3times.
            My domain is eventelectric.in
            the error is not with username or taking passwords.
            its during customer registeration where its gives error regarding the length of password inspite of the fact its more than 6character and
            that perfectly run on local host but on web I get this error
            regards,
            amjad

          • Subrata Bauri

            Check if there is any extension related to validating password or Address Validation. If there is please disable them. I would recommend disabling all the custom extensions, clearing the cache and then try.

          • mohd amjad

            I am not be understand regarding disabling custom extensions.
            would it be possible for you to do this on remote support so that I can understand this.
            we can use teamviewer.

          • Subrata Bauri

            Message me the ftp credentials on LinkedIn, here is my profile or email me the credentials. I will check that from home.

          • Subrata Bauri

            Give me your email ID.

          • amit

            hi i found database connection error how can i solve it..?

      • Pooja Vats

        I installed locally magento BUT i cannot login to admin panel!…..version of magento 1.9.2.1 …and not showing error….

  • Taye

    It Working now Sir, Thank you for the guide.

  • Subrata Bauri

    Hello pkch,
    If you install fresh Magento and are not able to LogIn to Admin then it’s a cookie issue. Make sure cookie is enabled in the browser you are trying to access. Check out this blog, http://appseconnect.com/how-to-install-magento-on-wamp-server/
    Download the “Installation problems and solution pdf” in that blog. It have the solution for the cookie issue.
    Let me know if it solves your problem.

    • pkch

      Hi,

      I can not activate curl extension.

      i’m using

      wamp server 2.5
      Apache Version :2.4.9
      PHP Version :5.5.12

      some times it come with an warning indification

      • Subrata Bauri

        “curl” is preloaded and activated in PHP version:5.5.12. Are you trying to reinstall over it? What kind of warning are you getting?

        • pkch

          okay – suddently is activated in the menu – i have do nothing. I was just sitting and work and the email and after you have answer i look in the menu and its look like is activate.

          • pkch

            screen shot after login

          • Subrata Bauri

            Are you getting this after installing a fresh magento on a blank database?

  • pkch

    Hi,

    I have install wamp server and trying to install a demo content.

    I upload all theme files through ftp and after that i upload / import the database that i got from the “themedesigner” from themeforest.

    after the import was succesfuld i change the “web/unsecure/base_url” and “web/secure/base_url”

    but everytime i try to looking in the backend – it point at the themedesigner demo url.

    then i have google and found out that i need to delete the var/cache and var/session files/folders.

    Then i got following pictures:

    Frontend: https://www.dropbox.com/s/xiaj3l7z80d102f/Sk%C3%A6rmbillede%202014-10-17%20kl.%2016.38.33.png?dl=0

    backend: https://www.dropbox.com/s/zlqcujuwzwvjg47/Sk%C3%A6rmbillede%202014-10-18%20kl.%2011.34.46.png?dl=0

    What are i’m doing wrong? i have follow your instruction close.

    Then i have try to install a normal magento project without import database etc. and then i can not login to backend. It come with no error and just forward to the same login page for backend.

    Can you please try to help me?

  • Ketan Benegal

    Hi,

    First of all thanks for the blog. It was very helpful.

    I am facing a weird issue. When I try to login into the admin panel, even after entering the correct username and password, I don’t get past the login screen. Additionally, if I enter wrong credentials, it does show error of wrong username or password entered.

    The access.log file shows the following entries:

    127.0.0.1 – – [16/Oct/2014:10:12:53 -0400] “POST /magento/index.php/admin/index/index/key/e0a1ab8c0a327f0d61e22c4736c29f67/ HTTP/1.1” 302 –

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/index.php/admin/index/index/key/ff39f3852c3e918aa1f4199143c08bc0/ HTTP/1.1” 200 3674

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/js/prototype/prototype.js HTTP/1.1” 304 –

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/js/prototype/validation.js HTTP/1.1” 304 –

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/js/scriptaculous/effects.js HTTP/1.1” 304 –

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/js/mage/adminhtml/form.js HTTP/1.1” 304 –

    127.0.0.1 – – [16/Oct/2014:10:12:54 -0400] “GET /magento/js/mage/captcha.js HTTP/1.1” 304 –

    Please provide some help on resolving this.

    Thanks,
    Ketan

    • Subrata Bauri

      Hello Ketan,
      It’s a cookie issue cookie issue. Make sure cookie is enabled in the browser you are trying to access. Check out this blog, http://appseconnect.com/how-to-install-magento-on-wamp-server/
      Download the “Installation problems and solution pdf” in that blog. It have the solution for the cookie issue.
      Let me know if it solves your problem.

      • Ketan Benegal

        Sorry for the delay in response. Thanks for your response, I was able to resolve the issue.

  • Hi there… I have success fully installed magento in my wamp. But in my backend, even if i entered exact username and password, nothing happens. just reloading the page. But Link has been changing into “http://localhost/magento/index.php/admin/index/index/key/8c755b5343c2330703e97d7d08726a45/”… why is it so? can you help me?

  • Ogunsua Gabriel Oyebode

    Hello Mr Subrata, I am having issues intalling magento, clicking on continue on the configuration page, it displays page of code and in a second redirect to a blank page…How can it solved? Thanks

    • Subrata Bauri

      Can you give a screenshot of the error page showing the code?

      • Ogunsua Gabriel Oyebode

        Done!

        Thanks

        • Ogunsua Gabriel Oyebode

          Hello Mr Subrata, after successfully installing magento. I can’t access log in to my admin page. No error message. What can be done? Thanks

          • Subrata Bauri

            Check out this blog: http://appseconnect.com/how-to-install-magento-on-wamp-server/

            There is a downloadable pdf at the bottom. You will get your solution there.

          • Taye

            Hello Sir, Mr Subrata, I just finish installing magento enterprise edition on my localhost(my computer) i cant login to admin. Please what should i do Sir

          • Subrata Bauri

            Cookie issue. Check out this blog, http://appseconnect.com/how-to-install-prestashop-on-wamp-server-localhost/
            Download the pdf in the blog. It have the solution for cookie issue.
            Let me know if it solves your problem.

          • Subrata Bauri

            It’s a cookie issue cookie issue. Make sure cookie is enabled in the browser you are trying to access. Check out this blog, http://appseconnect.com/how-to-install-magento-on-wamp-server/
            Download the “Installation problems and solution pdf” in that blog. It have the solution for the cookie issue.
            Let me know if it solves your problem.

          • Taye

            Hello Sir, I installed a full theme package of Magento theme i purchased on my localhost which come with a sample database. It giving me errors

          • Subrata Bauri

            Hello Taye,
            What kind of error are you getting?

          • Taye

            Here is the error. I bought a theme gala Supermarket Theme. The theme folder came with a full package, I decided to install the full package, I manage to solve the time exceeded issue, here is the solution.

            What can i do sir

            C:wampaliasphpmyadmin.conf

            Before the line , you can describe what you want :

            php_admin_value upload_max_filesize 128M
            php_admin_value post_max_size 128M
            php_admin_value max_execution_time 360
            php_admin_value max_input_time 360

            I change the Max_execution_time 18000
            max_input_time 18000

          • Subrata Bauri

            Taye,

            You said that the theme comes with a full package. Theme providers always provide full package and theme package separately. Please check that. Then try the following steps.
            1. Install a fresh Magento that is compatible with your theme on a blank database.
            2. After install check if the Magento is running properly or not, if yes then you have nothing to worry.
            3. After that copy only your theme files.
            4. Delete var/cache folder.
            5. Login to Admin and set up the theme.

            This is the cleanest way to install a new theme.
            Let me know how it goes.

          • Taye

            Sir, I need your assistant as Urgent, I have install the magento and the theme i bought. How can the theme show as default. here is the url http://www.buyafrik.com

  • Baffik Abubaker

    @SubrataBauri I’ve been trying to install a theme in Magento for about a week now but it has become impossible for me. I’ve tried to get support for the theme but no reply to my emails to them. I would really appreciate if u helped me.

    • Subrata Bauri

      Hi Baffik,
      If you open up your your Theme directory, you will see it contains some folders like app, skin,js, media, etc. You have to upload those folders and files in the root path of your installed magento. After that, login to your Magento’s Admin and go to System->Design,
      click on Add Design Change button, select your theme from the list and save. You are done.

      • Baffik Abubaker

        @SubrataBauri, thanx for the reply.Am new to Magento, and i followed each and every step that was in the theme documentation. The theme is called Amaze. Here are the installation instructions i followed;

        1. Copy app directory into magento/app directory.
        2. Copy skin directory into magento/skin directory.
        3. Copy js directory into magento/js directory.

        I copied the files as required and described in the documentation to my Magento installation on Wamp Server drectory: c:/wamp/www/magento/
        However after doing all this, the custom theme(amaze) doesn’t appear in the “current configuration scope” which means i can not customize the site accordingly. Please help me.

        • Subrata Bauri

          I hope you have done like the following:

          1. Copy everything inside app directory into magento/app directory.
          2. Copy everything inside skin directory into magento/skin directory.
          3. Copy everything inside js directory into magento/js directory.

          Even after this if you do not see the Theme listed in System->Design->Add Design Change, then you must clear your cache from system->Cache Management. Try it and let me know.

          What do you mean by “current configuration scope”?

          • Baffik Abubaker

            Hullo Subrata, yess this worked for me, thanx. The “Current configuration scope” is in the upper left corner on the configuration page.this where the theme u are configuring is supposed to appear so as to be able to customize the theme.

          • Subrata Bauri

            Great.. Enjoy 🙂

  • Guest

    i install magento successfully . but when i login with user name password then it not goto forward and no any msg display on screen like invalid userid password etc.

    i install 3 times but same problem i have. please tail me what i do?

    • Subrata Bauri

      Cookie issue.
      Open the Varien.php file:
      app/code/core/Mage/Core/Model/Session/Abstract/Varien.php
      and find the following lines of code:
      if (!$cookieParams[‘httponly’]) {
      unset($cookieParams[‘httponly’]);
      if (!$cookieParams[‘secure’]) {
      unset($cookieParams[‘secure’]);
      if (!$cookieParams[‘domain’]) {
      unset($cookieParams[‘domain’]);
      }
      }
      }
      if (isset($cookieParams[‘domain’])) {
      $cookieParams[‘domain’] = $cookie->getDomain();
      }
      Comment those lines and save the file.

      • Nitin

        thanks ,

    • Subrata Bauri

      It’s a cookie issue cookie issue. Make sure cookie is enabled in the browser you are trying to access. Check out this blog, http://appseconnect.com/how-to-install-magento-on-wamp-server/

      Download the “Installation problems and solution pdf” in that blog. It have the solution for the cookie issue.

      Let me know if it solves your problem.

  • Nitin

    i install magento successfully . but when i login with user name password then it not goto forward and no any msg display on screen like invalid userid password etc.
    i install 3 times but same problem i have. please tail me what i do?

    • I think you are facing cookie issue please use another browser or enable cookie in your browser.

  • Nitin

    There has been an error processing your request

    Exception printing is disabled by default for security reasons.

    Error log record number: 1917587558

    what i do?

    • Subrata Bauri

      go to the folder var/report and and find the file with that name. In that file you will find what is the exact error.

  • Nauman

    Good One ! Thanks alot

  • Matthew Caddis

    apache2.4.9\bin\httpd.exe -d C:/wamp/bin/apache/apache2.4.9′

    [Mon Sep 15 10:39:23.026150 2014] [mpm_winnt:notice] [pid 5200:tid 384] AH00418: Parent: Created child process 996

    [Mon Sep 15 10:39:23.397172 2014] [mpm_winnt:notice] [pid 996:tid 308] AH00354: Child: Starting 64 worker threads.

    [Mon Sep 15 10:47:36.441372 2014] [authz_core:error] [pid 996:tid 820] [client 192.168.1.78:3610] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 10:49:06.674533 2014] [authz_core:error] [pid 996:tid 820] [client 192.168.1.78:3613] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 10:49:06.709535 2014] [authz_core:error] [pid 996:tid 820] [client 192.168.1.78:3614] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 10:50:56.326805 2014] [mpm_winnt:notice] [pid 5200:tid 384] AH00422: Parent: Received shutdown signal — Shutting down the server.

    [Mon Sep 15 10:50:58.327919 2014] [mpm_winnt:notice] [pid 996:tid 308] AH00364: Child: All worker threads have exited.

    [Mon Sep 15 10:50:58.345920 2014] [mpm_winnt:notice] [pid 5200:tid 384] AH00430: Parent: Child process 996 exited successfully.

    [Mon Sep 15 10:56:20.911370 2014] [mpm_winnt:notice] [pid 2148:tid 384] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured — resuming normal operations

    [Mon Sep 15 10:56:20.911370 2014] [mpm_winnt:notice] [pid 2148:tid 384] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59

    [Mon Sep 15 10:56:20.911370 2014] [core:notice] [pid 2148:tid 384] AH00094: Command line: ‘c:\wamp\bin\apache\apache2.4.9\bin\httpd.exe -d C:/wamp/bin/apache/apache2.4.9’

    [Mon Sep 15 10:56:20.920371 2014] [mpm_winnt:notice] [pid 2148:tid 384] AH00418: Parent: Created child process 1524

    [Mon Sep 15 10:56:21.290392 2014] [mpm_winnt:notice] [pid 1524:tid 308] AH00354: Child: Starting 64 worker threads.

    [Mon Sep 15 11:04:36.461714 2014] [authz_core:error] [pid 1524:tid 840] [client 192.168.1.78:3622] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 11:04:36.497716 2014] [authz_core:error] [pid 1524:tid 840] [client 192.168.1.78:3623] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 11:06:54.256595 2014] [mpm_winnt:notice] [pid 2148:tid 384] AH00422: Parent: Received shutdown signal — Shutting down the server.

    [Mon Sep 15 11:06:56.256710 2014] [mpm_winnt:notice] [pid 1524:tid 308] AH00364: Child: All worker threads have exited.

    [Mon Sep 15 11:06:56.274711 2014] [mpm_winnt:notice] [pid 2148:tid 384] AH00430: Parent: Child process 1524 exited successfully.

    [Mon Sep 15 11:14:14.329766 2014] [mpm_winnt:notice] [pid 2692:tid 388] AH00455: Apache/2.4.9 (Win64) PHP/5.5.12 configured — resuming normal operations

    [Mon Sep 15 11:14:14.329766 2014] [mpm_winnt:notice] [pid 2692:tid 388] AH00456: Apache Lounge VC11 Server built: Mar 16 2014 12:42:59

    [Mon Sep 15 11:14:14.329766 2014] [core:notice] [pid 2692:tid 388] AH00094: Command line: ‘c:\wamp\bin\apache\apache2.4.9\bin\httpd.exe -d C:/wamp/bin/apache/apache2.4.9’

    [Mon Sep 15 11:14:14.332766 2014] [mpm_winnt:notice] [pid 2692:tid 388] AH00418: Parent: Created child process 2324

    [Mon Sep 15 11:14:14.720789 2014] [mpm_winnt:notice] [pid 2324:tid 308] AH00354: Child: Starting 64 worker threads.

    [Mon Sep 15 11:20:06.577914 2014] [authz_core:error] [pid 2324:tid 848] [client 192.168.1.78:3641] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 11:20:06.612916 2014] [authz_core:error] [pid 2324:tid 848] [client 192.168.1.78:3642] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 11:35:36.584107 2014] [authz_core:error] [pid 2324:tid 848] [client 192.168.1.78:3655] AH01630: client denied by server configuration: C:/wamp/www/

    [Mon Sep 15 11:35:36.618109 2014] [authz_core:error] [pid 2324:tid 848] [client 192.168.1.78:3656] AH01630: client denied by server configuration: C:/wamp/www/

    Here is my error log

  • Matthew Caddis

    Sorry again Discus isn’t working basically, when I click on My projects “Magento” it won’t load the configuration screen. It says the server can’t be found no error codes (I’m using Mozilla Firefox) please help soon!

  • Matthew Caddis

    Sorry for the double post I had to post the image as attachment due to the way Disqus behaves

    • Subrata Bauri

      check the URL.. click on there at the top where only “magento” is shown. Replace it with the following url, http://localhost/magento

      You will be able to access the website.

      • Matthew Caddis

        Thank you you’re awesome!

        • Subrata Bauri

          It’s my pleasure Matthew 🙂

  • Matthew Caddis

    Hello I’m working on implementing Magento 1.9 using WAMP I followed all the methods mentioned in your guide and have looked for the “Mage.php” file and found it. I tried clicking on the Magento in my projects and this screen appears –

  • priyansh

    Hi I am getting an error when i click on “magneto” in Your Projects.
    The error is:
    C:wampwwwmagento/app/Mage.php was not found

    Thank you Subrata Bauri

    • Subrata Bauri

      Go to C:wampwwwmagentoapp and see if there is any Mage.php file. If there is no file of such name, then probably you have not copied magento files properly.

  • Mandar Sant

    when i was installing magento on wamp .so when the configuration page came i have filled all info with reqd field (with ” * “) also then i clicked continue it not step fordwarding so what can i do now

    • Subrata Bauri

      If you give a detail description of the configuration fields then that will be better. A screenshot will also be good. I want to see if you are getting any database connection error or not.

  • Omkar Hendre

    How to import sample data of magento 1.9.0.0 in wamp please tell the way to solve this problem

    • Subrata Bauri

      Create a blank database, select the database and click on the import/export tab on the top. From the import section you can browse and select your downloaded sample data sql file and import it. Also copy the media folder you got with the sample data and copy it your magento root path.

  • abraham

    Need Help

    The URL “http://localhost/magento/” is invalid.
    Response from server isn’t valid.

    • Subrata Bauri

      try once with 127.0.0.1 instead of localhost

      • Qadri Quraishi

        Dear, i have download the magento ver 2.1.2 and after ext erecting i didn’t found any magneto folder.please help i am a beginner

  • abraham

    Cant instal

    • Subrata Bauri

      give 127.0.0.1 instead of localhost and try once.

  • abraham

    Cant instal!

    The URL “http://localhost/magento/” is invalid.
    Response from server isn’t valid.

  • Ragot

    I could not login to admin panel and commented on the parameters as follows

    if (!$cookieParams[‘httponly’]) //cookie parameters

    {

    unset($cookieParams[‘httponly’]);

    if (!$cookieParams[‘secure’])// function to unset cookie parameters

    {

    unset($cookieParams[‘secure’]);

    if (!$cookieParams[‘domain’]) //cookie parameter for the domain

    {

    unset($cookieParams[‘domain’]); // unsetting cookie parameter

    }

    }

    }

    if (isset($cookieParams[‘domain’]))// checking on cookie parameters for the domain

    {

    $cookieParams[‘domain’] = $cookie->getDomain();

    } // getting the domain parameters

    But it is still not working. what could be the problem?

    • Subrata Bauri

      did you get any error when you visited the admin section?

      • Ragot

        No I did not get any error, it loads and back to the same page (login)

        • Subrata Bauri

          Did you delete the “var” folder? Delete it and then try.

  • jessie

    Hi Subrata,
    Thank you very much for sharing this useful article.
    I meet some questions.
    I would like to build 2 websites on local compute. And I do as your instruction, the first one database Magento and it runs ok. I can install this website. Then I try to build another website, and create magento123 folder into WWW directory, and also create database magento123, then I step to install magento123 project, but it didn’t show me the intall page as first Magento, instaed it shows me the finished install page of first magento.

    Do you know what is going on? what can I do?
    Thank you.

    • Subrata Bauri

      Have you copied the files of magento123 from the installed magento? I think you did 🙂
      Open magento123/app/etc and delete local.xml file from there. You will be able to install magento123 after that.

      • jessie

        Wow…it works…
        thank you so much.
        you are awesome.

      • jessie

        Hi Subrata,

        Other question occurred.

        I have successfully installed magento sample data to site magento456. But problem is I can’t open the frontend, however the backend works.
        it shows:
        There has been an error processing your request
        Exception printing is disabled by default for security reasons.
        Error log record number: 1644183648

        Do you know what is going on? How can I do?
        Thank you in advance.

        • jessie

          screenshot of that error data.

          • Subrata Bauri

            Open the database and run the following sql command,
            I am assuming that magento456 is your database name

            SELECT *
            FROM `magento456`.`eav_attribute`
            WHERE (
            `attribute_id` LIKE ‘%stomlayoutupdate%’
            OR `entity_type_id` LIKE ‘%stomlayoutupdate%’
            OR `attribute_code` LIKE ‘%stomlayoutupdate%’
            OR `attribute_model` LIKE ‘%stomlayoutupdate%’
            OR `backend_model` LIKE ‘%stomlayoutupdate%’
            OR `backend_type` LIKE ‘%stomlayoutupdate%’
            OR `backend_table` LIKE ‘%stomlayoutupdate%’
            OR `frontend_model` LIKE ‘%stomlayoutupdate%’
            OR `frontend_input` LIKE ‘%stomlayoutupdate%’
            OR `frontend_label` LIKE ‘%stomlayoutupdate%’
            OR `frontend_class` LIKE ‘%stomlayoutupdate%’
            OR `source_model` LIKE ‘%stomlayoutupdate%’
            OR `is_required` LIKE ‘%stomlayoutupdate%’
            OR `is_user_defined` LIKE ‘%stomlayoutupdate%’
            OR `default_value` LIKE ‘%stomlayoutupdate%’
            OR `is_unique` LIKE ‘%stomlayoutupdate%’
            OR `note` LIKE ‘%stomlayoutupdate%’
            )

            After you run these command, it will show some record. Delete all of them. Let me know if it works.

  • prayag

    pls solve this

    Exception printing is disabled by default for security reasons.

    Error log record number: 1874100497

    • Subrata Bauri

      go to the folder var/report and find the file with that name. In that file you will find what is the exact error.

      • prayag

        Syntax error or access violation: 1067 Invalid default value for period’
        what can i do now??

        • Subrata Bauri

          remove app/etc/local.xml and try re-installing Magento with a blank database.

          • prayag

            There has been an error processing your request

            Exception printing is disabled by default for security reasons.

            Error log record number: 2129163688

            error right now

  • Sanjeev

    Hi. I am Sanjeev. And binger for
    magento. I followed all the steps to magento installation . But I get following errors.

    Internal Server Error

    The server encountered an internal
    error or misconfiguration and was unable to complete your request.

    Please contact the server
    administrator at admin@example.com to inform them of the time this error
    occurred, and the actions you performed just before this error.

    More information about this error
    may be available in the server error log.

    • Subrata Bauri

      Make sure you have configured your php.ini file properly and do not use sample data during installation.

  • Ekta Yadav

    It shows the following error during installation of magento 1.9.0

    There has been an error processing your request
    Exception printing is disabled by default for security reasons.
    Error log record number: 841276381

    please give solution as early you can
    thanks !!

    • Subrata Bauri

      go to the folder var/report and and find the file with that name i.e. 841276381. In that file you will find what is the exact error. Give me the screenshot of that error page.

      • Ekta Yadav

        Please give the solution……..
        screenshot of error………..

        • Subrata Bauri

          Did you open the error file? Go to the folder var/report and and find the file with that name i.e. 841276381. In that file you will find what is the exact error.

          • Ekta Yadav

            Yes I open that file it shows following line coding which i can’t understand ,I paste that lines of coding below:

            a:5:{i:0;s:205:”Error in file: “D:xampphtdocsmagentoappcodecoreMageReportsdatareports_setupdata-install-1.6.0.0.php” – SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY'”;i:1;s:844:”#0 D:xampphtdocsmagentoappcodecoreMageCoreModelResourceSetup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
            #1 D:xampphtdocsmagentoappcodecoreMageCoreModelResourceSetup.php(391): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘data-install’, ”, ‘1.6.0.0’)
            #2 D:xampphtdocsmagentoappcodecoreMageCoreModelResourceSetup.php(289): Mage_Core_Model_Resource_Setup->_installData(‘1.6.0.0’)
            #3 D:xampphtdocsmagentoappcodecoreMageCoreModelResourceSetup.php(269): Mage_Core_Model_Resource_Setup->applyDataUpdates()
            #4 D:xampphtdocsmagentoappcodecoreMageCoreModelApp.php(346): Mage_Core_Model_Resource_Setup::applyAllDataUpdates()
            #5 D:xampphtdocsmagentoappMage.php(640): Mage_Core_Model_App->run(Array)
            #6 D:xampphtdocsmagentoindex.php(80): Mage::run(”, ‘store’)
            #7 {main}”;s:3:”url”;s:44:”/magento/index.php/install/wizard/installDb/”;s:11:”script_name”;s:18:”/magento/index.php”;s:4:”skin”;s:7:”default”;}

          • Subrata Bauri

            Are you using sample data?

          • Ekta Yadav

            yes I am using magento-sample-data-1.9.0.0

          • Subrata Bauri

            Try to install with a blank database and see how it goes.

          • Ekta Yadav

            i’ll install it with many times but it shows error again & again

          • Subrata Bauri

            try installing without using sample data

          • Ekta Yadav

            now its working….can you tell me how to add new theme in magento admin??

          • Subrata Bauri
          • Subrata Bauri

            You need to purchase or get a free theme from MagentoConnect or somewhere else. You will get an installation manual along with any purchased theme.

      • Ekta Yadav

        After seeing the file in error report i can’t understand any thing.there is a lots of line which I can’t understand.

  • Kolpo Kotha

    install magento on localhost wamp server but what is the problem i cant understand. please help me.

    • Subrata Bauri

      go to your installed location and open the directory var/log and find the file with the name same as the number showing in the screen. There you will be able to see the exact error.

      • sonia

        where to check what exact the error is..i m nt getting..completely new to magento so

        a:5:{i:0;s:207:”Error in file: “C:wampwwwmagento3appcodecoreMageSalesRulesqlsalesrule_setupupgrade-1.6.0.0-1.6.0.1.php” – SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘period'”;i:1;s:927:”#0 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
        #1 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(422): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘upgrade’, ‘1.6.0.0’, ‘1.6.0.2’)
        #2 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘1.6.0.2’)
        #3 C:wampwwwmagento3appcodecoreMageCoreModelResourceSetup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
        #4 C:wampwwwmagento3appcodecoreMageCoreModelApp.php(412): Mage_Core_Model_Resource_Setup::applyAllUpdates()
        #5 C:wampwwwmagento3appcodecoreMageCoreModelApp.php(338): Mage_Core_Model_App->_initModules()
        #6 C:wampwwwmagento3appMage.php(649): Mage_Core_Model_App->run(Array)
        #7 C:wampwwwmagento3index.php(87): Mage::run(”, ‘store’)
        #8 {main}”;s:3:”url”;s:45:”/magento3/index.php/install/wizard/installDb/”;s:11:”script_name”;s:19:”/magento3/index.php”;s:4:”skin”;s:7:”default”;}

        this is my error file code..pls suggest me

  • Kripa Shankar Sharma

    sir i have done all steps of installation but after installed the magento when i going to admin account and i type the username and password the admin panel is not shown . only this is shown in my url (localhost/magento 1.8.0.0/magento/index.php/admin/index/key/fe81a1bbf0a80ef5abdb043cc540f66/) …….sir plz help me

  • hamza ahmed

    after creating database when i go for installation ..i get this….page is not loading,,,whats the problem.? help…

    • HELLO ..EXTRACT THOSE FILES ON ROOT OF WWW.

      THIS WOULD REPLACE LOCAL HOST INDEX WITH INSTALLATION INDEX THEN OPEN LOCAL HOST N INSTALL IT

    • Subrata Bauri

      I think magento is your extracted directory. What happens when you click on it?

  • hamza ahmed

    aftrer creating database when i go for installation ..i get this….page is not loading,,,whats the problem.?

  • Thanks.

  • Max

    Thanks Subrata!! Very good job, this tuto is excellent! It was quite easy to install Magento following your steps.

  • asd

    I followed all the steps defined above..but still getting no error but installation is not getting completed in last step

    • Subrata Bauri

      Do not use sample data. Also give the host name as 127.0.0.1 instead of Localhost. Also in the configuration section check the “Skip Base URL Validation”.. try it and let me know if that works for you

  • Rak Sa

    why i cannot login to admin page while my username and password is correct?

    • Subrata Bauri

      cookie issue..

      Open the Varien.php file:
      app/code/core/Mage/Core/Model/Session/Abstract/Varien.php
      and find the following lines of code:

      if (!$cookieParams[‘httponly’]) {
      unset($cookieParams[‘httponly’]);
      if (!$cookieParams[‘secure’]) {
      unset($cookieParams[‘secure’]);
      if (!$cookieParams[‘domain’]) {
      unset($cookieParams[‘domain’]);
      }
      }
      }
      if (isset($cookieParams[‘domain’])) {
      $cookieParams[‘domain’] = $cookie->getDomain();
      }

      Comment those lines and save the file.
      This should resolve your issue.

      (WARNING: This is for test environment only, i.e. if you are doing in Local)

      • Kripa Shankar Sharma

        thank you sir………..it works

  • Muthukumar

    Hi,

    It is an excellent article, we followed it and successfully installed Magento in WAMP on Win8..

    We are facing an issue: It is not allowing us to get into admin control panel. I used the username and password created while configuration, but no errors and not showing anything. If i give wrong password I get an error message.

    What to do now.

    • Subrata Bauri

      Hi Muthukumar,

      Open the Varien.php file:
      app/code/core/Mage/Core/Model/Session/Abstract/Varien.php
      and find the following lines of code:

      if (!$cookieParams[‘httponly’]) {
      unset($cookieParams[‘httponly’]);
      if (!$cookieParams[‘secure’]) {
      unset($cookieParams[‘secure’]);
      if (!$cookieParams[‘domain’]) {
      unset($cookieParams[‘domain’]);
      }
      }
      }
      if (isset($cookieParams[‘domain’])) {
      $cookieParams[‘domain’] = $cookie->getDomain();
      }

      Comment those lines and save the file.
      This should resolve your issue.

      • Muthukumar

        Thanks Subrata Bauri.. It is working fine now..

  • Paparty

    Hi Subrata,

    I really got a problem with installing the whole magento.

    I end up with this parse error.

    Please let me know what to do.

    Thanks and more power.

    • Subrata Bauri

      What parse error? Please attach a screenshot.

    • Subrata Bauri

      What is the Magento version? Are you using sample data?

  • Deep Gupta

    Hi my name is Deepti , I have followed all the steps mentioned above for magento installation on wamp server. But i am unable to login to the backend. I am confident about the username and password i am using. But still i am unable to login to the backend. Can you please tell me what is the problem with the magento login?

    • Subrata Bauri

      Hi Deepti,
      Are you getting any error message?
      Are you accessing the Magento installation using http://localhost or ?
      If you are using http://localhost then change it to

      If that doesn’t help, try the following:
      What browser are you using? It may be a cookie problem. Check with different browsers.
      In your browser allow cookies to be stored.
      Let me know if this works

      • Deep Gupta

        Hi Subrata,
        Yeah ! I was using localhost , But i changed it to but it doesn’t helped me out. As when i type the address instead of localhost it automatically gets converted to localhost… I tried it on chrome and firefox But getting the same problem.

        • Subrata Bauri

          ok.. open the Varien.php file:
          app/code/core/Mage/Core/Model/Session/Abstract/Varien.php
          and find the following lines of code:

          if (!$cookieParams[‘httponly’]) {
          unset($cookieParams[‘httponly’]);
          if (!$cookieParams[‘secure’]) {
          unset($cookieParams[‘secure’]);
          if (!$cookieParams[‘domain’]) {
          unset($cookieParams[‘domain’]);
          }
          }
          }
          if (isset($cookieParams[‘domain’])) {
          $cookieParams[‘domain’] = $cookie->getDomain();
          }

          Comment those lines and save the file.
          This should resolve your issue.

          • Deep Gupta

            Thankyou ! so much Subrata. My problem is solved now. You are a genius. 🙂 Thanku so much

          • Subrata Bauri

            What Pricing Plans ? Do you want to create a custom Page?

            A bit explanation will help.

          • Deep Gupta

            Subrata, Actually m trying to set up a store with magento where i am offering payment gateway services. And each payment gateway will have some pricing plans. when any one clicks on the get in touch button of any pricing plan , a mail will be sent to three people. The one who is clicking on get in touch, Second mail will be sent to me and third mail will be sent to the payment gateway company. So basically I am setting up a store and acting as a dealer between the potential customer and the payment gateway companies like payu , paypal.

            I hope this explanation will help you out so that you can in return help me out ☺

          • Subrata Bauri

            Sounds like a customization to me.. You have to search for any pre-build extension of such kind or customize it yourself.

          • Deep Gupta

            Okay! Thanks for the Help Subrata.

          • Deep Gupta

            Can i ask you for another help, I want to add some pricing plans in my magento homepage. How can i do that. As far as i have read about magento is that , they use xml files. And i don’t know much about xml. Is there any way i can add pricing plans via html

      • Deep Gupta

        Subrata!

        One more thing i want to add to this issue , You were saying it might be a cookie problem. But in my Chrome under the cookie setting
        ” Allow local data to be set (recommended)” Is Checked. This means i have aready allowed the cookies to be stored. Then why i am getting this issue.

  • Chandra Prakash

    Exception printing is disabled by default for security reasons.

    Error log record number: 580601877

  • Chandra Prakash

    Exception printing is disabled by default for security reasons.

    Error log record number: 580601877

    • Subrata Bauri

      go to the folder var/report and and find the file with that name. In that file you will find what is the exact error.

  • Arash Kamangir Irani

    Subrata, I hope you can help me solve my problem:
    I installed magento successfully, I was also successful in migrating a magento installation from another server, but just one problem still exists:
    Magento doesn’t send email! (And with email notifications magento worth nothing).
    I am using Windows 8 and Wamp.

    I’ve tried sendmail but it didn’t work, I could use phpmailer but I don’t know how to integrate it with magento email sending system.
    I hope you can help me solve this problem

    • Subrata Bauri

      Hi Arash,
      Your Magento doesn’t send email from the server or from your local computer?
      You do not have to integrate anything with Magento. Try configuring smtp on wamp first.

      try this: http://keertikiran.blogspot.com.es/2011/05/send-test-emails-with-wampserver.html

      Let me know how it goes.
      cheers!

      • Arash Kamangir Irani

        TNX Subrata,
        This doesn’t work on Windows 8

        Do I need to change magento mail server settings to something not localhost?

  • Viktor

    Well organized sample! Unfortunatelly somehow i stuck at the configuration stage… I gave root access to the database and magento1 database name at this step. I even set config.xml parameters to these default values. And the result of clinking continue is that the same page appears with the same content… Do you have somekind of idea what could it be? I ran the magento-check skript on it and it says that my mysql server out of date and it has to be larger than 4.1.20 (though wamp contains 5.6…). So i dont have a clue right now.

    Tx, in advance 🙂

    • Subrata Bauri

      There is no need to set the config.xml file.
      Is it showing any kind of error when you try to install without changing the config.xml file?

      • Viktor

        Unfortunatelly not… is there somekind of log file somewhere that could contain some error?

        • Subrata Bauri

          Which magento version are you installing?

          • Viktor

            Probably the latest: 1.8.1.0

          • Subrata Bauri

            There is a checkbox at the bottom, Skip base Url validation. Can you select it and give a try?

          • Viktor

            After clicking on Skip base URL and continue the page starts to load endlessly… :/ Hope the screenshot helps.

          • Subrata Bauri

            Great 🙂

          • Viktor

            OK, i give up… 🙂 after the whole thing deployed i tried to log in, but unfortunatelly i couldn’t get in. So i decided to set the encryption key to blank next time. I deleted everything and tried to install it once more… Guess what 🙂 the sql process always fails time after time … At this point mysql4-upgrade-0.9.16-0.9.17… I tried to install older 1.7.0.2 magento as well but that’s even worst in that respect that even after checking the skip base url validation its still returns to the same page…

          • Subrata Bauri

            You said it successfully installed right? If you couldn’t login to admin panel, check if cookies are enabled in your browser.

          • Viktor

            yes, but after the unsuccessful login attempt i deleted the whole thing to try to give a different encription key (because i entered a value there). The cookies are enabled here always.

          • Subrata Bauri

            ok… that’s not supposed to happen. Can you provide the exact error? Also the WAMP configs. Are you using sample data?

          • Viktor

            Solved the issue. The problem occured probably because I used sample datas… After leaving that out it went smoothly. And i solved the login part by uncommenting some part out in the varian.php file inconnection with cookies. For the time being its fine like this. I’m going to use this only for tests anyway. Thank you for your guidance 🙂 “may the force be with you” 🙂

          • Viktor

            Success!! Though I dont know what made it go through… on Wamp it loaded for several minutes and on XAMP after a 1-2 minutes it loaded the next step finally! Thank you for the help! Splendid fast response 🙂

          • Subrata Bauri

            Can you give a screenshot of the Configuration page?

      • Viktor

        I tried to deploye it on XAMPP as well, but to no avail. Same result. 🙁

  • Parag Mehta

    The following image attached mentions the problem faced by me during magento 1.7.0.2 installation. Wamp 2.4 has been installed by me. As mentioned in the previous solutions, I have also tried to resolve the problem by doing away with the port number. I also have made changes to the admin.php file in the Router folder.
    I kindly request you to help me out with the resolution to the problem.

    • Subrata Bauri

      start with a unchanged magento and then try to resolve the errors one by one. Also give 127.0.0.1 as the host name. Try and let me know the outcome

      • Parag Mehta

        Hello,

        I uninstalled magento and wamp 2.4. Also removed IIS. Restarted the machine. Upon installing wamp 2.4 on port 80, it is working absolutely fine.
        Upon installing magento, the first error was pertaining to InnoDB, which was resolved. As per your response, I did the following

        1) HostName : localhost, BaseURL: localhost
        2) HostName : 127.0.0.1, BaseURL: localhost
        3) HostName : 127.0.0.1, BaseURL: 127.0.0.1
        4) HostName : localhost, BaseURL: 127.0.0.1

        The problem still persists and kindly find the same attached.

        Upon executing the following links independently in the browser, the installation screen of Magento appears, which also has been attached.

        1)
        2) http://localhost/magento

        • Subrata Bauri

          Hey Parag,
          During installation at the Database Connection page, you can see the Web Access section below. There you will get a “Skip Base URL Validation Before the Next Step” option, check it and then try to install.

          • Parag Mehta

            Thanks, it worked.

  • thanks Subrata….

    simply, ‘helped’…

    • Subrata Bauri

      You’re welcome!

  • Mishaa

    Hey, Subrata!
    I have followed all the steps before installing magento on my machine’s wamp. but whenever I try to install it through localhost, I get a pop-up saying “Apache HTTP Server stopped working and was closed.”. Please Help!
    Your help would be appreciated.
    Thanks. 🙂

    • Subrata Bauri

      Hey Mishaa,
      Can you tell me the Specs of the Magento, wamp, Apache, MySQL, PHP you are using for installation, i.e. the versions that you are using

      • Mishaa

        Yeah Sure.
        Magento 1.8.1.0
        PHP 5.3.9
        APACHE 2.2.21
        MySQL 5.5.20

        • Subrata Bauri

          Uninstall the WAMP, if you have installed it. Try to download a wamp version which have a PHP version 5.4 or greater. I think you are not able to install WAMP at all, am I right? Also, do you have any other server already installed in your machine?

          • Mishaa

            Actually WAMP is already installed as I have been working with other CMSs also. and with them WAMP is working fine.

          • Subrata Bauri

            So this error occurs while installing Magento in your WAMP? Can you try re-installing Magento using a blank Database and tell me exactly at which step the error occurs?

  • Limonadovy Joe

    Hi, thank you for your tutorial. But I did everythink as you, and I can´t switch to next step after Configuration step. I press continue and it doesn´t do anythink :/

    • Subrata Bauri

      Have you given the correct database credentials ? Go to app/etc folder and rename local.xml and try re-installing Magento, but this time use 127.0.0.1 instead of localhost in the host name.

      • Limonadovy Joe

        Thank you Mr., now it works fine 😉

        • Guest

          I am having the same problem. Tried everything… it just doesn’t works.

          • Subrata Bauri

            The Username and Password you are giving should be Database Username and Password. If you have not created any user in phpMyaAdmin then it should be root by default and password field should be blank.

  • Balraj

    i have done all the things as given above. At last stage on configuration page when i click continue it shows “Database connection error”. Now what should i do?

    • Subrata Bauri

      What is the host name you have given?
      Instead of localhost try it with 127.0.0.1

  • paul

    Well done! easy to follow and complete.

  • Koby Haly

    Hello everyone.

    Im trying to setup Magento on local environment and as far as i know Wamp is suppose to work with Magento just fine.

    I just followed this guide and did setup all the parameters as he did in the guide except one thing, i change the default port from 80 to “8080” as port 80 is used by some other program and that way i was unable to turn the Wamp icon to green,
    So I changed the port with this guide http://blog.xfloyd.net/?p=515 ( i used other port then 81 ( in my case I used 8080 ) )

    all works just fine until i get to the Magento installation process – i cant pass the configuration stage, its just stuck there with ” waiting for 127.0.0.1 ” text on the bottom of the webpage.

    Wamp 2.4 setting:

    Enable curl extension

    Enable Apache rewrite module

    Modify php.ini file :
    max_execution_time = 1500
    max_input_time = 1500

    —–
    phpMyAdmin Page:
    i created a Database named “magento1”
    —–
    C:wampwwwmagento – is my magento folder path
    I wonder if i need to change the magento folder name as the database name (magento1)?
    ————————————————————-

    on the configuration page i filled the boxes in the following way:

    host: localhost:8080
    Database name: magento1
    user name : root
    user password: I leave it blank

    Base URL:
    Admin path: Admin

    When i Hit “Continue” on the configuration page its just got stuck and the page didn’t changed even after I wait for 30 min.

    I’m stuck on this stage for 2 days please help me 🙂 as im a newbie

    *I’m using windows 8
    *I tried with 2 diff ver of magento – 1.7 and 1.8 = same problem
    thanks in advance

    • Subrata Bauri

      Hi Koby,
      Try this, on the configuration page fill the host name as:
      host: localhost
      or
      host: 127.0.0.1
      no need to give the port number there.

      This will resolve your issue.
      Cheers 🙂

      • Koby Haly

        thanks alot 🙂 !!! its worked

        • Subrata Bauri

          great.. enjoy it 🙂

          • Jigyasu Garg

            Hi Subrata,

            I’m facing an issue while installing magento(backup of already running website) on my local system. I’m using XAMPP and changed local.xml after creating database. I have changed core_config_data table also and added localhost/innova(folder name) in that. I m facing two issues which are explained below:-

            A. Without clicking Skip base URL i got message called ”

            The URL “http://localhost/innova/” is not accessible.

            Error parsing body – doesn’t seem to be a chunked message”

            B. When i click on Skip base URL is got processed and i got Admin registration page but then i got another problem when i enter mail id it shows “Only registered domain accounts are allowed.”

            Please help me, i’m really helpless now…

          • Subrata Bauri

            You are facing the issue due to a custom module installed in your magento. It probably doesn’t allow separate domain users to register. That’s why you are getting the error. You have to disable all custom modules from app/etc/modules and then try to install. Remember to delete the var/cache folder.

      • Rahul Tripathi

        dear sir ,
        i am not login in magneto admin panel please help me

  • Ajay Kumar

    Sir I got help by this link.
    Thanks for your help .
    One thing I want to know please let me know what is the basic difference between opencart and magento.

    • Subrata Bauri

      Difference between Magento and OpenCart :-
      Template options in Magento is very extensive than in OpenCart.
      Magento supports multi store handling but OpenCard does not.
      OpenCart is less SEO friendly than Magento.
      Magento has ability to show product comparison and wish list, OpenCart don’t.
      Magento offers wide range of reports for every action but OpenCart offers only sales report.
      OpenCart is more cost effective platform than Magento.

      Similarities between Magento and OpenCard :-
      Both are open source ecommerce platform.
      Both of them have multilingual support.
      Both of them are PHP based.

      • Ajay Kumar

        Sir opencart have also the capability of product comparison and wish list option.

        • Subrata Bauri

          Yes it has. The only plus for opencart is that it is cost effective and is ideal for small size businesses having very low budgets, but if you try to compare features, at present nothing beats Magento.

  • ankit

    sir i installed magento as a process u tell but after insert the information of data base it gives a random error msg like..

    There has been an error processing your request

    Exception printing is disabled by default for security reasons.

    Error log record number: 722053938..

    where is my fault sir..plz help me..

    • Subrata Bauri

      go to the Magento root directory and find the folder named “errors”. Inside it you will find a file named “local.xml.sample” rename it to local.xml
      After renaming try to re-install the Magento again(delete app/etc/local.xml). If any error occurs you will be able to view the error in your browser. You can post the error here if you can’t debug it. I will help you resolve it.
      You can also check the error directly at var/log/722053938..(error log number) file and open it up in an editor to see the error

      • ane

        Hi Subrata, after inserting the information in the database I get this error.
        I have followed the steps you give and I can see that the db has been created. But I don´t know what I am supposed to change

        • Subrata Bauri

          Hi Ane,
          Did you insert the Sample data that is provided by magento i.e.
          magento_sample_data_for_1.6.1.0.sql ? Do not use that sample data on your first installation.

          First try re-installing the Magento on a new blank database.

          Second solution to your problem is removing the file from the core:

          app/code/core/Mage/Customer/sql/customer_setup/upgrade-1.6.0.0-1.6.0.0.1.php and re-install.

          If similar error occurs, you can rename the respective “upgrade ” files and try re-installing.
          Let me know how it goes. Enjoy 🙂

          • ane

            Hi Subrata, I didn´t insert any Sample data, I have just followed the guide, I will let you know how it goes. Thanks!

          • ane

            Hi Subrata, I have re-install it and it is working, (eventhough I tried it yesterday and it wasn´t working) Thank u so much for you guide and quick help =)

          • Subrata Bauri

            Maybe due to some caching issue it wasn’t working yesterday. But great to know that re-installing worked.

  • Pratik Basak

    hats off to you..it was real a-z of how to install and setup magento in wamp server..thank you very much 🙂 keep up this good work

    • Subrata Bauri

      Thanks for the appreciation 🙂

  • Abdur Rahman

    very help full, save lot of time, i configure it first time without any issue, thanks to this post.

    • Subrata Bauri

      awesome 🙂

  • karthik

    And One more problem in magento admin panel. How to upload “bulk products”?

    • Subrata Bauri

      for bulk products import you can use the Magento “Import/Export” functionality under “System” menu. First create some demo products in the admin and export it in CSV format, thus you will get the format of the CSV. Now you can fill up the CSV with your product data’s and import as many products as you want. Cheers 🙂

  • karthik

    Hi Subrata. Now i am working in magento live server. It shows some error like Fatel Error.I Installed Buy Shop theme in my server. Find the image i attached.Reply me with clear steps

    • Subrata Bauri

      Did you get the error after installing the theme ?

      • karthik

        Yes Sir., But now its working welll:)

        Thank you:)

    • karthik

      Sir,
      Sorry For Disturbing. Now its working. Some errors in magentodemo database file. now its working clearly.

      Thank you.:)

  • Rajneesh Singh

    This webpage is not available
    This error has been occur after downloading process

    • Subrata Bauri

      Can you please make it clear. What is the problem you are facing?
      Were you not able to download Magento or WAMP ?

      • Rajneesh Singh

        I have download everything i.e wamp and mageneto1.7.

        I got a problem after

        Welcome

        Validation

        Magento Connect Manager Deployment

        Download

        after that next process not going on and give errror
        This webpage is not available

        License Agreement

        Localization

        Configuration

        Create Admin Account

        You’re All Set!

        • Subrata Bauri

          Let me rephrase it. Whenever you click on the Magento folder in the WAMP dashboard it’s showing “This webpage is not available”, am I right ? Make sure you did all the server settings properly. Also clear all browser cache and try re-installing Magento.

          • Rajneesh Singh

            ya you are right.
            I am trying to do every thing but this problem will be not resolved.

          • Subrata Bauri

            which WAMP version are you using ?

            Is it 64bit or 32bit ?

            If it’s 64bit then remove it and try installing the latest 32bit WAMP(will not be a problem if your machine is 64bit)

            Let me know the php version, if it’s 5.3.1 then that might be the reason. Make sure the PHP version is 5.4.x

  • Subrata Bauri

    The problem is not with WAMP version but the php version that is shipped with it. About the PHP vesion, anything with 5.4.x is good enough.

  • Joe

    Do you have a separate post that covers taking a magento site to a live server from your local host? If not, do you know where I can find detailed steps for doing this (for someone not familiar with SSH)?

    • Subrata Bauri

      Right now I don’t have any post regarding that.
      You don’t need SSH knowledge for this( unless you are using a very large database).
      You will need to do the following,
      copy all of your local files to production(live) server
      dump your magento local db and import it into your production server db
      delete the app/etc/local.xml file
      delete var/cache folder
      re-install magento
      from the magento Admin, reindex everything.
      That’s all. I hope you know about domain configuration in server side. Cheers 🙂

  • Aq Amra

    Hi,

    thanks for the help, i did all of the above and it worked, but now i cant login to the backend.

    it loads the “Log in to Admin Panel” window, but when i enter the correct username and password it keeps loading the same window.

    any ideas?

    • Subrata Bauri

      This type of error occurs due to browser cookies.Check if your browser have cookies enabled. If it’s not you should enable it. Also go to the root directory of your installed Magento and find the folder var/cache, delete the cache folder. This should resolve your problem.

  • vin ay

    i dont knw why but the continue button get’s freezed every time i try to install. i changed execution time, memory limit and input time.
    Some time i reach till configuration page and continue button gets freezed ther?? What to do?

    • Subrata Bauri

      open your browser debugger and try to find the error that magento is throwing. That will give a much better insight into the problem.

  • Mark

    Hi, great article, I’m trying to install magento 1.7.0.2 on WAMP 2.4, I get to the configuration page and it just keeps reloading the page when I hit continue. I’m entering host as localhost, username as root and then the password I used. Any help much appreciated?

    Thanks

    Mark

    • Mark

      When I change and use 127.0.0.1 rather than localhost, I get the following error:
      Database server does not support the InnoDB storage engine.
      I tried following your comments below to fix this but after updating the my.ini file as below MySQL wouldn’t start?

      Thanks

      Mark

      • Subrata Bauri

        Try the following:
        Undo the my.ini changes( if you are sure you have given the directory paths correctly), then you have to do some modification in the Magento file:

        Around line 60 of the Magento file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

        you can find this function

        public function supportEngine()
        {
        $variables = $this->_getConnection()->fetchPairs(‘SHOW VARIABLES’);
        return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;
        }

        replace it with the following code

        public function supportEngine()
        {
        $variables = $this->_getConnection()->fetchPairs(‘SHOW ENGINES’);
        return (isset($variables[‘InnoDB’]) && $variables[‘InnoDB’] != ‘NO’);
        }

        Save the file and re-install Magento.
        This will resolve your issue.

        • Mark

          Thanks a million Subrata, eventually got it working. I think my browser was holding onto something. After trying for hours, shutting my browser down and trying again worked!

          • Subrata Bauri

            Yes, browser cache sometimes causes pain, you will face it a lot while working with Magento. Always remember one thing, if you have made some changes and flushed the Magento cache and still can’t see it in your site, it’s probably the browser cache playing the villain, so always try to clear the browser cache once in a while. Enjoy 🙂

  • heshamshabana

    I’m configuring wamp to run on port 8080, when i open the configuration page after i fill all the required fields as above the page just refresh and nothing happen, i created the database on mysql with the default configuration and mysql running on port 3306 please advise

    • Subrata Bauri

      Assuming that you are giving the right configuration data in the fields.. I would recommend to check the page response in the console of the browser debugging tool(I use Firebug). Check if you get any error from Magento side, otherwise it’s a configuration issue. Let me know if you get any..

      • heshamshabana

        Thank you for your replay, however, i found that i’m using localhost and i should user 127.0.0.1 in the URL, but i faced another error innoDB is not supported

        • Subrata Bauri

          I have already replied the solution to the innoDB not supported error in another comment,check it out and let me know if it solves your problem.

          • Subrata Bauri

            Try this solution. Actually the Magento installation code was written for older version of MySQL. From MySQL 5.6 the have_innodb variable is removed and that’s what causes the error.

            Around line 60 of the Magento file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

            you can find this function

            public function supportEngine()
            {
            $variables = $this->_getConnection()->fetchPairs(‘SHOW VARIABLES’);
            return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;
            }

            replace it with the following code

            public function supportEngine()
            {
            $variables = $this->_getConnection()->fetchPairs(‘SHOW ENGINES’);
            return (isset($variables[‘InnoDB’]) && $variables[‘InnoDB’] != ‘NO’);
            }

            Save the file and re-install Magento.
            This will resolve your issue.

  • Anit

    Hi,

    I have wamp server version 2.2 and i tried to install magento 1.7, but when i come to the point to open the index page of the magento installation on localhost: localhost/magento, i get the page error, ‘server not found’.

    Other directories on wamp are working fine.

    Do you know what could be the problem here?

    • Anit

      Already found out the solution. If someone has the same issue:

      in the file C:wampwwwmagentoappcodecoreMageCoreControllerVarienRouter
      folder open Admin.php and find _shouldBeSecure function and redefine it, you just comment everything after return, so it should stay just:

      protected function _shouldBeSecure($path)
      {
      return

      /*substr((string)Mage::getConfig()->getNode(‘default/web/unsecure/base_url’), 0, 5) === ‘https’
      || Mage::getStoreConfigFlag(‘web/secure/use_in_adminhtml’, Mage_Core_Model_App::ADMIN_STORE_ID)
      && substr((string)Mage::getConfig()->getNode(‘default/web/secure/base_url’), 0, 5) === ‘https’*/

      ;
      }

      • umesh dhawan

        Thanks for sharing the solution..it helped me.

      • eason

        it’s very helpful for me !thanks very much.

    • Subrata Bauri

      Can you be more specific about the error, what are the options you chose during installation? I would like to dig a bit to know the reason of the error.

  • Anit

    Hi, on Magento web site it says: Magento 1.7 does not work with WAMP 2.2. You may use WAMP 2.1. (source: http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/installing_on_windows_with_xampp_and_wamp)

    Is this true? I have WAMP 2.2 and downloaded Magento 1.7, but I don’t know if it’s ok to even start the installation? Do you know something about that?

  • MiráCle Aññgel

    thanks a lot, you really helped me. Hats off to u sir

    • Subrata Bauri

      you’re welcome… Glad it was helpful for you 🙂

  • saravanan

    Thank You..

    • Subrata Bauri

      you’re welcome 🙂

  • saravanan

    In Configuration settings it showing this error “Database server does not support the InnoDB storage engine.”

    • Subrata Bauri

      WAMP Server comes with innodb disabled.
      Click on the green WAMP icon then MySQL->my.ini
      Find the following lines:

      # Uncomment the following if you are using InnoDB tables
      #innodb_data_home_dir = C:mysqldata/
      #innodb_data_file_path = ibdata1:10M:autoextend
      #innodb_log_group_home_dir = C:mysqldata/
      #innodb_log_arch_dir = C:mysqldata/
      # You can set .._buffer_pool_size up to 50 – 80 %
      # of RAM but beware of setting memory usage too high
      #innodb_buffer_pool_size = 16M
      #innodb_additional_mem_pool_size = 2M
      # Set .._log_file_size to 25 % of buffer pool size
      #innodb_log_file_size = 5M
      #innodb_log_buffer_size = 8M
      #innodb_flush_log_at_trx_commit = 1
      #innodb_lock_wait_timeout = 50

      and replace it with the following:

      # Uncomment the following if you are using InnoDB tables
      innodb_data_home_dir = C:mysqldata/
      innodb_data_file_path = ibdata1:10M:autoextend
      innodb_log_group_home_dir = C:mysqldata/
      innodb_log_arch_dir = C:mysqldata/
      # You can set .._buffer_pool_size up to 50 – 80 %
      # of RAM but beware of setting memory usage too high
      innodb_buffer_pool_size = 16M
      innodb_additional_mem_pool_size = 2M
      # Set .._log_file_size to 25 % of buffer pool size
      innodb_log_file_size = 5M
      innodb_log_buffer_size = 8M
      innodb_flush_log_at_trx_commit = 1
      innodb_lock_wait_timeout = 50

      This should resolve your issue
      cheers !

      • karthik

        Hi sir,
        i get some error in php_curl extension activation.if i got activated again it will shows ‘please activate “php_curl” extension’. What will do sir.

        • Subrata Bauri

          Did you follow these steps ?

          http://www.insync.co.in/how-to-install-magento-on-wamp-server-localhost-localcomputer/#curl

          You have to restart WAMP server after you enable it.

          • karthik

            Thank You Sir,
            It’s Working.
            Now tell me, In magento how to insert sample data in admin panel.Send me all the steps clearly.

          • Subrata Bauri

            You can dowload the Magento user guide from the following link
            http://www.magentocommerce.com/resources/user-guide-download

            It contains all the information you need.
            cheers 🙂

          • karthik

            Now its working well.Thank you very much..:)

          • Subrata Bauri

            Awesome 🙂

          • Subrata Bauri

            Awesome 🙂

          • karthik

            Thank You Sir,
            Now its Working..

          • karthik

            Sir,
            It shows “404 error” in magento admin panel…. Tell me what type of error is that.?

          • karthik

            While we choosing the theme layout it shows like this.?

          • Subrata Bauri

            Did you solve the 404 error ? Try logging out from the admin and then Log In again. Let me know if it works.

  • Kunal Mehta

    Hats off to you Mr. Subrata….thums up..!!

    • Kunal Mehta

      You make my problems to an end ..after two days hard work…coding is much tough thing for an commerce guy like me…!! you helped me..!

      • Subrata Bauri

        Thank you very much. Glad that this post helped you 🙂

  • Satish Malhotra

    I followed all the steps defined above..but still getting no error but installation is not getting completed even after 1 hr.

    • Subrata Bauri

      I can see from the screenshot that you have given the database name capitalized. MySQL database name can not be capitalized. Please go to your phpMyAdmin and check it.
      Give the Host as only “localhost” even if you are using 8090 as your port.
      That will set up your database connection.
      Feel free to comment if you get any other error.

      Cheers!

  • asdf

    Database server does not support the InnoDB storage engine.
    The above error comes in the Configuration settings page while installing magento

    • Subrata Bauri

      Around line 60 of the Magento file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

      you can find this function

      public function supportEngine()
      {
      $variables = $this->_getConnection()->fetchPairs(‘SHOW VARIABLES’);
      return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;
      }

      replace it with the following code

      public function supportEngine()
      {
      $variables = $this->_getConnection()->fetchPairs(‘SHOW ENGINES’);
      return (isset($variables[‘InnoDB’]) && $variables[‘InnoDB’] != ‘NO’);
      }

      This will resolve your issue.

      • Faiz

        Did somebody tell you that you are dude? thanks a ton bro. Applied the above steps and it solved my problem.

        • Subrata Bauri

          great to know that.. cheers 🙂

          • Omkar Hendre

            hello sir will you please help me to restore the sample data of magento 1.9.0.0 in wamp on windows machine i tried but not getting success

          • Hi @disqus_oDZ8NXO9mc:disqus, Thanks for reading our post.

            may I know what data you want to import ?

      • Kattia Ninahuanca

        great that work perfectly

      • prayag

        C:wampwwwmagentoappcodecoreMageSalesRulesqlsalesrule_setupupgrade-1.6.0. error occcur