Yii2 Gii – Table Update

ALTER TABLE `tablename`
  ADD `lock` int(5) NOT NULL,
  ADD `created_at` date DEFAULT NULL,
  ADD `created_by` int(11) NOT NULL DEFAULT 0,
  ADD `deleted_by` int(11) NOT NULL DEFAULT 0,
  ADD `deleted_at` date DEFAULT NULL,
  ADD `updated_at` date DEFAULT NULL,
  ADD `updated_by` int(11) NOT NULL DEFAULT 0
  AFTER branch_status;

Magento Set the File permission

Magento Set the File permission (you need to be root/ sudo)

sudo find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \; && sudo find var vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \; && sudo chown -R www-data:www-data . && sudo chmod u+x bin/magento

With the path:
cd /var/www/html/magento2 && find var generated vendor pub/static pub/media app/etc -type f -exec chmod u+w {} + && find var generated vendor pub/static pub/media app/etc -type d -exec chmod u+w {} + && chmod u+x bin/magento

Ubuntu 14.04 – PHP Version Upgraded

php -v

Shows:

PHP 5.6.25-2+deb.sury.org~trusty+1 (cli)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologiescode

In the page the php code phpinfo();

phpinfo();

Shows:
PHP Version 5.5.9-1ubuntu4.19

Now to correct this you need to:

sudo a2dismod php5
sudo a2enmod php5.6
sudo service apache2 restart

Cheers

Zip and UnZip with FTP

Find here the PHP script, just upload.

 

  • Upload zipCF.php on the directory which you want to make zip file
  • Open zipCF.php with your browser
  • Provide a Name for the zip file
  • Click on Create Zip file
  • It will create the zip file if everything is ok and provide a success message just below the submit button
  • If you see the success message, go to ftp client or browse direct url to zip file from your browser
  • Download the newly created zip file
  • Use it anyhow you need
  • Delete zipCF.php file from your server to avoid security issues

 

How to Fix Drop Down Menu not Working on iPad


jQuery(document).ready(function($){

    if((navigator.userAgent.match(/iPhone/i)) || (navigator.userAgent.match(/iPod/i)) || (navigator.userAgent.match(/iPad/i))) {
     $(".main-navigation li:has(ul) > a").bind('touchstart',function(e){

        e.stopPropagation();
    	e.preventDefault();

		if($(this).hasClass("oneTouch")){
  			$(this).removeClass("oneTouch");
  			window.location = $(this).attr("href");
  		}
		else{
			$(this).addClass("oneTouch");
		}

     });
    }

});

» Read more