Vtiger outgoing mail server setting for gmail user

  if not working let`s try with this setting

no need to use user name also password , and finaly don`t enable authentication

In this post I will show how you can add banner ads to your Ionic apps. I will be doing this on a new app but you can do it to your existing app as well. I have also written a post on adding banner ads to Ionic 2 apps, so if you are looking for Ionic 2 apps You can check that post out as well.

Step 1)

We will first start by creating a new Ionic project by issuing the following command in the command prompt

Step 2)

Now we will need to add the platform to out app. So will do the following command

Step 3)

As we will be using the AdMob Pro plugin we will need to download it in our project. We will do that by the following command

you can read more about the plugin in the Admob pro plugin documentation

Step 4)

Now we will need to add the following code to the $ionicPlatform.ready() in the app.js file

So the finished app.js file looks like this:

NOTE: The app.js file will be different for each template namely tabs,bank,sideMenu, make sure you add the code to the $ionicPlatform.ready() function and no to any function inside it.

First let’s look at model and collection architecture in magento. If you look at a magento model class it extends Mage_Core_Model_Abstract which intern extends Varien_Object.The class Mage_Core_Model_Abstract has function like getId(), load(), save(), delete() etc .

Mysql4 resource files, as I mentioned earlier are used to perform database queries on tables. Below will list how we do sql operations inside resource files.

SELECT QUERY

Suppose we have the file Excellence_Test_Model_Mysql4_Test resource file.

<?php
class Excellence_Test_Model_Mysql4_Test extends Mage_Core_Model_Mysql4_Abstract
{
    public function _construct()
    {    
        $this->_init('test/test', 'test_id');
    }
    public function loadByField($field,$value){
    	$table = $this->getMainTable();
    	$where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
    	$select = $this->_getReadAdapter()->select()->from($table,array('test_id'))->where($where);
    	$id = $this->_getReadAdapter()->fetchOne($sql);
    	return $id;
    }
}

And here is the model file Excellence_Test_Model_Test

<?php
class Excellence_Test_Model_Test extends Mage_Core_Model_Abstract
{
	public function _construct()
	{
		parent::_construct();
		$this->_init('test/test');
	}
	public function loadByField($field,$value){
		$id = $this->getResource()->loadByField($field,$value);
		$this->load($id);
	}
}

In this file there are many new functions which have been used. Let’s take them one by one.

In our model file, we have used this function

$id = $this->getResource()->loadByField($field,$value);

$this->getResource() function returns the resource model’s object. So we are simply calling the loadyByField($field,$value) function in the resource model.

getTable() function

Now in our Mysql4 file, in the loadByField() function we have used $table = $this->getMainTable(); .This function returns the table name of the current model, i.e the one defined in the class’s constructor. If you want to get table name of another sql table in magento, we need to the getTable() call e.g

$table = $this->getTable(‘newsletter/subscribe’);

_getReadAdapter() function

Next we have: $where = $this->_getReadAdapter()->quoteInto(“$field = ?”, $value);

Here the first function too see is the $this->_getReadAdapter() function. This function return an object which has function to perform database query, like fetch(), fetchAll(), query(), etc.

Next, in read adapter, we can perform operations like:

1. fetchAll() : returns entire database table in multiple dimensional array as per the select query. e.g if we are executing an sql like “select * from table_name”, we would use the fetchAll() function to get all the values.
2. fetchRow(): returns a single row of the database table as per the select query. e.g if we are executing sql like “select * from table where id = ’1′” would use fetchRow() to get the single row.
3. fetchCol(): returns single column of a database table as per the select query. e.g if query is a select name from table” we would use fetchCol() function.
4. fetchOne(): return since value, i.e single row and single column. e.g if sql query “select count(*) from table” then we would use fetchOne()

The read adapter has many other functions as well, but above are the important functions used.

_quoteInfo() function

Another function we have used is quoteInto(): This function is used to create our where conditions. In this the actual value is substituted into the question mark we have written. For e.g $this->_getReadAdapter()->quoteInto(“user_id = ?”, 3); translates to

“user_id = 3″. Another frequently used variation of quoteInfo() is

$where = $this->_getReadAdapter()->quoteInto("$field IN(?)", array(1,2,3));

this translates to “field in (1,2,3)”

Getting deeper into the quoteInto() function: If we have multiple where conditions we can use

$where = $this->_getReadAdapter()->quoteInto("$field = ? AND ", $value).$this->_getReadAdapter()->quoteInto("$field1 = ? OR ", $value1).$this->_getReadAdapter()->quoteInto("$field2 = ?", $value2);

So this way, we can have multiple where conditions.

Continuing on the loadByField function in our resource model, next we have

$select = $this->_getReadAdapter()->select()->from($table,array(‘test_id’))->where($where);

Here we have created the select query using the select(), and on that called the from() function.

from() function

The from() function takes many different parameters, if you want to fire a simple select * query, you need to only pass the table name like from($table).

But right now, I wanted to select just a single column that is test_id, so I passed an array with column name to select. i.e array(‘test_id’). If we want to select multiple column, we need to array(‘test_id’,’col1’,’col2’). This will create a sql like

“select test_id,col1,col2 from $table”. But support we want a sql query like

“select test_id as id,col1 as column1 from $table” , i would call

from($table,array('id'=>'test_id','column1'=>'col1'));

Note:

If you want to see the exact sql that is generated by your function, you can any time do this

<?php echo $select; ?>

Again, back to the loadByField() function. The last line

<?php
	$id = $this->_getReadAdapter()->fetchOne($sql);
?>

This is already explained, above.

The select() function we used above return a select object which provides us with many more functions to perform all operations on a sql query. The class for the select object is Varien_Db_Select, where you can look into more details for all functions. Let look at a sample php code below.

public function getAll(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
$select = $this->_getReadAdapter()->select()->from($table)->columns(array('test_id'))->where($where)->limit(10,5)->order('created_time')->group('list_id')->having('list_id > ?',10);		
echo $select;
	}

As we can see all function in the select object, return the select object itself. Due to this we are able to chain the functions.

In this example, I have used almost all the sql select parameters you might require expect joins, which will be covered later.

Let’s take each function one at a time.

1. select() : used to initialize the sql query. This returns the Select object, which is the object on which we do all our operations.
2. from(): table name on which select operation is done. we have seen this in detail above.
3. columns() : here we can specify exactly which columns to select in the query
4. where() : used to give the where condition
5. limit(): takes to parameters. First are how many rows to return and second is offset from where to start. So in current case, it means return 10rows, leaving first 5rows.this uses the LIMIT 10 OFFSET 5 syntax in sql query, rather than LIMIT 10,5
6. order(): you can set how you want to order the result set. Default is ascending order. But if you want to mentioned descending order you do order(array(‘created_time Zend_Db_Select::SQL_DESC))
7. group(): put group by clause in your select query in the specified field.Having(): put having condition for group by clause.

JOINS

Let look at sample function.

