lionrajkumar

C:\Program Files\Oracle\VirtualBox>vboxmanage.exe modifymedium "E:\vms\Win XP.vdi" --resize 30999

lionrajkumar

git config credential.helper store

lionrajkumar

Public Function UpdatePricesValues(Rg As Range, Sp As Range) As String
    Dim tempStr As String
    Dim strOrgTxt As String
    Dim singlePcsPrice As String
    Dim splitOrStrArray() As String
    Dim splitCamaStrArray() As String
    Dim getQty As String
    Dim currentPriceVal As String
    Dim pos As Integer

lionrajkumar

-- Set up variable to delete ALL tables starting with 'temp_'
SET GROUP_CONCAT_MAX_LEN=10000;
SET @tbls = (SELECT GROUP_CONCAT(TABLE_NAME)
               FROM information_schema.TABLES
              WHERE TABLE_SCHEMA = 'temp_migrate' //Database
                AND TABLE_NAME LIKE 'mdltest_%'); //prefix
SET @delStmt = CONCAT('DROP TABLE ',  @tbls);
-- SELECT @delStmt;
PREPARE stmt FROM @delStmt;
EXECUTE stmt;

lionrajkumar

rm -rf *

lionrajkumar

"composer install" OR "composer update"
php artisan cache:clear
composer dump-autoload
php artisan key:generate

lionrajkumar

[PHP.ini]
max_input_vars line #385 on /etc/php/7.0/apache2/php.ini
max_execution_time=5000
memory_limit = 1280M #389
post_max_size = 128M #656
upload_max_filesize = 1024M #809

lionrajkumar

/etc/sonarqube/bin/linux-x86-64/sonar.sh console
/etc/sonar-scanner/bin/sonar-scanner

lionrajkumar

free -h
echo 3 > /proc/sys/vm/drop_caches && swapoff -a && swapon -a
free -h

lionrajkumar

rm -rf pub/static/*
rm -rf var/view_preprocessed/*
php bin/magento cache:clean
php bin/magento cache:flush 

php bin/magento setup:upgrade
php bin/magento deploy:mode:set production -s
rm -rf var/di
php bin/magento setup:di:compile
php bin/magento indexer:reindex