Full-Sized Screenshot in Chrome

Open Chrome and head to the web page you want to capture. Once there, click the three dots, point to “More Tools,” then click on “Developer Tools.”
Alternatively, you can press Ctrl+Shift+I on Windows or Command+Shift+I on Mac to open the Developer Tools pane.

In the top right corner of the pane, click the three dots icon, then click “Run Command.” Alternatively, press Ctrl+Shift+P on Windows and Command+Shift+P on Mac.

In the command line, type “Screenshot,” then click “Capture full-size screenshot” from the list of commands available.

The image should save automatically, but if you’re prompted to save the screenshot, select a destination on your computer, then click “Save.”

Work around Update NodeJS in Plesk

Prblem no vesrion 10 available in Plesk yet (jan 19)

Enable Node support in Plesk Onyx:

Install the “Node support” simply from your “update and updates” Plesk interface.
Go to your “Node extension” page enable/disable the node versions you need
In case you need additional node versions which does not come with the default node support installation:

Install the Node Version Manager on your server
Install the versions you need e.g. nvm install v10.15.1
Copy paste the node version to plesk cp -R ~/.nvm/versions/node/v10.15.1/ /opt/plesk/node/
Then notify your plesk about your installation plesk sbin nodemng register /opt/plesk/node/v10.15.1/bin/node
Go to your node extension page where all node versions are listed, hit refresh and see

How do I add Azure Active Directory User to Local Administrators Group

You can do this via command line!(IT WORKED!!)

Login to the PC as the Azure AD user you want to be a local admin. This gets the GUID onto the PC.

Log out as that user and login as a local admin user.

Open a command prompt as Administrator and using the command line, add the user to the administrators group. As an example, if I had a user called John Doe, the command would be “net localgroup administrators AzureAD\JohnDoe /add” without the quotes.

Log back in as the user and they will be a local admin now.

Magento 2.x – Required parameter ‘theme_dir’ was not passed (SOLVED)

To solve the issue, you should check in your project design folder (app/design/frontend), and find which difference you have with your database settings.

To get the database installed themes you should do:

select * from theme;

add the corresponding missing directories, or remove them from the theme database table.

Clean cache, and the error should be solved.

Magento: Removing Billing Agreements, Recurring Profiles & My Applications links

Magento: Removing Billing Agreements, Recurring Profiles & My Applications links from customer account.

 

Step 1: Go to ( yourPackage/YourTemplate/customer/account/navigation.phtml )

Step 2: Replace the below line

<?php $count = count($links); ?>

**With**

<?php $_count = count($_links); /* Add or Remove Account Left Navigation Links Here -*/
unset($_links['account']); /* Account Info */
unset($_links['account_edit']); /* Account Info */
unset($_links['tags']); /* My Tags */
unset($_links['reviews']);  /* Reviews */
unset($_links['wishlist']); /* Wishlist */
unset($_links['newsletter']); /* Newsletter */
unset($_links['orders']); /* My Orders */
unset($_links['address_book']); /* Address */
unset($_links['OAuth Customer Tokens']); /* My Applications */
unset($_links['downloadable_products']); /* My Downloadable Products */
unset($_links['recurring_profiles']); /* Recurring Profiles */
unset($_links['billing_agreements']); /* Billing Agreements */

?>

Available qyt on the cart page in Magento 1

For the available qyt on the cart page use below code;


	   	<!-- start available qty to product in app\design\frontend\ultimo\colorfabb\template\checkout\cart\item\default.phtml-->
        < ?php

		$productId = $_item->getProductId();
		$product = Mage::getModel('catalog/product')->load($productId);
		if($product->getTypeId() == "configurable"){
			$sku = $_item->getSku();
			$simpProdId = Mage::getModel('catalog/product')->loadByAttribute('sku',$sku)->getId();
			$product = Mage::getModel('catalog/product')->load($simpProdId);
		}

		$quantity = Mage::getModel('cataloginventory/stock_item')->loadByProduct($product)->getQty();
		?>
		<span style="font-weight: bold;color:#ff0000;">Available qty:< ?php echo (int) $quantity;?></span>
		
		<!-- einde available qty to product -->

Upgrade Magento 1 Via SSH

Upgrading Magento via SSH is usually much simpler than via the magento downloader. To upgrade follow these simple steps.

1. First backup. Download a copy of your database, and backup your files. You can make a zip of them.

2. Set the permissions for mage:
chmod +x mage

3. Run mage-setup and sync:
./mage mage-setup .
./mage sync

4. Upgrade Magento:
./mage upgrade-all --force

If that doesn’t work, try:
./mage install http://connect20.magentocommerce.com/community Mage_All_Latest --force

5. It’s always a good idea to run the indexer and clear the cache:
php shell/indexer.php reindexall
rm -rf downloader/.cache/ var/cache/

