Stop on "Initialising table 'version'"

Asked by Matteo Trentin on 2011-12-04

Ubuntu version: 11.10
Me-tv version: 1.3.6

Hello!
I'm not able to start me-tv, it seems a database problem...

Intalled Me-tv via 'apt-get'.
When I start with the command: "me-tv -v" it stops on "Initialising table 'version'".
The full log is listed:
"
matteo@matteo-Vostro1510:~$ me-tv -v
Me TV 1.3.6
04/12/2011 09:54:18: Application constructor
04/12/2011 09:54:18: sqlite3_threadsafe() = 1
04/12/2011 09:54:18: Database 'does not exist'
04/12/2011 09:54:18: Opening database file '/home/matteo/.local/share/me-tv/me-tv.db'
04/12/2011 09:54:18: Loading UI files
04/12/2011 09:54:18: Application constructed
04/12/2011 09:54:18: Initialising table 'version'
04/12/2011 09:54:18: Initialising table 'channel'
04/12/2011 09:54:19: Initialising table 'epg_event'
04/12/2011 09:54:19: Initialising table 'epg_event_text'
04/12/2011 09:54:19: Initialising table 'scheduled_recording'
04/12/2011 09:54:19: Initialising table 'version'
"
and then again:
"
matteo@matteo-Vostro1510:~$ me-tv -v
Me TV 1.3.6
04/12/2011 10:14:53: Application constructor
04/12/2011 10:14:53: sqlite3_threadsafe() = 1
04/12/2011 10:14:53: Database 'exists'
04/12/2011 10:14:53: Opening database file '/home/matteo/.local/share/me-tv/me-tv.db'
04/12/2011 10:14:53: Loading UI files
04/12/2011 10:14:53: Application constructed
04/12/2011 10:14:53: Initialising table 'version'
04/12/2011 10:14:53: Required Database version: 6
04/12/2011 10:14:53: Actual Database version: 0
##<--- at that point a pop up tells me 2 options: ESC or erase the old data in the database. I choose to erase.
04/12/2011 10:15:07: Dropping Me TV schema
04/12/2011 10:15:07: Dropping table 'channel'
04/12/2011 10:15:07: Dropping table 'epg_event'
04/12/2011 10:15:07: Dropping table 'epg_event_text'
04/12/2011 10:15:07: Dropping table 'scheduled_recording'
04/12/2011 10:15:07: Dropping table 'version'
04/12/2011 10:15:07: Vacuuming database
04/12/2011 10:15:07: Initialising table 'channel'
04/12/2011 10:15:07: Initialising table 'epg_event'
04/12/2011 10:15:07: Initialising table 'epg_event_text'
04/12/2011 10:15:07: Initialising table 'scheduled_recording'
04/12/2011 10:15:07: Initialising table 'version'
"
and again it stops.
What could it be?
Thanks a lot.
MT

Question information

Language:
English Edit question
Status:
Solved
For:
Me TV Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

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

A work around was found. We put a virgin database file in place then start me-tv.

Revision history for this message
Matteo Trentin (trentin-matteo) said :
#3

Excellent!
Solved.

Matteo

Revision history for this message
Dan N. (xdanieln) said :
#4

Hello.
I have got same problem on

$ uname -a
Linux io 3.2.0-12-generic #20-Ubuntu SMP Fri Jan 27 23:05:03 UTC 2012 i686 athlon i386 GNU/Linux
$ me-tv --help
Me TV 1.3.6

What do you mean by 'We put a virgin database file in place then start me-tv.'?

Thanks a lot.

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

HI Dan,

I gave him an empty me-tv database file and he put it
in ~/.local/share/me-tv/me-tv.db.

When I'll get home, I'll send it to you.

Cheers,
Fred

On Mon, Jan 30, 2012 at 10:45 AM, Dan N. <
<email address hidden>> wrote:

> Question #180863 on Me TV changed:
> https://answers.launchpad.net/me-tv/+question/180863
>
> Dan N. posted a new comment:
> Hello.
> I have got same problem on
>
> $ uname -a
> Linux io 3.2.0-12-generic #20-Ubuntu SMP Fri Jan 27 23:05:03 UTC 2012 i686
> athlon i386 GNU/Linux
> $ me-tv --help
> Me TV 1.3.6
>
> What do you mean by 'We put a virgin database file in place then start
> me-tv.'?
>
> Thanks a lot.
>
> --
> 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
Dan N. (xdanieln) said :
#6