public function joinUs()
{
		$table = $this->getMainTable();
		$table2 = $this->getTable('customer/entity');
		$cond = $this->_getReadAdapter()->quoteInto('t1.id = t2.customer_id','');
		$where = $this->_getReadAdapter()->quoteInto('t1.list_id = "?"',123);
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->join(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinLeft(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinRight(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		echo $select."<br/>";
}

This is the output I got in the my pc

SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` INNER JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` LEFT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` RIGHT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")

So, here you can see clearly how to use joins. I don’t think much explanation is required, the function call are self-explanatory. We can also use joinCross, joinFull, joinNatural as well, if you require it in any query. Please look at Varien_Db_Select class for details.

COUNT,MAX

Again, lets take another sample code

public function countUs(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('count(*)'));
		echo $select.'<br>';
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('max(list_id)'));
		echo $select.'<br>';
	}

This is the output.

SELECT count(*) FROM `aws`
SELECT max("list_id") FROM `aws`

As you can see here, using Expr classes, we do mysql averaging functions.

query() function

In the end, if you have a very complex sql query, you want to execute you can simple use the query function.

$sql = ‘…complex sql…’;

$this->_getReadAdapter()->query($sql);

public function updateUs(){
		$table = $this->getMainTable();
		$where = $this->_getWriteAdapter()->quoteInto('id = ?', 1);
$query = $this->_getWriteAdapter()->update($table, array('product_id'=>2,'file_id'=>3),$where);	
}

Here you can see how to execute the update query.

UPDATE `aws` SET `product_id` = ?, `file_id` = ? WHERE (id = 1)

For delete query, it’s very simple

$this->_getWriteAdapter()->delete($table,$where)->limit(1);

Important Note: Its considered good practice in magento, to execute these sql query in the resource files only. You can get the read adaptor object in model, phtml or any other files and do the above operations in any file. But as good practices, always try to do the query in resource/mysql4 files only.

Magento Product email Notification to send mail to subscriber to new product created and every time
product save with the price changes . You can alert your subscriber about the your new product or
the product price change . It have the following option to send notification .

• Have an enable/disaple notification .
• Generate your own design email template .
• Email from name .
• Email from your email .

It have the feature to send newsletter of product notification manualy .

Feature

• Working with magento newsletter .
• Send mail to every subscriber.
• First time product save after "Mage Product Email Notification" extension installed .
• Every time product price changed increase or decrease .
• Mail sent only a product visibility "Enables" & Product have a stock .
• Manual send Newsletter of product notification .
• Related Product also added to email .
• Manual feach the subscriber log .
• Cron to Send mail .
• limit Daily mail .
• Limit to Daily mail per eamil .
• Limit to Mail Per cron .
• Send Mail by Email Order by Descending .
• Send Mail by Price Order by Descending .
• Send Mail by Product ID Order by Descending .

Newsletter Variable

Newsletter Variable can use in Transactional Emails

• {{var items_html}} get Product detail { Name , Description , Price } .
• {{var items_related}} get 3 Related Product detail { Name , Description , Price } .

Once again, I have a problem with my apache virtual host configuration. (The default configuration is used instead of my specific one).

The problem is not really the misconfiguration but how to solve it.

Does anyone have good advice to do resolve this kind of problem quickly?

Some more pieces of information.

The default conf file is this one:

NameVirtualHost *
<VirtualHost *>
        ServerAdmin webmaster@localhost

        DocumentRoot /var/www/
        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/www/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
        <Directory "/usr/lib/cgi-bin">
                AllowOverride None
                Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </Directory>

        ErrorLog /var/log/apache2/error.log

        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn

        CustomLog /var/log/apache2/access.log combined
        ServerSignature On

    Alias /doc/ "/usr/share/doc/"
    <Directory "/usr/share/doc/">
        Options Indexes MultiViews FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
        Allow from 127.0.0.0/255.0.0.0 ::1/128
    </Directory>

</VirtualHost>

And the virtual host config that doesn't apply is this one:

<VirtualHost *:*>

ProxyPreserveHost On
ProxyPass / http://ip.ip.ip.ip:8088/
ProxyPassReverse / http://ip.ip.ip.ip:8088/
ServerName wiki.mydomain.com

</VirtualHost>

Syntax check

To check configuration files for syntax errors:

# Red Hat-based (Fedora, CentOS) and OSX 
httpd -t 
# Debian-based (Ubuntu) 
apache2ctl -t 
# MacOS 
apachectl -t

List virtual hosts

To list all virtual hosts, and their locations:

# Red Hat-based (Fedora, CentOS) and OSX 
httpd -S 
# Debian-based (Ubuntu) 
apache2ctl -S 
# MacOS 
apachectl -S

You want to integrate your store to blog.simply follow my simple steps.

Step 1:
   Goto magneto store files edit index.php add these lines

if ( strpos($_SERVER['REQUEST_URI'], 'index.php/admin') === FALSE )
{
define('WP_USE_THEMES', false);
require_once('../wp-load.php');   // configure your WordPress location.
}

Step 2:

copy "Your-magento-folder/app/code/core/Mage/Core/functions.php"

to   "Your-magento-folder/app/code/local/Mage/Core/functions.php"

If u not have the folder structure create that folder and paste .

Step 3:

find "function __() " this line around 90 to 100  in "Your-magento-folder/app/code/local/Mage/Core/functions.php"

thats look like 

"

I ran into this error when doing a

pecl install imagick

 on a Mac.

$ pecl install imagick
[...]
checking for pkg-config... no
pkg-config not found
configure: error: Please reinstall the pkg-config distribution
ERROR: `/private/tmp/pear/temp/imagick/configure --with-php-config=/usr/local/opt/php/bin/php-config --with-imagick' failed

By default, the needed pkg-config binary isn’t installed. You can install it via Homebrew.

$ brew instal pkg-config
==> Downloading https://homebrew.bintray.com/bottles/pkg-config-0.29.2.catalina.bottle.1.tar.gz
==> Downloading from https://akamai.bintray.com/c0/c0a6927c8e404f6db8b14d6644a218b22ddb0d27be1fa0a69d15bf0d9a6875ae?__gda__=exp=1571254410~hmac=2e306f9876b2de0ae458dcbf1e05bc609777305eb8ad5e25125e9467e8bfcfeb&response-content-disposition=
######################################################################## 100.0%
==> Pouring pkg-config-0.29.2.catalina.bottle.1.tar.gz
 /usr/local/Cellar/pkg-config/0.29.2: 11 files, 623KB

With the support of seamless customization and integrations, Magento 2 e-commerce stores can serve excellent experiences to customers. In many cases, the store owners are willing to allow the shoppers to add the product to the cart with a custom price.

Frequently, the store owner is prepared to set a fixed product pricing even if the consumer selects various options/add-ons from the front end for all or some specific products. Instead of manually changing all store products, we’ll need to manually code to override all store product prices with your preferred custom price.

In this article, I will instruct you to set a custom price of the product when adding the product to the cart by using Observe.

Let’s explore two straightforward steps below!

Step 1: Create Events/xml File

Firstly, you need to create events/xml in the folder Mageplaza/HelloWord/etc/frontend and use event checkout_cart_product_add_after

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
    <event name="checkout_cart_product_add_after">
        <observer name="customprice" instance="Mageplaza\HelloWord\Observer\CustomPrice" />
    </event>
</config>
 

Step 2: Create CustomPrice.php File

Now, you have to create CustomPrice.php file that overrides your price in the Observer Folder.

<?php
    /**
     * Mageplaza Hello CustomPrice Observer
     *
     * @category    Mageplaza
     * @package    Mageplaza_HelloWord
     *
     */
    namespace Mageplaza\HelloWord\Observer;
 
    use Magento\Framework\Event\ObserverInterface;
    use Magento\Framework\App\RequestInterface;
 
    class CustomPrice implements ObserverInterface
    {
        public function execute(\Magento\Framework\Event\Observer $observer) {
            $item = $observer->getEvent()->getData('quote_item');         
            $item = ( $item->getParentItem() ? $item->getParentItem() : $item );
            $price = 100; //set your price here
            $item->setCustomPrice($price);
            $item->setOriginalCustomPrice($price);
            $item->getProduct()->setIsSuperMode(true);
        }
 
    }

Note: According to your need for setting a custom price for one or more products, you can manipulate this by adding conditions.

Conclusion

That is the detailed instruction on how to add the product to the cart with the custom price in Magento 2. Let us know if you have any questions by commenting below!

From time to time everyone finds them selves in a position where they are faced with a development they have never confronted before. Today I was achieve to get all orders for a customer based on the customer email address.. While there are almost certainly several ways to do this, I found a nice query that is quick, and capable.

$orderCollection = Mage::getModel(‘sales/order’)->getCollection(); $orderCollection->addFieldToFilter(‘customer_email’,'email@domain.com’);

Happy coding, hope this helps next time you’re working on Magento

Here we discuse about how to add vTiger Sales Order item detail in any where in your vTiger , for example if you want to add Sales Order Item detail in your email .you just need that is just add simple function . if you want to add salesorder item view using single function.

 getDetailAssociatedProducts('SalesOrder',$focus);

 to youse the above function you got all the detail in your html format . 

I have a downloadable product. After I order the product and when my order is complete, I am able to download the product links from ‘My Downloadable Products’ menu in Customer Account section.

I go to ‘My Downloadable Products’ section and I click on the links to download. However, the PDF file opens in the browser itself. I would like to have the feature that asks to download / save as instead of directly opening in the browser.

It is fine with ZIP files. It asks to download and save. However, the PDF files, Images, HTML files, etc. are directly opened in the browser. I want them to download and save. So, a window appearing and asking to save and download the file is what I want.

Solution:

There is a very easy solution to this.

By default, Magento has the Configuration settings to make those files open in the browser itself. You can adjust the configuration settings in Magento Admin to ask for download files instead of opening in the browser.

- Go to System -> Configuration -> Catalog -> Downloadable Product Options -> Use Content Disposition
- Change the setting from inline to attachment.

Now, whenever you click the downloadable link, a pop window will always open and ask to download or open the file.

Hope it helps. Thanks.

This article shows how we can search Magento Repositories using SearchCriteriaBuilder that implements SearchCriteriaInterface. An example is provided of how we can perform search on Product repository in Magento. Similarly, we can search for other entities like Category, Customer, Order, Invoice, CMS Page, CMS Block, etc.

We can add different conditions to build custom search criteria.

Filters

Filter class is used to add custom field, value, and condition type to the search criteria.

$filter
    ->setField("name")
    ->setValue("%laptop%")
    ->setConditionType("like");

• condition_type is optional.
• If condition_type is not provided then the default condition_type is set as eq.

Different condition types:

CONDITION   NOTES
eq          Equals
gt          Greater than
gteq        Greater than or equal
lt          Less than
lteq        Less than or equal
moreq       More or equal
neq         Not equal
in          The value can contain a comma-separated list of values.
nin         Not in. The value can contain a comma-separated list of values.
like        The value can contain the SQL wildcard characters when like is specified.
nlike       Not like
notnull     Not null
null        Null
finset      A value within a set of values
nfinset     A value that is not within a set of values.
from        The beginning of a range. Must be used with to.
to          The end of a range. Must be used with from.

Filter Groups

FilterGroup class is used to apply multiple search criteria filters.

For OR condition: Pass filters array inside the FilterGroup class object.
For AND condition: Pass filterGroups array inside the searchCriteria class object.

$filter1
    ->setField("name")
    ->setValue("%laptop%")
    ->setConditionType("like");

$filter2
    ->setField("store_id")
    ->setValue("1")
    ->setConditionType("eq");

$filterGroup1->setFilters([$filter1, $filter2]);

$filter3
    ->setField("url_type")
    ->setValue(1)
    ->setConditionType("eq");

$filterGroup2->setFilters([$filter3]);

$searchCriteria->setFilterGroups([$filterGroup1, $filterGroup2]);

The above code will generate the following conditions:

(name like %laptop% OR store_id eq 1) AND (url_type eq 1)

Sorting

SortOrder is used to apply sorting to the search criteria.

Field and Direction can be passed to the sortOrder object.

Field is the name of the field to sort.
Direction is how we would like to sort the result. The two sorting values are ASC and DESC.

$sortOrder
    ->setField("email")
    ->setDirection("ASC");

$searchCriteria->setSortOrders([$sortOrder]);

Pagination

Limit the number in the result.

$searchCriteria->setPageSize(20); //retrieve 20 or less entities

Set the current page

$searchCriteria
    ->setPageSize(20)
    ->setCurrentPage(2); //show the 21st to 40th entity

The search engine determines the maximum number of results that a query can return.
For Elasticsearch, the default value of 10000 is defined in the module’s etc/di.xml file.

Search Items Using Filters

Below is an example of how we can search Product Repository using Search Criteria Builder.

The ProductRepositoryInterface class has the getList(SearchCriteria $searchCriteria) function which returns the search result object. The object is an instance of the class that implements the interface SearchResultInterface.

FilterBuilder and SearchCriteriaBuilder are used to avoid shared instances, i.e. we will be using create() method in the builder object so that Magento will instantiate a new object (unshared object).

use Magento\Framework\Api\SearchCriteriaBuilder;
use Magento\Framework\Api\FilterBuilder;
use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;
...
...
$filter = $this->filterBuilder
    ->setField(ProductInterface::NAME)
    ->setValue('%headphone%')
    ->setConditionType('like')
    ->create();

$this->searchCriteriaBuilder->addFilters([$filter]);
$this->searchCriteriaBuilder->setPageSize(20);

$searchCriteria = $this->searchCriteriaBuilder->create();
$productsItems  = $this->productRepository
    ->getList($searchCriteria)
    ->getItems();

Search Items using FilterGroups

Using FilterGroups to add multiple AND and OR conditions to search products.

use Magento\Framework\Api\SearchCriteriaBuilder;
use Magento\Framework\Api\FilterBuilder;
use Magento\Framework\Api\Search\FilterGroupBuilder;
use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;
...
...
$filter1 = $this->filterBuilder
    ->setField(ProductInterface::NAME)
    ->setValue("%laptop%")
    ->setConditionType("like")
    ->create();

$filter2 = $this->filterBuilder
    ->setField("store_id")
    ->setValue("1")
    ->setConditionType("eq")
    ->create();

$filterGroup1 = $this->filterGroupBuilder
    ->setFilters([$filter1, $filter2]);

$filter3 = $this->filterBuilder
    ->setField("url_type")
    ->setValue(1)
    ->setConditionType("eq")
    ->create();

$filterGroup2 = $this->filterGroupBuilder
    ->setFilters([$filter3]);

$this->searchCriteriaBuilder
    ->setFilterGroups([$filterGroup1, $filterGroup2]);

$this->searchCriteriaBuilder->setPageSize(20);

$searchCriteria = $this->searchCriteriaBuilder->create();
$productsItems  = $this->productRepository
    ->getList($searchCriteria)
    ->getItems();

Product Repository

use Magento\Catalog\Api\ProductRepositoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;

Category Repository

use Magento\Catalog\Api\CategoryRepositoryInterface;
use Magento\Catalog\Api\Data\CategoryInterface;

CMS Page Repository

use Magento\Cms\Api\PageRepositoryInterface;
use Magento\Cms\Api\Data\PageInterface;

CMS Block Repository

use Magento\Cms\Api\BlockRepositoryInterface;
use Magento\Cms\Api\Data\BlockInterface;

Customer Repository

use Magento\Customer\Api\CustomerRepositoryInterface;
use Magento\Customer\Api\Data\CustomerInterface;

Order Repository

use Magento\Sales\Api\OrderRepositoryInterface;
use Magento\Sales\Api\Data\OrderInterface;

Integrity constraint violation: 1062 Duplicate entry ‘4-Images’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME’, query was: UPDATE `eav_attribute_group` SET `attribute_group_name` = ? WHERE (`attribute_group_id`=10)

This particular error presented itself while upgrading from Magento 2.0.2 to Magento 2.1.x and stops the upgrade process. We’ve discovered the issue is related to old data from the previous Magento 1.9.x installation. In order to over come this error, you’ll need to delete a row from the database.

Run the following MySQL query to find and delete the offending attribute.

delete from eav_attribute_group WHERE attribute_group_name = 'Images';

After that then you can attempt to run the upgrade command again and the issue should be resolved.

We understand not everyone can be a MySQL / Magento 2 expert so if you’re faced with a similar issue and stuck between an upgrade feel free to contact us to assist with your problem.

By now you may know that PHP 7 has been available for quite some time now coming with a number of improvements over version 5. It may be wise to upgrade to PHP7 when running for instance a WordPress using Amazon AWS where you are responsible for any upgrades.

Also as of July 2016, Amazon officially added PHP7 to its repository so you can install it using yum. So first thing I did was create a backup image of my EC2 instance before I went on with the upgrade. Once I had my backups done and proceeded with the PHP 7 upgrade.

Here are the steps I took in order to upgrade from PHP 5.x to 7.

Login to your Linux instance and perform the regular system updates first

$ sudo yum update

Stop the running webserver

$ sudo service httpd stop

Remove any existing PHP packages

$ sudo yum remove php*

Remove old web server installs

$ sudo yum remove httpd*

Update yum package repository

$ sudo yum clean all
$ sudo yum upgrade -y

Install Apache 2.4

$ sudo yum install httpd24

Install PHP 7 packages

$ sudo yum install php70 php70-mysqlnd php70-imap php70-pecl-memcache php70-pecl-apcu php70-gd

Install a new version of mod_ssl

$ sudo yum install mod24_ssl

I also needed to reconfigure /etc/httpd/conf/httpd.conf and /etc/httpd/conf.d/ssl.conf.

Finally, all I needed to do is start my webserver

$ service httpd start

How can I select a random row using Eloquent or Fluent in the Laravel framework?

I know that by using SQL, you can do order by RAND(). However, I would like to get the random row without doing a count on the number of records prior to the initial query.

Solutions:

Laravel >= 5.2:

User::inRandomOrder()->get();

or to get the specific number of records

// 5 indicates the number of records User::inRandomOrder()->limit(5)->get(); // get one random record
User::inRandomOrder()->first();

or using the random method for collections:

User::all()->random();
User::all()->random(10); // The amount of items you wish to receive

Laravel 4.2.7 - 5.1:

User::orderByRaw("RAND()")->get();

Laravel 4.0 - 4.2.6:

User::orderBy(DB::raw('RAND()'))->get();

Laravel 3:

User::order_by(DB::raw('RAND()'))->get();

Check this article on MySQL random rows. Laravel 5.2 supports this, for older version, there is no better solution then using RAW Queries.

edit 1: As mentioned by Double Gras, orderBy() doesn't allow anything else then ASC or DESC since this change. I updated my answer accordingly.

edit 2: Laravel 5.2 finally implements a wrapper function for this. It's called inRandomOrder().

The most likely cause for the vTiger error “Sorry! Attempt to access restricted file.” is the $root_directory value in the ‘config.inc.php’ is incorrect or misspelled.

In order to correct it follow the steps below:

• Go to your vTigerCRM directory
• Open “config.inc.php” with your favorite text editor
• Go to line 86 and adjust $root_directory value to correct vTiger directory. Note, that the directory must end with /. It should look something like this – $root_directory = ‘/var/www/vtigercrm/’;
• If you can't find the root directorey 
  • Open "Index.php" with your favorite text editor add the following code after <?php

  • echo "__dir__";die;

  • It's display the root directory

Hope that helps!

With Advanced Content Manager for Magento 2, it’s possible to index and make your content searchable.

The default catalog search layout is overridden by our extension, in order to add our results to the search.
The extension is adding a Result Search Block into the Catalog Search Result page layout:

Samdoit/ContentManager/view/frontend/layout/catalogsearch_result_index.xml

<page xmlns:xsi="..." layout="2columns-left" xsi:noNamespaceSchemaLocation="..."> 
<body> 
<referenceContainer name="content"> 
<block class="Samdoit\ContentManager\Block\Search\Result" name="search.content.result" after="search.result" template="Samdoit_ContentManager::content/search/result.phtml" cacheable="false"> 
<referenceContainer> 
<body> 
<page>

The Result Block retrieves the current query and create the search filter. The block will load a ContentList Collection from the ids retrieved in the results.

This block has the following child:

<block class="Samdoit\ContentManager\Block\Content\Widget\ContentList" name="search_content_result_list" template="Samdoit_ContentManager::content/widget/list.phtml" cacheable="false"> <block>

This child block is nothing else that a ContentList widget. See the following documentation to customize the content list widget: XML layout

Then if you want to customize the result search for the content, you should override the following layout in frontend:

catalogsearch_result_index.xml

Be sure that the Blackbird_ContentManager module is loaded before yours. You can add the instruction in your module.xml file:

<module name=”Samdoit_ContentManager” setup_version=”1.0.0”> 
<sequence> 
<module name=”Samdoit_ContentManager”/>
<sequence> 
<module>

Now, in your catalogsearch_result_index.xml file, paste the following code in the tags and add instructions from the following resource: XML layout update

<referenceBlock name=”search_content_result_list” template=”my_custom_template.phtml”> <referenceBlock>

However if you just want to modify the template of the result search, see the following resource: Overriding templates

You can create a Plugin for the method SavePaymentInformation() in Magento 2 to add your logic before or after Payment information is saved.

The method will be called after a click on the Place order button from the second step of the Checkout page.

Original Class to create plugin:
Magento\Checkout\Model\PaymentInformationManagement

You can create a before or after plugin as per your requirement.

Create a global scope di.xml file,

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\Checkout\Model\PaymentInformationManagement">
        <plugin name="set_payment_data_before_save"
                type="Samdoit\SavePayment\Plugin\Model\SavePaymentPlugin" sortOrder="10"/>
    </type>
</config>

Create a Plugin Class for the Before saves payment information, We have used Before Plugin type,

<?php
namespace Samdoit\SavePayment\Plugin\Model;

use Magento\Quote\Api\Data\AddressInterface;
use Magento\Quote\Api\Data\PaymentInterface;
use Magento\Checkout\Model\PaymentInformationManagement;
use Magento\Framework\Exception\AbstractAggregateException;

class SavePaymentPlugin
{
    /**
     * @param PaymentInformationManagement $subject
     * @param int $cartId
     * @param PaymentInterface $paymentMethod
     * @param AddressInterface|null $billingAddress
     *
     * @return array
     *
     * @throws AbstractAggregateException
     *
     * @SuppressWarnings(PHPMD.UnusedFormalParameter)
     */
    public function beforeSavePaymentInformation(
        PaymentInformationManagement $subject,
        int $cartId,
        PaymentInterface $paymentMethod,
        AddressInterface $billingAddress = null
    ): array {
            // Add your logic before Save Payment information
        return [$cartId, $paymentMethod, $billingAddress];
    }
}

Before Plugin:
$cartId: You get the current quote Cart id, You can get the details of the active quote by cart id from the method.

$paymentMethod contains the Payment related information, Payment method, Payment additional data

The $billingAddress field contains the billing data of the checkout billing section.

You can create an after plugin also for the above method if you need to do some logic after the Payment method successfully saved.

Above Code snippet, Save Payment Information Plugin for adding extra logic after or before Payment data save in Magento 2.