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
– Sal00m, Commented Oct 27, 2014 at 12:10
Has all the hallmarks of a Windows newline. Was the script created on Windows and copied over? — arco444
– arco444, Commented Oct 27, 2014 at 12:13

Cyrus · Accepted Answer · 2014-10-27 12:16:28Z

1

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

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

answered Oct 27, 2014 at 12:16

Cyrus

90.2k15 gold badges112 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cyrus Over a year ago

You should see the Windows line delimiters with cat -v sendEmailNotification.sh.

Community · Accepted Answer · 2017-05-23 11:57:10Z

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, 2017 at 11:57

CommunityBot

11 silver badge

answered Oct 27, 2014 at 12:12

Slava Semushin

15.2k7 gold badges56 silver badges69 bronze badges

1 Comment

Sergey Scopin Over a year ago

But it is in one line in my script.

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related