Sponsored Content
Full Discussion: Unknown command '\;'
Top Forums Shell Programming and Scripting Unknown command '\;' Post 303034830 by baris35 on Tuesday 7th of May 2019 07:46:43 PM
Old 05-07-2019
Unknown command '\;'

Hello,
I am running ubuntu 16.04 .
Below script gives: "unknown command '\;'

Code:
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
Code:
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

Last edited by baris35; 05-07-2019 at 08:53 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

unknown host

Hello all I'm new to this site and I have to say that ,it is just awesome. I was able to get most of my questions answered by reading the archives. I've been a UNIX programmer for a while now but new to administration. I just installed SunOS 5.9 on my desktop ( i86pc) . Everything... (3 Replies)
Discussion started by: luft
3 Replies

2. Solaris

<drive type unknown> when format command run

Hi, we are running solaris 9 on V280R. Due to power failure, one disk's label and lost its details like drive type etc. Disk details: <SUN72G cyl 14087 alt 2 hd 24 sec 424> single partition on slice 6 with UFS. The below i see when i run "format" command ..... ..... 4.... (1 Reply)
Discussion started by: prvnrk
1 Replies

3. Solaris

PING - Unknown host 127.0.0.1, Unknown host localhost - Solaris 10

Hello, I have a problem - I created a chrooted jail for one user. When I'm logged in as root, everything work fine, but when I'm logged in as a chrooted user - I have many problems: 1. When I execute the command ping, I get weird results: bash-3.00$ usr/sbin/ping localhost ... (4 Replies)
Discussion started by: Przemek
4 Replies

4. Shell Programming and Scripting

Sed unknown command

Hi everyone, I am trying to replace a string that contains a space using sed. A typical input file is: CATEGORY=1 1:1.0 CATEGORY=2 13:1.0 CATEGORY=3 1:99.0 CATEGORY=8 14:1.0 CATEGORY=11 1:1.0 I want to use a string (as it can change) to make replacements using ... (3 Replies)
Discussion started by: BlueberryPickle
3 Replies

5. HP-UX

'SP2-0734: unknown command beginning "elect' Error

My environment is HP-UX... NIS CEL | uname -a HP-UX s53kj113 B.11.11 U 9000/800 1510201964 unlimited-user license I ran this command directly from the server's sqllplus. Logically, it should have work. But in my case, it always escaped the 1st character of the next command after the... (3 Replies)
Discussion started by: aimy
3 Replies

6. AIX

Unknown VGs

Hi Guys, I found on one of the server there are 2 VG's which I dont have any Idea of who created .. as below bash-3.00$ lsvg old_rootvg rootvg datavg altinst_rootvg altinst_rootvg under is meant for alternate disk installation.. But I'm not sure for which version of OS it was... (5 Replies)
Discussion started by: kkeng808
5 Replies

7. Solaris

Unknown fstype?

Dear all I have formatted/labeled/partitioned my new disk but when trying to mount it is returning 'unknown fstype' .Can you please let me know how to solve this problem? Thank you (37 Replies)
Discussion started by: hadimotamedi
37 Replies

8. Shell Programming and Scripting

There's a unknown command on line 1 and i don't know whats causing it.

My OS is Linux GL version 2.4.26. I am trying to make a shell script that outputs a chart displaying info of who is online, boot time, and the real time, I have manage to get it to work, but I still get the error "./user/script: line 1: : command not found." I do in fact have access to root, if... (2 Replies)
Discussion started by: thatguy565
2 Replies

9. Shell Programming and Scripting

Unknown fs on usb?

Error mounting: mount exited with exit code 1: helper failed with: mount: wrong fs type, bad option, bad superblock on /dev/sdb1, missing codepage or helper program, or other error In some cases useful info is found in syslog - try dmesg | tail or soThis happens when I try... (17 Replies)
Discussion started by: 1in10
17 Replies

10. Programming

Arduino-cli - Uploading to Unknown Chinese Arduino Boards using the Arduino Command Line Interface

In my further exploration of Arduino, today I decided to install the arduino-cli on my mac today. https://github.com/arduino/arduino-cli I followed the instructions for macOS but when I got to this part: arduino-cli board list I got the dreaded "Unknown" Fully Qualified Board Name... (1 Reply)
Discussion started by: Neo
1 Replies
GCAP.1(1p)						User Contributed Perl Documentation						GCAP.1(1p)

NAME
gcap - Youtube closed caption downloader SYNOPSIS
gcap [-i] [-t] [-r <regexp>] [--proxy=<addr> | --no-proxy] [--help] <url> | <video_id> DESCRIPTION
gcap is a command line tool for downloading Youtube closed captions. The downloaded closed captions are saved in SubRip (srt) file format. The srt files are saved as "$videoid_$langid.srt" by default. OPTIONS
--help Print help and exit. --version Print version and exit. -q, --quiet Be quiet. -i, --interactive Open the interactive prompt which can be used to select the items. gcap selects all items by default. See also "INTERACTIVE PROMPT". -t, --title Parse video title and use it in the output filename(s) instead of video ID. The default is no. -r, --regexp=arg Cleanup video title using the specified arg regular expression. The default is "/(w|s)/g". --proxy arg Use arg for HTTP proxy, e.g. "http://foo:1234". Overrides the http_proxy environment setting. --no-proxy Disable use of HTTP proxy. Overrides both "--proxy" and http_proxy environment settings. INTERACTIVE PROMPT
Use the "--interactive" switch to open the prompt. Note that gcap uses (as of 0.1.0) the Umph::Prompt module for this. Once the prompt opens, type "help" to get a list of commands available to the prompt. EXAMPLES
gcap 0QRO3gKj3qw gcap "http://www.youtube.com/watch?v=0QRO3gKj3qw" Both yield the same results. gcap -ti 0QRO3gKj3qw Same as above two but use video title in the filename and choose which of the closed captions should be downloaded. EXIT STATUS
Exits 0 on success, otherwise 1. FILES
$HOME/.gcaprc, for example: echo "--interactive" >> ~/.gcaprc NOTES
Availability The following error message produced by gcap (or the XML::DOM module) typically indicates that the video does not have any closed captions available for it (URL omitted for brewity): Couldn't parsefile [...] with LWP: no element found at line 1, column 0, byte -1 at [...]/XML/Parser.pm [...] http_proxy gcap depends on XML::DOM which uses LWP::UserAgent to download the data. Note that LWP::UserAgent reads http_proxy environment setting. e.g.: env http_proxy=http://foo:1234 gcap video_id WWW
<http://gcap.googlecode.com/> <http://repo.or.cz/w/gcap.git> AUTHOR
Toni Gundogdu <legatvs at sign cpan org> perl v5.12.4 2011-11-15 GCAP.1(1p)
All times are GMT -4. The time now is 01:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy