Google SMTP Server – How to Send Emails for Free

To use Gmail’s SMTP server, you will need the following settings for your outgoing emails:

  • Outgoing Mail (SMTP) Server: smtp.gmail.com
  • Use Authentication: Yes
  • Use Secure Connection: Yes (TLS or SSL depending on your mail client/website SMTP plugin)
  • Username: your Gmail account (e.g. user@gmail.com)
  • Password: your Gmail password
  • Port: 465 (SSL required) or 587 (TLS required)
HOW TO SOLVE MYSQL GROUP BY ISSUE ?

HOW TO SOLVE MYSQL GROUP BY ISSUE ?

If you face this kind of problem..Mysql Error 1055.. How to solve this

I solved this issue in two ways –

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

Answer: First access in your database with mysql root user. Then run the following query-

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Solution 2: Updating the Mysql query

Answer: To solve this issue permanently you have to update your query.

Update all group column by primary key of a table and Set multiple group by if there is any column which is not functionally dependent on columns in GROUP BY clause

->group_by('b.product_info_id')
->group_by('c.product_title_id')
->group_by('e.id')