[GCWB]

SOLVED

If someone could re-name this thread to 'solved' so that if anyone has a similiar problem they will easily find the thread and solution. I realise it may not be a common problem, but still, a solution to a problem is much easier than a repost!

THIS THREAD HAS BEEN REPOSTED SO FOR A MORE APPROPRIATE AUDIENCE. (one of the members told me to, I'm not just spamming across the boards)

Information
10.6.7 - OSX Version
Macbook Pro - Platform
DMG - Install Method
Couldn't find - SVN Revision (See below.)
Can be seen below - Detailed Instructions to Reproduce the Problem (The more specific the better.)

System Specs
Macbook Pro 2010
2.66Ghz Core i7
8GB Ram
256GB SSD

Log
Log is here. If I've somehow recorded the log wrong, please inform me.
http://pastebin.com/9vSrQqyj
ps this thread has been long because I've journaled everything I've tried. You only need to read the first few para's to understand the issue.

Issue
Just as a heads up, I'm efficient with computers, but am not aware as many of you when it comes to XBMC, however I learn quickly. So bare with me.
My library has been fully operational for the last year or so, and I have a film collection of around 480 at the moment. The problem is this:

About half hour ago, I uploaded a new batch of around 5 films that I had recently ripped from my DVD and BLU-RAY collection. After the upload, XBMC now claims that there are no videos. However the 'Recently uploaded' playlist is still active and is still fully operational (If I click a film, it plays), much like the 'Fav' section, which all links are active too. Then again, playlists aren't active. (on further analysis it's because Favs uses direct links to the files, playlists don't) This issue, only applies to my Movies, my TV shows work absolutely fine.

Here is a picture of what I am seeing. As you can see the Movie count is at 0.



and When I click 'Movies'



edit2: After further inspection, I recovered my 'Videos' tab to see if my films would appear. Low and behold, they are there, and work fine with all their album artwork. However what's interesting is that when it's IN library mode, my 'Films' directory does not exist. It's not there. When out of library mode, it is there.



As you can see, background fan art for the movies is still working. It seems that XBMC knows the films are there, all the links are intact, yet it's lost the file which connects all the artwork, films and all that together? This is me out on a limb, I'm really stabbing in the dark and would appreciate some help!

I checked the 'sources' file in the XBMC directory, and as you can see here, the link is perfectly fine. (I have checked, the name of the directory is unchanged)



I remember explicitly that before I uploaded them, I went into my movies (in XBMC) to have a gander at what film I might watch tonight. Everything was intact and all artwork was there. Whatever happened, happened because of the upload. Which makes no sense...

Right?

What I've Tried - You really don't need to read this, if you can understand the log (I am not really educated in that kind of thing Yet) then just read from there, or help me implement the proposed solution below
<*>I just re-scraped all my files, thankfully I had already exported the data before this little incident happened.
It didn't help. I saw each film name being scanned in, yet it still gives me the same screen. I completely understand that I'm being impatient, it's just I am going on holiday tomorrow, and would like to give the rest of my family a chance to pick the films which we will bring with us on the iPad.
If you're reading this and have a potential fix. Please, Please Respond.
I don't know what to do, I think I'll try a reinstall, there must be something wrong with a code, or maybe a conflicting plugin.

<*>I have installed a particular media managing application, to manage my .nfo's, to see if I could find out the problem. It detects the TV shows fine, yet nothing comes up for the films. This all more and more hints that XBMC's link between the film library is broken.

<*>Whilst it's watchable solely using the library in the video section (I am using Aeon), it's not how XBMC should work, it is an ugly compromise. I just rescraped using IMDB instead themoviedb to no avail. The other day I got a bit trigger happy enabling a ton of plugins, and I can't help but feel this is the reason. I am about to disable plugin by plugin to see if this will fix it. Update soon!

<*>No progress with disabling plugins. I know I'm really trying trial and error here, but I am not getting anywhere. If anybody could direct me to the file that contains the data referencing the movie information?

<*>I am going to try and delete the guisettings file, see if that will do anything (obviously I will back it up). But hey, maybe if I delete important files, XBMC will recreate them? Fixing any errors that existed before? I mean, all my metadata is exported, so it's not like I'd be losing anything if I corrupted my XBMC software up. Here goes!

<*>Okay, I deleted my guisettings file first, to no avail, just reset the skin (as expected). So put it back. Then deleted the sources file, hoping that there would be a directory issue, yet again to no avail.
My next plan of action will to be reinstall XBMC.
Here goes!

<*>XBMC has been reinstalled. To no frickin' avail. It seems the files were left intact, all the sources and film directories were not removed with the uninstall.

<*>I'm all out of options. There must be an answer to starting afresh? Or even better, a solution to my issue? Please?

<*>When the files are re-scraped, they are exactly that, re-scraped, they show up in the Recent part on the home screen, however not in Movies. What is going on!?!?! Next I plan to remove/move all the films that I have put in since the issue, maybe a file is causing the problem. After this, I really am stumped. Here goes!

Similiar Links
http://forum.xbmc.org/showthread.php?tid=60614
http://forum.xbmc.org/showthread.php?tid=94324
http://forum.xbmc.org/showthread.php?tid=70676
These are a few threads that seem similiar to mine, but I tried their options to no avail.

Proposed Solution That I Don't Know How to Implement - Instructions Needed (Beginner, Steps Needed)
(edited quote for important parts)

As I've mentioned before, I'm a beginner, but I am handy with computers and learn quickly. I just don't know what GIT, SQL or VFS is, enlightenment would be appreciated.

Read this thread, log into your MySQL instance and apply the commands in this post.

You should be fine, that resolved my issue and my library is back.

On a final note, Thank you for taking the time to read and/or replying to my thread. If I sounded impatient in this thread at all, it's because I am, I leave for holiday tomorrow and just want to get it out of the way. Usually I would wait at least a few days before I start to moan about no responses. I hope I formatted this thread well enough for an eyecandy read

[Hudson_Hawk04]

just enable debug logging in xbmc, then pull it the old fashioned way.

[GCWB]

just enable debug logging in xbmc, then pull it the old fashioned way.

Pull what? Sorry. What are you referring to?
I've been editing the thread for the last 10 minutes, so maybe I've put in what you are talking about?

[jmarshall]

Turn debug logging on and grab the log. It will tell you exactly what is going on. If you can't figure it out from there, then post the debug log on pastebin and others will assist.

The first thing to do with any such situation is to check the debug log - it tells you what is going on.

[GCWB]

Turn debug logging on and grab the log. It will tell you exactly what is going on. If you can't figure it out from there, then post the debug log on pastebin and others will assist.

The first thing to do with any such situation is to check the debug log - it tells you what is going on.

I already have. It's the third underlined word named "log". (didn't mean that in a patronising way, it just sounds patronising, and however I phrase it, it just seems to sound patronising - lol)

