Problem with channel re order

[notapom]

I'm attempting to swap the HD channel number with their SD counter parts but no matter how many times I I try, I cannot move BBC 2 hd from 102 to 2. All other channels have swapped and BBC 2 SD has moved to 102. Any ideas?


sqlite3 /var/lib/humaxtv/channel.db
update TBL_SVC set usLcn = 1 where szSvcName like '_BBC 1 Wales HD';
update TBL_SVC set usLcn = 2 where szSvcName like '_BBC 2 Wales HD';
update TBL_SVC set usLcn = 3 where szSvcName like '_ITV Wales HD';
update TBL_SVC set usLcn = 7 where szSvcName like '_Channel 4 HD';
update TBL_SVC set usLcn = 5 where szSvcName like '_Channel 5 HD';
update TBL_SVC set usLcn = 101 where szSvcName like '_BBC ONE Wales';
update TBL_SVC set usLcn = 102 where szSvcName like '_BBC TWO Wales';
update TBL_SVC set usLcn = 103 where szSvcName like '_ITV Wales';
update TBL_SVC set usLcn = 104 where szSvcName like '_Channel 4';
update TBL_SVC set usLcn = 105 where szSvcName like '_Channel 5';
.exit
Reboot

 

[MymsMan]

You should use the tunefix package with an easy to use webif rather than attempting raw SQL commands

(otherwise check the exact spelling of BBC 2 Wales HD) - 1 and 2 are spelt out ONE and TWO in England

 

[notapom]

It uses the numbers on the HD version of the channel name in Wales. BBC 1 Wales HD/BBC 2 Wales HD or BBC ONE Wales/BBC TWO Wales for the SD version. BBC 1 Wales HD has successfully moved but not BBC 2 Wales HD. I've checked with a fine toothed comb lol. I've even tried many variables including BBC 2 Wales HD, BBC 2 WALES HD, BBC TWO Wales HD, BBC TWO WALES HD etc. No joy. I will check out the tune fix package.
Thanks

 

[notapom]

Tunefix won't solve the problem either. Now BBC 2 Wales HD has completely disappeared from the line-up altogether. Note all other channels were moved.

 

[prpr]

Send me a copy of your original unmolested channel.db file and I'll take a look.

 

[notapom]

Send me a copy of your original unmolested channel.db file and I'll take a look.

Sorry to be such a noob, i'm new to this. Where can I find the channel.db file?

When I type /var/lib/humaxtv/channel.db into puTTY, it says permission denied.

 

[notapom]

Send me a copy of your original unmolested channel.db file and I'll take a look.

I'm trying to copy the text from /var/lib/humaxtv/channel.db in the web interface but it says i cannot post links yet on this forum?

 

[Black Hole]

WebIF >> Diagnostics >> File Editor, load channel.db, then copy and paste into a text file and attach to the post (see Newbies' Guide to the Forum - click).

 

[/df]

You can copy the file from the box using FTP ftp://root@yourHmxIPOrName/var/lib/humaxtv/channel.db (NB spelling), with the box PIN as password. If your browser has forgotten how to do that, you can use command-line FTP, or perhaps your file manager (eg Windows Explorer, PCManFM), or install FileZilla.

 

[Black Hole]

If you copy the whole channel.db, you will need to zip it or rename it .txt before you can attach to a post.

The problem with putting a listing in a post as a newbie is that if the contents appear to contain links (to potential spam), it will be refused. You just need to get your post count up.

 

[notapom]

If you copy the whole channel.db, you will need to zip it or rename it .txt before you can attach to a post.

The problem with putting a listing in a post as a newbie is that if the contents appear to contain links (to potential spam), it will be refused. You just need to get your post count up.

Right got it, thanks for your help. i'll upoad a txt file now.

 

[notapom]

channel.db file

 

[notapom]

If i perform a factory reset and go through the installation wizard, i get my default line-up. If i attempt to change the channel numbers using the raw SQL commands then everything moves where i ask apart from BBC 2 Wales HD. This stays on 102 along with BBC TWO Wales(SD) which correctly moves to 102. If i perform a reboot and tunefix kicks in, i completely lose BBC 2 Wales HD.

I will attach a copy of channel.db after a factory reset and before attempting to change channel numbers.

Edit: In an attempt to rectify the issue, i performed a factory default reset in the custom firmware including a HD format. I then put the official firmware back on and performed another factory default reset including HD format to make sure any hint of the custom firmware was removed, i cancelled any channel search in the factory resets. I then flashed the custom firmware back on, run the start up wizard, searched for channels, got my default line-up. Re-installed the web interface, added tunefix. Forced the SD channels to 101-105 and the HD channels to the SD channel numbers. All moved to where i chose apart from BBC 2 Wales HD. This time it didn't disappear, but stayed on 102 below BBC TWO Wales (SD) also now on 102.

 

[prpr]

See port #5.
I almost find it hard to believe that someone knows about SQL commands and how to issue them and where, but can't seem to copy a file.
I don't want a copy of a web page representation of it.

 

[notapom]

See port #5.
I almost find it hard to believe that someone knows about SQL commands and how to issue them and where, but can't seem to copy a file.
I don't want a copy of a web page representation of it.

Well I followed a guide on YouTube and read a post on here where someone was guiding another user in their attempt to change their channel numbers, I followed their instructions until I hit my issue then posted for help. I didn't even know what SQL commands were until today or what they were called until MymsMan called them SQL commands in his comment in this thread. Telling me to refer to your original comment doesn't help when I had already replied to that message, apologising that I was new to this and asking where I could find the channel.db file you requested. If you don't want to help me that's fine, but you don't need to be a dick about it. I wouldn't be asking for assistance if I knew what I was doing.

 

[Black Hole]

Don't worry, I don't understand either. Isn't an SQLite .db file just plain text? If so, then a copy&paste from the WebIF file editor into a text file attached here (as you have done) is a perfectly good representation - download it from the post, rename the resulting file "channel.db", and you're done.

There are other ways to copy out the actual file, all of which require more guidance:

• To get to the file by FTP you have to disable the standard FTP server and install betaftpd instead;
• Use the hidden service menu to dump configuration to a USB drive.

If you don't want to help me that's fine, but you don't need to be a dick about it.

Unfortunately prpr is the most likely to be able to help.

 

[prpr]

Isn't an SQLite .db file just plain text?

Oh yes, of course it is. Silly me. <smacks head>

 

[Trev]

Unfortunately prpr is the most likely to be able to help.

Why is that unfortunate?

 

[Black Hole]

Well, if he wasn't willing...

 

[prpr]

I was. I am. But can't without the right info.
Post 1 implies (to me anyway) a skill level higher than what was latterly claimed. Hence the confusion.