Hello,
I am running ubuntu 16.04 .
Below script gives: "unknown command '\;'
counter=105
while read COL1 COL2 COL3
do
let counter++
url="http://localhost/test/$COL1.$COL2.$COL3";
mysql -uroot -D mydatabase -pmypasswd -e "SELECT video_id FROM video_series_files WHERE id IN \
(SELECT video_id FROM video_series_files WHERE url like '%$COL1%.mkv')" > video_id
sed -i '/video_id/d' video_id;
sed -i '/--/d' video_id;
while read -r line
do
mysql -uroot -D mydatabase -pmypasswd -e "INSERT INTO video_series_files (id, video_id, file_type, \
protocol, url, languages, quality, accessed ,status ) VALUES ('.$counter.', \
'$line', 'sub', 'custom', '$url', 'a:1:{i:0;s:2:\'$COL2'\;}', '', '1', '1' )";
done<video_id
done<2
2
Mr.Smith.Goes.to.Washington en srt
Mr.Smith.Goes.to.Washington fr srt
Mr.Smith.Goes.to.Washington el srt
I have checked the database and I confirm that id 103 and following lines are already empty.
Could you please let me know why I receive this error?
Thank you
Boris