Database problem.

Asked by Ashrael on 2012-04-21

I installed Ubuntu 12.04 and I am very content so far, but, me-tv (can't live without) does not want to start right now. I installed clean so no old config files around.

It shows me a popup:

"Your Me TV database is too old to use this version of Me TV. Would you like to clear the Me TV database
? All of your channels, EPG events and scheduled recordings wil be deleted

If you've just upgraded Me TV then tis is probably what you want to do.

The Me TV database is located at ~/.local/share/me-tv.db"

If I press "Delete my old Me TV data!" the popup sometimes stays and sometimes goes, but, Me TV doesnt show up in Unity, but is running.

If i run Me TV from terminal with -v i get the popup and in terminal:

~$ me-tv -v
Me TV 1.3.6
04/21/2012 18:05:03: Application constructor
04/21/2012 18:05:03: sqlite3_threadsafe() = 1
04/21/2012 18:05:03: Database 'exists'
04/21/2012 18:05:03: Opening database file '~/.local/share/me-tv/me-tv.db'
04/21/2012 18:05:03: Loading UI files
04/21/2012 18:05:04: Application constructed
04/21/2012 18:05:04: Initialising table 'version'
04/21/2012 18:05:04: Required Database version: 6
04/21/2012 18:05:04: Actual Database version: 0
^C

Is this a problem with Me TV or Ubuntu or my install?
I tried removing the db by hand, to no avail....
Switched back to Kaffeine for now, so the dvb works.

TIA!

Question information

Language:
English Edit question
Status:
Solved
For:
Me TV Edit question
Assignee:
No assignee Edit question
Solved by:
Ashrael
Solved:
Last query:
Last reply:
Revision history for this message
Frédéric Côté (frederic-cote) said :
#1

This is a duplicate bug of this one:
https://bugs.launchpad.net/ubuntu/+source/me-tv/+bug/958751

This is fix but not release in the main repository. If you can't wait, use the PPA instead:
https://launchpad.net/~me-tv-development/+archive/ppa

Cheers,
Frederic

Revision history for this message
Ashrael (adaptr010) said :
#2

I tried as you suggested, but it did not work. Now when I start it from unity, it does not start at all....
From terminal I get:

~$ me-tv
The program 'me-tv' is currently not installed. You can install it by typing:
sudo apt-get install me-tv

So I do (I know I installed it but anyway):

~$ sudo apt-get install me-tv
[sudo] password for xxxxx:
Reading package lists... Done
Building dependency tree
Reading state information... Done
me-tv is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

So it is installed. I will investigate further :)

Thanks for the help!

Revision history for this message
Ashrael (adaptr010) said :
#3

After: purge, autoremove, autoclean and re-install still the same problem.

Could it be that the file has the wrong name? me-tv-client instead of me-tv?
When I start /usr/sbin/me-tv-client I get:

~$ me-tv-client
Me TV 1.4.0.9
2012-04-22 12:32:28: Me TV Server 1.4.0.9 started
2012-04-22 12:32:28: An unhandled exception was generated
2012-04-22 12:32:28: Error: The Me TV database version does not match the Me TV server version.
04/22/2012 12:32:33: Exception: Failed to communicate with Me TV server

Still investigating.....

Revision history for this message
Ashrael (adaptr010) said :
#4

Again purge, autoremove and autoclean, re-install from repo. The files here are called: me-tv and me-tv-player, I guess the player is the one now called server?

But no luck so far. If you need some more info, just ask...

Thanks!

Revision history for this message
Frédéric Côté (frederic-cote) said :
#5

If you are using version 1.3.6, it won't work. You have two choice:
1- Install/compile version 1.3.7 from the source code. Then start me-tv with the command "me-tv"

2- Configure the PPA and install the version 1.4.0 from it. Then start me-tv with the command "me-tv-client". If you have an error saying that the server is unreachable, you can start the server first with the command "me-tv-server"

You should erase the database in the folder ~/.local/share/me-tv/

Revision history for this message
Ashrael (adaptr010) said :
#6

I will purge Me-TV from my system and the install from ppa. I will report back here the results.

Thanks.

Revision history for this message
Ashrael (adaptr010) said :
#7

I purged etc me-tv, then installed from ppa.

When I click the menu entry, nothing seems to happen except the HD led lights up, system-monitor confirms no me-tv going on.

From terminal:

:~$ me-tv-client
Me TV 1.4.0.9
2012-04-23 13:09:26: Me TV Server 1.4.0.9 started
2012-04-23 13:09:26: An unhandled exception was generated
2012-04-23 13:09:26: Error: The Me TV database version does not match the Me TV server version.
04/23/2012 13:09:31: Exception: Failed to communicate with Me TV server

And starting the me-tv-server yields:

~$ me-tv-server
2012-04-23 13:09:15: Me TV Server 1.4.0.9 started
2012-04-23 13:09:15: An unhandled exception was generated
2012-04-23 13:09:15: Error: The Me TV database version does not match the Me TV server version.

So it seems the server is the problem here?

HTH

Revision history for this message
Ashrael (adaptr010) said :
#8

Just found out the -v switch:

~$ me-tv-server -v
2012-04-23 13:15:51: Me TV Server 1.4.0.9 started
2012-04-23 13:15:51: Database 'exists'
2012-04-23 13:15:51: Opening database file '/home/adaptr/.local/share/me-tv/me-tv.db'
2012-04-23 13:15:51: Initialising table 'version'
2012-04-23 13:15:51: Required Database version: 8
2012-04-23 13:15:51: Actual Database version: 0
2012-04-23 13:15:51: Exception: The Me TV database version does not match the Me TV server version.
2012-04-23 13:15:51: An unhandled exception was generated
2012-04-23 13:15:51: Signal error 'The Me TV database version does not match the Me TV server version.'
2012-04-23 13:15:51: Error: The Me TV database version does not match the Me TV server version.
2012-04-23 13:15:51: Destroying StreamManager
2012-04-23 13:15:51: StreamManager destroyed

