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 /folderAbove command will list all files start with “filenames”
sudo find . -name 'filenames*'
sudo find . -name 'filename-prefix*'| xargs rm
Above command will delete all files start with “
Such as –
You have huge files which file names started with ‘abc’, Then you will write the command –
sudo find . -name 'abc*'| xargs rm
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