Magento 2 – bin/magento setup:upgrade Not Running

clidatabaseerrormagento2

I am facing a long lasting issue on this command

bin/magento setup:upgrade

I have made an extension hello world on magento2 stable version, which will simply print hello world on screen.

The thing is when I ran that….it gave me setup version, not specified error (though I have specified)…then I searched & ran this command –

bin/magento setup:upgrade

When I ran above command then I met with another error….pdo_mysql is not installed….

Then I solved that error with the following commands:
sudo apt-get install php5-mysql
sudo apt-get install pdo-mysql

then by doing php -m I could see the pdo_mysql in extensions list 🙂

But then as ran that command (bin/magento setup:upgrade) again….I got another error (very frustrated). Please check the attachment.

For solving that error I referred this one…. https://stackoverflow.com/questions/11990708/error-cant-connect-to-local-mysql-server-through-socket-var-run-mysqld-mysq

I typed this: sudo find / -type s
so I got the list in that one of the line is like this……
/opt/lampp/var/mysql/mysql.sock

now in that article, it says……"Once you find where the socket is being opened, add or edit the line to your /etc/my.cnf file with the path to the socket file"………so I opened /etc/my.cnf but….I found that the line is already there…..socket = /opt/lampp/var/mysql/mysql.sock

Then it says to run this : kill -9 4969 or pkill -9 mysqld but I did not run…I am afraid it can cause damage to xampp…

Then it says….."After you do this you might want to look for a pid file in /var/run/mysqld/ and delete it" but the thing is I can not find mysqld folder inside var/run/ so I am confused what to do now….

Many times I restarted xampp by first stopping apache like this:
sudo /etc/init.d/apache2 stop

But could not resolve the issue…

Can anyone please give the correct solution?

Magento 2 becomes a big problem running in Ubuntu for me 🙂

Best Answer

search mysqld.sock you can search it using command : find -name "mysqld.sock" then right click on it and copy link then paste it under /var/run/mysqld/ and rename it to mysqld.sock if there is no directory name "mysqld" in /var/run/ then create it

Related Solutions

Magento – First module HelloWorld in Magento 2.0 doesn’t work

Follow bellow steps

Step : 1 (module.xml) app/code/Ccc/HelloWorld/etc/module.xml

<?xml version="1.0"?>
 <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/Module/etc/module.xsd">
    <module name="Ccc_HelloWorld" setup_version="1.0.1">
    </module>
</config>

Step : 2 (routes.xml) app/code/Ccc/HelloWorld/etc/frontend/routes.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../lib/internal/Magento/Framework/App/etc/routes.xsd">
<router id="standard">
    <route id="helloworld" frontName="helloworld">
        <module name="Ccc_HelloWorld" />
    </route>
</router>
</config>

Step : 3 (registration.php) app/code/Ccc/HelloWorld/registration.php

<?php
\Magento\Framework\Component\ComponentRegistrar::register(
    \Magento\Framework\Component\ComponentRegistrar::MODULE,
    'Ccc_HelloWorld',
    __DIR__
);

Step : 4 (Index.php) app/code/Ccc/HelloWorld/Controller/Index/Index.php

<?php 
namespace Ccc\HelloWorld\Controller\Index;

use Magento\Framework\View\Result\PageFactory;

class Index extends \Magento\Framework\App\Action\Action
{
    protected $resultPageFactory;
    /**      * @param \Magento\Framework\App\Action\Context $context      */
    public function __construct(\Magento\Framework\App\Action\Context $context,PageFactory $resultPageFactory)     
    {
        $this->resultPageFactory = $resultPageFactory;
        parent::__construct($context);
    }

    public function execute()
    {
        $resultPage = $this->resultPageFactory->create();
        $resultPage->getConfig()->getTitle()->prepend(__('Hello World'));
        return $resultPage;        
    }
}

Step : 5 (HelloWorld.php) app/code/Ccc/HelloWorld/Block/HelloWorld.php

<?php
namespace Ccc\HelloWorld\Block;

class HelloWorld extends \Magento\Framework\View\Element\Template
{
    public function _prepareLayout()
    {  
        return parent::_prepareLayout();
    }
}

Step : 6 (helloworld_index_index.xml) app/code/Ccc/HelloWorld/view/frontend/layout/helloworld_index_index.xml

<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="1column" xsi:noNamespaceSchemaLocation="../../../../../../../lib/internal/Magento/Framework/View/Layout/etc/page_configuration.xsd">
    <body>
        <referenceContainer name="content">
            <block class="Ccc\HelloWorld\Block\HelloWorld" name="helloworld" template="helloworld.phtml">
            </block>
        </referenceContainer>
    </body>
</page>

Step : 7 (helloworld.phtml) app/code/Ccc/HelloWorld/view/frontend/templates/helloworld.phtml

<?php 
echo 'Successful! This is a simple module in Magento 2.0';
?>

Step : 8 (rerun magento setup - this will re-generate app/etc/config.php & enable the module)

php-cli bin/magento setup:upgrade

I also flush the cache of the admin panel.

Magento 2.0.2 CE – CLI Commands Not Working After Upgrading to PHP 7

what is the output of:

ls -l $(which php)

For me this is showing:

/usr/bin/php -> /etc/alternatives/php

Also check the output of this:

echo $PATH

And look for any path to the wrong php, maybe you only need to fix the $PATH.

If this is not working try this to reinstall the whole package, overwriting the original files:

sudo apt-get install --reinstall php7.0-cli

Best Answer

Related Solutions

Magento – First module HelloWorld in Magento 2.0 doesn’t work

Magento 2.0.2 CE – CLI Commands Not Working After Upgrading to PHP 7

Related Topic