Revision history for this message
Ashrael (adaptr010) said :
#9

and of course: [ I really need to eat something :) ]

:~$ me-tv-client -v
Me TV 1.4.0.9
04/23/2012 13:20:20: Sending request
04/23/2012 13:20:20: Exception: Failed to connect: Connection refused
2012-04-23 13:20:20: Me TV Server 1.4.0.9 started
2012-04-23 13:20:20: An unhandled exception was generated
2012-04-23 13:20:20: Error: The Me TV database version does not match the Me TV server version.
04/23/2012 13:20:21: Attempting to register
04/23/2012 13:20:21: Sending request
04/23/2012 13:20:21: Exception: Failed to connect: Connection refused
04/23/2012 13:20:21: Registered with client ID 0
04/23/2012 13:20:22: Attempting to register
04/23/2012 13:20:22: Sending request
04/23/2012 13:20:22: Exception: Failed to connect: Connection refused
04/23/2012 13:20:22: Registered with client ID 0
04/23/2012 13:20:23: Attempting to register
04/23/2012 13:20:23: Sending request
04/23/2012 13:20:23: Exception: Failed to connect: Connection refused
04/23/2012 13:20:23: Registered with client ID 0
04/23/2012 13:20:24: Attempting to register
04/23/2012 13:20:24: Sending request
04/23/2012 13:20:24: Exception: Failed to connect: Connection refused
04/23/2012 13:20:24: Registered with client ID 0
04/23/2012 13:20:25: Attempting to register
04/23/2012 13:20:25: Sending request
04/23/2012 13:20:25: Exception: Failed to connect: Connection refused
04/23/2012 13:20:25: Registered with client ID 0
04/23/2012 13:20:25: Exception: Failed to communicate with Me TV server
04/23/2012 13:20:25: Exception: Failed to communicate with Me TV server

Revision history for this message
Frédéric Côté (frederic-cote) said :
#10

Can you start the serveur first with the command "me-tv-server -v" ?

On Mon, Apr 23, 2012 at 7:25 AM, Ashrael <
<email address hidden>> wrote:

> Question #194312 on Me TV changed:
> https://answers.launchpad.net/me-tv/+question/194312
>
> Ashrael gave more information on the question:
> and of course: [ I really need to eat something :) ]
>
> :~$ me-tv-client -v
> Me TV 1.4.0.9
> 04/23/2012 13:20:20: Sending request
> 04/23/2012 13:20:20: Exception: Failed to connect: Connection refused
> 2012-04-23 13:20:20: Me TV Server 1.4.0.9 started
> 2012-04-23 13:20:20: An unhandled exception was generated
> 2012-04-23 13:20:20: Error: The Me TV database version does not match the
> Me TV server version.
> 04/23/2012 13:20:21: Attempting to register
> 04/23/2012 13:20:21: Sending request
> 04/23/2012 13:20:21: Exception: Failed to connect: Connection refused
> 04/23/2012 13:20:21: Registered with client ID 0
> 04/23/2012 13:20:22: Attempting to register
> 04/23/2012 13:20:22: Sending request
> 04/23/2012 13:20:22: Exception: Failed to connect: Connection refused
> 04/23/2012 13:20:22: Registered with client ID 0
> 04/23/2012 13:20:23: Attempting to register
> 04/23/2012 13:20:23: Sending request
> 04/23/2012 13:20:23: Exception: Failed to connect: Connection refused
> 04/23/2012 13:20:23: Registered with client ID 0
> 04/23/2012 13:20:24: Attempting to register
> 04/23/2012 13:20:24: Sending request
> 04/23/2012 13:20:24: Exception: Failed to connect: Connection refused
> 04/23/2012 13:20:24: Registered with client ID 0
> 04/23/2012 13:20:25: Attempting to register
> 04/23/2012 13:20:25: Sending request
> 04/23/2012 13:20:25: Exception: Failed to connect: Connection refused
> 04/23/2012 13:20:25: Registered with client ID 0
> 04/23/2012 13:20:25: Exception: Failed to communicate with Me TV server
> 04/23/2012 13:20:25: Exception: Failed to communicate with Me TV server
>
> --
> You received this question notification because you are an answer
> contact for Me TV.
>

--
"In a world without walls, who really needs Windows"
"Nothing is foolproof because fools are so ingenious"

Revision history for this message
Ashrael (adaptr010) said :
#11

and : "Some windows are better left unopened"
:)

Revision history for this message
Ashrael (adaptr010) said :
#12

In .local/share/me-tv I deleted the me-tv.db file again. And now it works? Maybe some other package got updated, or I am just stupid... Well after I used scan to create a new channels.conf file. HURRAH!

If I remember correctly there was a way to scan in me-tv before? I might be wrong here, since the program worked well for very long, so I might have forgotten..

Two suggestions:

When starting up afresh it asks for a channels.conf file and tells me that I can use the SCAN command to create that.... But it could also give me a suggestion on how to use it? Maybe add to this dialogue: Scan [location of scan file] > channels.conf...

or even better:

Add a scanfunction in the program that can use the scanfiles in /usr/share/dvb/dvb-t to create it's database?

Thanks for putting up with me!

Revision history for this message
Ahmed Thabet Ali (ali-athabet-ahmedthabet) said :
#13

how to delete this file "me-tv.db"?

Revision history for this message
Ashrael (adaptr010) said :
#14

Open Nautilus and press (ctrl+h) to make hidden files visible. The Me TV database is located at ~/.local/share/me-tv.db. Then you can just delete the file....
 HTH.