Unexpected $'\r': command not found after mysql query in shell

Question

This scipt gives proper result, but also gives mistake:$'\r': command not found in line with query.

#!/bin/bash
keyOrPass=$1
intercom=$2
flat=$3
number=$4
mysql -ulogin -ppass dbname -e "select cli.codeGuestEmail, cli.codePrivateEmail, cliKey.rf_id, cliKey.emailNotification from mbus_clients as cli join mbusClientKeys as cliKey on cliKey.id_client=cli.id WHERE cli.flat=${flat} and cli.domophone=${intercom};";

This is how I run the script:

 sh sendEmailNotification.sh key 10001014 11 1

And how do you call this script? you should detect the number of arguments and is lower than 4 then exit the script without executing the query — Sal00m, Oct 27 '14 at 12:10
Has all the hallmarks of a Windows newline. Was the script created on Windows and copied over? — arco444, Oct 27 '14 at 12:13

score 1 · Accepted Answer · answered Oct 27 '14 at 12:16

1

Create a version of your script without Windows line delimiter \r:

tr -d "\r" < sendEmailNotification.sh > sendEmailNotification_fixed.sh

answered Oct 27 '14 at 12:16

Cyrus

84,225
14
89
153

You should see the Windows line delimiters with `cat -v sendEmailNotification.sh`. – Cyrus Oct 27 '14 at 12:25

score 0 · Answer 2 · edited May 23 '17 at 11:57

0

Check and fix line-endings in your script, probably, it was saved with \r\n as line delimiters.

This link may be useful: How to convert DOS/Windows newline (CRLF) to Unix newline (\n) in a Bash script?

edited May 23 '17 at 11:57

Community

1
1

answered Oct 27 '14 at 12:12

Slava Semushin

14,904
7
53
69

But it is in one line in my script. – Sergey Scopin Oct 27 '14 at 12:15

Unexpected $'\r': command not found after mysql query in shell

2 Answers2