frodo and MYSQL
#16
Hi Koying,

Yes, MyVideos72 seems to get corrupted each time by XBMC.

Done a clean version, i.e. dropped the DB and removed directories from Mysql. and then started Frodo again. Frodo finds the Music DB from Eden and attempts to convert it, and when it finds the MyVideos60 it fails/error. The failure creates a DB that contains the files that were in the 60 DB but not as movies. This is the same thing that happens when I try to scrape in XBMC. The files seem to scrape, but are not recognised as Movies etc, (Here is the log http://pastebin.com/avi7Fa4n )

Once again note that the early version of the DB still works perfectly and continues to update correctly from Eden (which I still have installed on another station).

Thanks again!

Cian
Reply
#17
(2012-11-19, 10:44)ciantm Wrote: Hi Koying,

Yes, MyVideos72 seems to get corrupted each time by XBMC.

Done a clean version, i.e. dropped the DB and removed directories from Mysql. and then started Frodo again. Frodo finds the Music DB from Eden and attempts to convert it, and when it finds the MyVideos60 it fails/error. The failure creates a DB that contains the files that were in the 60 DB but not as movies. This is the same thing that happens when I try to scrape in XBMC. The files seem to scrape, but are not recognised as Movies etc, (Here is the log http://pastebin.com/avi7Fa4n )

Once again note that the early version of the DB still works perfectly and continues to update correctly from Eden (which I still have installed on another station).

Thanks again!

Cian

In addition here is a log of the next restart of XBMC Frodo after the above log. This one is a crash http://pastebin.com/ngMbYVpt

Reply
#18
Try the next nightly - there were changes to the trigger statement which may have an influence. You'll need to remove your v72 database using mysql.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#19
(2012-11-19, 11:50)jmarshall Wrote: Try the next nightly - there were changes to the trigger statement which may have an influence. You'll need to remove your v72 database using mysql.

Last night's or tonights?!

Thanks
Reply
#20
@ciantm Just to be sure, could you

1) Remove MyVideos72
2) Provide the xbmc.log of the first run after deleting the db.

Subsequent runs find an invalid MyVideos72, which is what your logs show, but we cannot tell the root cause of the failed upgrade.
Reply
#21
That is exactly what I did as described in post #16.the subsequent log being http://pastebin.com/avi7Fa4n .

Then after another restart this was the log. http://pastebin.com/ngMbYVpt

Note that when I tried to scrape Movies one by one the database entries that were created, were not correct - and did not appear as movies, just as files, the same incorrect format that happens when the db upgrade 68->72 is attempted.

Thanks.
Reply
#22
Yeah sorry. Was not looking at the right log.
Indeed, the fix was merged in git yesterday ( https://github.com/xbmc/xbmc/commit/cd83...9f56c00977 )
Reply
#23
(2012-11-19, 14:01)Koying Wrote: Yeah sorry. Was not looking at the right log.
Indeed, the fix was merged in git yesterday (https://github.com/xbmc/xbmc/commit/cd83...9f56c00977 )

Great! ... 404 error on that link though. Will the fix be in the nightly build tonight? I already tried last night's.

Thanks,
Reply
#24
yes it will and the link just had the trailing ")" ... stupid forum Wink
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply
#25
Great. I will give an update in the morning.

Thanks! Smile
Reply
#26
(2012-11-19, 19:07)ciantm Wrote: Great. I will give an update in the morning.

Thanks! Smile

No sign of any nightlies - I'll keep waiting!! Smile
Reply
#27
No sign of any nightlies? Where are you looking at?

http://mirrors.xbmc.org/nightlies/osx/

grab the latest ...
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply
#28
Aha... I am looking for Win32 ones ... (he says knowing that this is OSX section of the forum, but it was where he landed when he searched +Frodo +Mysq being the only thread discussing the issuel!!)

Would this mean that the above issue has only been addressed in OSX and not in Win32?

Thanks
Reply
#29
Do I need to re-post - start again in Windows Support on the same topic?

Thanks
Reply
#30
No. Looks like the Win32 nighty had a hiccup. Please wait for the next one.
Reply

Logout Mark Read Team Forum Stats Members Help
frodo and MYSQL0