Hello Frédéric,

thanks in advance.

Dan

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

Here's the file:
http://inom.tk/fc/me-tv.db

On Mon, Jan 30, 2012 at 11:30 AM, Dan N. <
<email address hidden>> wrote:

> Question #180863 on Me TV changed:
> https://answers.launchpad.net/me-tv/+question/180863
>
> Dan N. posted a new comment:
> Hello Frédéric,
>
> thanks in advance.
>
> Dan
>
> --
> 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
Dan N. (xdanieln) said :
#8

Thank you very much for the db file.
It helped me get through "Initialising table 'version'".
But it seems, that there is another problem (posibly becase I use alfa development branch of the system).
I can tune the channels, but then when I finish adding the tuned channels, me-tv freeze.

Once again thank you for your help.

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

Is me-tv freezing or the picture ?

If it's me-tv, can you start it with the command: "me-tv -v > metv.log"
(without the double quote) and send me the metv.log file.

If it's the picture, follow the instruction in this FAQ:
https://answers.launchpad.net/me-tv/+faq/823

On Mon, Jan 30, 2012 at 9:00 PM, Dan N. <
<email address hidden>> wrote:

> Question #180863 on Me TV changed:
> https://answers.launchpad.net/me-tv/+question/180863
>
> Dan N. posted a new comment:
> Thank you very much for the db file.
> It helped me get through "Initialising table 'version'".
> But it seems, that there is another problem (posibly becase I use alfa
> development branch of the system).
> I can tune the channels, but then when I finish adding the tuned channels,
> me-tv freeze.
>
> Once again thank you for your help.
>
> --
> 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
Dan N. (xdanieln) said :
#10

I do like this:
* start me-tv
* because I have no channel in db, I see Me TV - Scan Wizard,
   so, I import one channel from channels.conf (product of w_scan),
   I choose channels.conf file, click to Next, select one channel,
   click to Add
* now I Me TV - Channels Editor
* my one channel is selected, so I click on the OK button

It was my last step, now I can do nothing. I see two windows
- Channels Editor and main window Me TV. When I move
to another virtual desktop and back (for example),
then I see these two windows only with window decoration,
but with nothing in them.

So I have to kill the application, for example with ctrl + c
from terminal. (So, nothing change in me-tv.db)

metv.log is here:
http://www.edisk.cz/stahni/32607/metv.log_8KB.html

When I don't import and don't tune any channels,
so I can using application without problem
(except that I have no channel):
http://www.edisk.cz/stahni/69192/metv2.log_4.93KB.html

Have a nice day.

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

Hi,

Sorry for the delay. We have setup a PPA for the latest development version
here:
https://launchpad.net/~me-tv-development/+archive/ppa

Have a nice day,
Frederic

On Tue, Jan 31, 2012 at 1:40 PM, Dan N. <
<email address hidden>> wrote:

> Question #180863 on Me TV changed:
> https://answers.launchpad.net/me-tv/+question/180863
>
> Dan N. posted a new comment:
> I do like this:
> * start me-tv
> * because I have no channel in db, I see Me TV - Scan Wizard,
> so, I import one channel from channels.conf (product of w_scan),
> I choose channels.conf file, click to Next, select one channel,
> click to Add
> * now I Me TV - Channels Editor
> * my one channel is selected, so I click on the OK button
>
> It was my last step, now I can do nothing. I see two windows
> - Channels Editor and main window Me TV. When I move
> to another virtual desktop and back (for example),
> then I see these two windows only with window decoration,
> but with nothing in them.
>
> So I have to kill the application, for example with ctrl + c
> from terminal. (So, nothing change in me-tv.db)
>
> metv.log is here:
> http://www.edisk.cz/stahni/32607/metv.log_8KB.html
>
>
> When I don't import and don't tune any channels,
> so I can using application without problem
> (except that I have no channel):
> http://www.edisk.cz/stahni/69192/metv2.log_4.93KB.html
>
> Have a nice day.
>
> --
> 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"