[jmarshall]

Forgive me - I overlooked it given the 12300350129450 other words and pictures in your post :p

The problem is:

SQL: The database disk image is malformed
Query: select count(1), count(playCount), movieview.* from movieview group by lastPlayed

Your only option is to delete the file (MyVideos*.db). You can do this via XBMC's own filemanager if you wish - it will be located within the userdata/Database folder.

NOTE: Depending on your version, you may be able to get away with just deleting the db's with the highest database numbers. I suggest backing them up first, and delete from the highest database number down until you get your db back - it will auto-update itself again to the latest version.

Cheers,
Jonathan

[GCWB]

Forgive me - I overlooked it given the 12300350129450 other words and pictures in your post :p

The problem is:



Your only option is to delete the file (MyVideos*.db). You can do this via XBMC's own filemanager if you wish - it will be located within the userdata/Database folder.

NOTE: Depending on your version, you may be able to get away with just deleting the db's with the highest database numbers. I suggest backing them up first, and delete from the highest database number down until you get your db back - it will auto-update itself again to the latest version.

Cheers,
Jonathan

Haha I apologise, I wanted to give as Much information as possible as to reduce any questions posed by the problem. I tried to organise it as best as possible with the underlined words!

I'll give what you're on about a go. I know about the MyVideos.db file, as I've been exploring the directory and using trial and error deletion already, so il try your 'note' before deleting MyVideos. I have a vague idea of what you mean, so I'll just get trigger happy on deleting and restarting XBMC, whatever happens, it's all backed up so nothing bad can come from it.

Note: I regularly Export all my data to seperate folders for each film, so deleting the 'MyVideo.db' isn't anywhere as bad as it could have been.

Edit: Well, I'm now refreshing the sources and What Do Ya Know, the films are returning, thank-you very much for your help! This is a huge burden off my shoulder.
If I may ask, do you know how this could have happened? Just so for the future, and in the best interest of avoiding such an issue again?

Problem Solved.

Thanks again.

[GCWB]

Urm, unrelated question, but seeing as I have a thread open anyway. When just browsing around my XBMC, and whilst importing my TV shows (not sure if they are connected) I received an error saying 'Script Failed! : Recently added.py' or something along the lines of that...
Should I Post another log or is there a quick solution to that?

I don't know what the consequence of this error is yet...

[GCWB]

You are given 20pounds BONUS CASH when you register an account with Casino Riva. No deposit, No credit card needed. You can waste them on any Casino game.
This opportunity is now up for grabs for the first 1000 signups of the site. I advise that you Register here URL_REMOVED. You can also rate and review the site here - URL_REMOVED
After you have made your account, send an email to 'EMAIL_REMOVED' with the subject, 'SUBJECT_REMOVED'. Live it up

OMG Thank-you! Isn't this forum generous! This is a day of days indeed!

[jmarshall]

If you quote spam before a mod deletes it, please edit out any URLs - no point helping 'em.

The script failed is likely something else entirely.

Cheers,
Jonathan