You’re all done (as long as there were no errors.

 

Error:

/mage mage-setup .

I receive:

Running initial setup…

Success

Success

Error:

channel-add: Channel ‘community’ already exist!

Do:

in the magento directory :

./mage channel-delete community

./mage mage-setup

Then add the extension again via magento connect

and

Go to “downloader” folder and delete the file “cache.cfg”. Then go back to Magento Connect and retry

Install Webmin on CentOS 7

INSTALL WEBMIN

To get started, login your remote server and follow the steps below:

First, create a new file webmin.repo in /etc/yum.repos.d/ :

vi /etc/yum.repos.d/webmin.repo

and paste below line:

[Webmin]
name=Webmin Distribution Neutral
#baseurl=http://download.webmin.com/download/yum
mirrorlist=http://download.webmin.com/download/yum/mirrorlist
enabled=1

Install webmin GPG key using below command.

rpm --import http://www.webmin.com/jcameron-key.asc

Now, update the repositorys:

yum check-update

Install webmin:

yum install webmin -y

Start the service and make it start automatically

chkconfig webmin on
service webmin start

By default, Webmin will listen on port 10000. Enable webmin Port:

firewall-cmd --add-port=10000/tcp

Now, open http://ip.add.re.ss:10000 in your browser and enter yor root username and password

 

SETTING UP WEBSITES IN WEBMIN

Let’s login to webmin.

This can be done from http://yourserverIP:10000 or https://yourserverIP:10000 (add a security exception)

First create a directory for each site.

Let’s create the folder with the website domain name.

From webmin is pretty fast. Just go to: Others/File Manager (This require java in your browser) and create the folder under /var/www/html using the “yourdomain.com” .
ex.

mkdir -p /var/www/html/yourdomain.com

Once you have the folder created. Go to Servers/Apache Web Server (please make sure you “Start Apache” at the top right corner) and click on the tab named “Create Virtual Host”.

– You can leave it at “Any address” for now.

 – Leave the next boxes checked.

 – Set the port number to 80.

 – In “Document  Root” click on the button at the right of the box and it will open a pop up windows for you to browse the server’s folders. Make sure you browse to /var/www and the folder you created. Click OK to return to the “Create Virtual Host” screen and there you must see the path to the folder you created for this website.

 – Check “Allow access to this directory”

 – Set the server Name to the domain you are creating this host to without the “www”

 – Add virtual server to file. Leave it on “New file under…”.

 – Click on “Create Now”

 It the Virtual Host has been created then we need to make a little more changes to finish this.

Click on the Virtual Host you just created. This will open the “Virtual Server Options page.

Click on “Edit Directives” and under the line “ServerName yourdomain.com”, insert a line that says the following:

ServerAlias www.yourdomain.com

This is an example of how this file must be:

“DocumentRoot /var/www/yourdomain.com
ServerName yourdomain.com
<Directory /var/www/yourdomain.com>
allow from all
Options +Indexes
</Directory>”

You will be taken back to the “Virtual Server Options page”

At the top right corner click on “Apply Changes”.

SETTING UP DNS USING WEBMIN

Go to Servers, and then click on “BIND DNS Server”. If you can’t see it then it needs to be installed .

Start BIND by clicking at the top right option on your browser.

Creating a Master Zone.
1) Click on “Create master zone”
2) Enter the domain without the www into the “Domain name / network” box.
3) For the master server, type in the domain name as well.
4) You can check the “Create NS record” box if you’d like.
5) Enter your email address in the appropriate box.
6) Type in the IP address of the server (The external IP address provided by your ISP).
7) Click “Create”

Creating A records.
1) Click on “Address”
2) Leave the name field blank, and type in the IP address.
3) Click Save.
(The following is dependent on what you want to run the server for.)
4) Type in www for the name, and type in the IP address.
5) Click Save.
6) Type in mail for the name, and type in the IP address.
7) Click Save.
8) Type in ftp for the name, and type in the IP address.
9) Click Save.
10) Type in ns1 for the name, and type in the IP address.
11) Click Save.
12) Type in ns2 for the name, and type in the IP address.
13) Click Save.
14) At the bottom, click “Return to Record Types”

Creating NS records.
1) Click on Name Server
2) For the zone name, type in the domain name (Put a . at the end; for example:
yourdomain.com.
(Notice the ending period… DO Not Forget that)
3) For the name server, type in ns1.yourdomain.com.
(Also notice the period)
4) Click Save.
5) Type in ns2.yourdomain.com.
6) Click Save.
7) Click “Return to Record Types”

Creating an MX Record.
1) Click Mail Server (If you want a mail server).
(Make sure you put the period at the end; mail.yourdomain.com.
2) For the name, type in the domain.
3) For the mail server, type in mail.yourdomain.com.
4) Set the priority to what you like… 10 is usually default.
5) Click “Return to Record Types”

SETTING FTP ACCESS USING WEBMIN

Install proftpd  via Un-used Modules in Webmin

After that go to  System/Users and Groups, and select “Create a new user.

Provide a username for what is to be the FTP account.

As “Home directory” select “Directory” and press the button to show the folders in your server.
Select the /var/www//html/yourdomain.com folder you previously created or whatever folder you want the ftp account to login into.

Select the “Shell” /bin/false

Select “Normal Password” and provide a unique, complex password for the account

Select “New Group” and write down the same name as the user you’re creating

Disable:

Create home directory
Copy template files…
Create user in other modules
Click on “Create”

It will complete the process and take you back to the users list page.

Go back to the SSH console and run the following:

#chown username /var/www/html/yourdomain.com 

(folder you previously created )

Now start your favorite FTP Client en try your new user.

Magento orders by sku

SQL code for orders by sku

SQL code for orders by sku


SELECT sales_flat_order.increment_id,
 sales_flat_order_item.order_id,
 sales_flat_order_item.sku,
 sales_flat_order.status,
 sales_flat_order_item.name,
 sales_flat_order.customer_email
 FROM dbname.sales_flat_order_item sales_flat_order_item
 INNER JOIN dbname.sales_flat_order sales_flat_order
 ON (sales_flat_order_item.order_id = sales_flat_order.entity_id)
 WHERE (sales_flat_order_item.sku = 'fill in sku no ')
 AND (sales_flat_order.status &lt;&gt; 'Canceled')
ORDER BY sales_flat_order.increment_id DESC