SOLVED: ‘/BIN/RM: ARGUMENT LIST TOO LONG’ ERROR

I faced this issue while I was removing huge list of files from a folder using
sudo rm -rf /folder/filename*

Take a count of file in the folder:
ls techlogs/ | wc -l

Upon googling found following command, that fixed my issue.

cd /folder
sudo find . -name 'filenames*'
Above command will list all files start with “filenames”

sudo find . -name 'filename-prefix*'| xargs rm 
Above command will delete all files start with “filename-prefix

Such as –

You have  huge files which file names started with ‘abc’, Then you will write the command –

sudo find . -name 'abc*'| xargs rm 

 

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')