Login at Kodi Home

bred_pitt · 2013-01-24, 09:53

I just installed the rom collection browser in xbmc frodo and have trouble with adding pictures to some games. It seems they are not known by the scrapers and manual editing is not possible from inside xbmc. Editing the .nfo-file for such a game doesn't change anything. I don't wanna re-run the indexing because the addon seems to ignore the already downloaded stuff and redownloads everything. This takes quiet some time. I already chose nfo and fanart as the two primary scrapers. But for most games it re-downloads everything when I run an update manually.

I know RCB uses mysql and therefore I installed sqliteman in ubuntu. I opened the game-database but just don't know how to edit it. When looking for the game sqliteman doesn't find it. Are there some tutorials or alike for adding games manually?

malte · 2013-01-24, 10:44

Usually RCB should not redownload artwork if it is already available. You don't need to add the games to the nfo (this information is ignored anyway). You can try with single games if you use "Rescrape game" from context menu. Use the "local artwork" scraper and you should be fine.

Please show me your log file if you still have problems with this task. I will also check myself that RCB does not redownload artwork if not needed.

bred_pitt · 2013-01-24, 11:06

Rescraping a game is not possible. XBMC is freezing then. I have to kill it from the commandline when trying.

This is my log:

Quote:10:00:20 T:140690268858112 NOTICE: Previous line repeats 1 times.
10:00:20 T:140690268858112 NOTICE: Thread XBPyThread start, auto delete: false
10:00:20 T:140690268858112 NOTICE: -->Python Interpreter Initialized<--
10:00:20 T:140690268858112 NOTICE: sys.argv = ['script.games.rom.collection.browser']
10:00:20 T:140690268858112 NOTICE: param = script.games.rom.collection.browser
10:00:20 T:140690268858112 NOTICE: setting launchRCB = True
10:00:20 T:140690268858112 NOTICE: launchRCB = True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Loading sqlite3 as DB engine
10:00:20 T:140690268858112 NOTICE: RCB: init log level
10:00:20 T:140690268858112 NOTICE: RCB: current log level: 2
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Loading sqlite3 as DB engine
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Path to configuration file: /home/mediapc/.xbmc/userdata/addon_data/script.games.rom.collection.browser/config.xml
10:00:20 T:140690268858112 NOTICE: RCB_INFO: XBMC version: Assuming we are on Eden
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Init Rom Collection Browser: /home/mediapc/.xbmc/addons/script.games.rom.collection.browser
10:00:20 T:140690268858112 NOTICE: RCB_INFO: RCB version: 2.0.0
10:00:20 T:140690268858112 NOTICE: RCB_INFO: RCB service addon: <xbmcaddon.Addon object at 0x7ff5182288f0>
10:00:20 T:140690268858112 NOTICE: RCB_INFO: checkUpdateInProgress
10:00:20 T:140690268858112 NOTICE: RCB_INFO: scrapeOnStartupAction =
10:00:20 T:140690268858112 NOTICE: /home/mediapc/.xbmc/userdata/addon_data/script.games.rom.collection.browser/MyGames.db
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Path to configuration file: /home/mediapc/.xbmc/userdata/addon_data/script.games.rom.collection.browser/config.xml
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Reading config version from config.xml: 1.0.6
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Config file is up to date
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin readXml
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Path to configuration file: /home/mediapc/.xbmc/userdata/addon_data/script.games.rom.collection.browser/config.xml
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin readRomCollections
10:00:20 T:140690268858112 NOTICE: RCB_INFO: current Rom Collection: SNES
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Rom path: /media/Festplattenarray/SNES-Roms/*.smc
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Rom path: /media/Festplattenarray/SNES-Roms/*.sfc
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Rom path: /media/Festplattenarray/SNES-Roms/*.fig
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Rom path: /media/Festplattenarray/SNES-Roms/*.SMC
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Media path: /media/Festplattenarray/Vorlagen/boxfront/%GAME%.*
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Media path: /media/Festplattenarray/Vorlagen/boxback/%GAME%.*
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Media path: /media/Festplattenarray/Vorlagen/cartridge/%GAME%.*
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Media path: /media/Festplattenarray/Vorlagen/screenshot/%GAME%.*
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Media path: /media/Festplattenarray/Vorlagen/fanart/%GAME%.*
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper site: SNES
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: SNES
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper site: local nfo
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: local nfo
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper site: giantbomb.com
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: giantbomb.com
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Image Placing name: gameinfobig
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Image Placing name: gameinfosmall
10:00:20 T:140690268858112 NOTICE: RCB_INFO: emulatorCmd: /usr/bin/zsnes
10:00:20 T:140690268858112 NOTICE: RCB_INFO: emulatorParams: -ad pulse "%ROM%"
10:00:20 T:140690268858112 NOTICE: RCB_INFO: ignoreOnScan: False
10:00:20 T:140690268858112 NOTICE: RCB_INFO: allowUpdate: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: useEmuSolo: False
10:00:20 T:140690268858112 NOTICE: RCB_INFO: usePopen: False
10:00:20 T:140690268858112 NOTICE: RCB_INFO: autoplayVideoMain: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: autoplayVideoInfo: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: useFoldernameAsGamename: False
10:00:20 T:140690268858112 NOTICE: RCB_INFO: maxFolderDepth: 99
10:00:20 T:140690268858112 NOTICE: RCB_INFO: doNotExtractZipFiles: False
10:00:20 T:140690268858112 NOTICE: RCB_INFO: diskPrefix: _Disk
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: local nfo
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: archive.vg
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: mobygames.com
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: thegamesdb.net
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: SNES
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: maws.mameworld.info
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper Site: giantbomb.com
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Scraper descFilePerGame: True
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin cacheItems
10:00:20 T:140690268858112 NOTICE: RCB_INFO: End cacheItems
10:00:20 T:140691470391168 WARNING: Trying to add unsupported control type 1
10:00:20 T:140691470391168 WARNING: Previous line repeats 1 times.
10:00:20 T:140691470391168 ERROR: Control 500 in window 13000 has been asked to focus, but it can't
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin onInit
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin loadViewState
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin showConsoles
10:00:20 T:140690268858112 NOTICE: RCB_INFO: begin showFilterControl: 500
10:00:20 T:140690268858112 NOTICE: RCB_INFO: End showConsoles
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin showGenre
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Selected Console: 2
10:00:20 T:140690268858112 NOTICE: RCB_INFO: begin showFilterControl: 600
10:00:20 T:140690268858112 NOTICE: RCB_INFO: End showGenre
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin showYear
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Selected Console: 2
10:00:20 T:140690268858112 NOTICE: RCB_INFO: begin showFilterControl: 700
10:00:20 T:140690268858112 NOTICE: RCB_INFO: End showYear
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Begin showPublisher
10:00:20 T:140690268858112 NOTICE: RCB_INFO: Selected Console: 2
10:00:20 T:140690268858112 NOTICE: RCB_INFO: begin showFilterControl: 800
10:00:20 T:140690268858112 NOTICE: RCB_INFO: End showPublisher
10:00:21 T:140690268858112 NOTICE: RCB_INFO: Begin showCharacterFilter
10:00:21 T:140690268858112 NOTICE: RCB_INFO: End showCharacterFilter
10:00:21 T:140690268858112 NOTICE: RCB_INFO: Begin showGames
10:00:21 T:140690268858112 NOTICE: RCB_INFO: helper.buildLikeStatement
10:00:21 T:140690268858112 NOTICE: showGames: load games from db in 10 ms
10:00:21 T:140690268858112 NOTICE: RCB_INFO: showGames: load 172 games to list in 639 ms
10:00:21 T:140690268858112 NOTICE: RCB_INFO: End showGames
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: Begin showGameInfo
10:00:21 T:140690268858112 NOTICE: RCB_INFO: End showGameInfo
10:00:21 T:140690268858112 NOTICE: RCB_INFO: End loadViewState
10:00:21 T:140690268858112 NOTICE: RCB_INFO: End onInit
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107
10:00:21 T:140690268858112 NOTICE: RCB_INFO: onAction: 107

10:00:30 T:140690268858112 NOTICE: RCB_INFO: onAction: 3
10:00:30 T:140690268858112 NOTICE: RCB_INFO: Begin showGameInfo
10:00:30 T:140690268858112 NOTICE: RCB_INFO: End showGameInfo
10:00:31 T:140690268858112 NOTICE: RCB_INFO: onAction: 4
10:00:31 T:140690268858112 NOTICE: RCB_INFO: Begin showGameInfo
10:00:31 T:140690268858112 NOTICE: RCB_INFO: End showGameInfo
10:00:31 T:140690268858112 NOTICE: RCB_INFO: onAction: 117
10:00:31 T:140690268858112 NOTICE: RCB_INFO: init ContextMenu
10:00:31 T:140690268858112 NOTICE: RCB_INFO: onInit ContextMenu
10:00:34 T:140690268858112 NOTICE: RCB_INFO: Begin rescrapeGames

Sorry, can't post the full log because it's too long for the forum's system.

malte · 2013-01-24, 12:13

You could use http://xbmclogs.com/ to paste your full log and post the link here. This will help me finding out what is going on.

bred_pitt · 2013-01-24, 21:33

It's not that much missing. The text I posted shows the last usage of XBMC. I did cut a few lines at the bottom, where you can see an empty line.

The deleted lines all read something like this:

Quote:NOTICE: RCB_INFO: onAction: 107

with changes in the number. They looked to me like keypresses - so I deleted them.

malte · 2013-01-25, 12:45

Works for me on Windows without problems. Will try to test this on Ubuntu at the weekend.

bred_pitt · (This post was last modified: 2013-01-27, 13:19 by bred_pitt.)

Don't know...maybe it's because I'm using the frodo-release of xbmc in ubuntu. The RCB seems to be full of bugs for me. I just tried adding a new rom-collection: First scraper - local artwork, 2nd scraper mobygames, 3rd scraper giantbomb - hit OK...nothing happens. After choosing local artwork as the third option, the indexing finally did start.

Or try this one: Navigate to a game and in menu chose to mark selection as favorite...all games are marked as favorite afterwards.

Another bug: Try importing a new collection as described before, watch how it fails. Afterwards the game-list is empty. Exit and open RCB again...romlist is back again.

Also, some games have broken names. There is just garbage between some letters in the title. I need a way to fix them. No chance with sqliteman. It's just too difficult for me to use.

I just noticed the old "successfull" game import did only index about 65% of the games present in the indexed folders. Some games without game-infos are present in the database. Meaning such games are not hidden in the list. The whole thing is just buggy!

malte · 2013-01-28, 08:58

Please, if you think you found a bug, help me fixing it and provide proper information. It is explained in the FAQ how to do it. Sorry, but otherwise its just ranting.

bred_pitt Wrote:I just tried adding a new rom-collection: First scraper - local artwork, 2nd scraper mobygames, 3rd scraper giantbomb - hit OK...nothing happens. After choosing local artwork as the third option, the indexing finally did start.

The local artwork scraper is designed to update your existing rom collection with new artwork. As it does not add any game information (like title) it will not work when adding new collections. Anyway, all other scrapers (online and offline) will check your artwork folders too, so it is not necessary to use the "local artwork" scraper during an initial import.

Maybe this was not clear, so I updated the wiki with this information.

bred_pitt Wrote:Or try this one: Navigate to a game and in menu chose to mark selection as favorite...all games are marked as favorite afterwards.

There are two options in the context menu: "Add Game to Favorites" and "Add Selection to Favorites". I guess you just picked the wrong one. Both options are working fine for me.

bred_pitt Wrote:Another bug: Try importing a new collection as described before, watch how it fails. Afterwards the game-list is empty. Exit and open RCB again...romlist is back again.

Yes, I noticed this too. Has to be fixed.

bred_pitt Wrote:Also, some games have broken names. There is just garbage between some letters in the title. I need a way to fix them. No chance with sqliteman. It's just too difficult for me to use.

Please give me examples of some games: rom name, broken name in RCB and the scrapers that you used to import the games.

I use sqlitestudio to do manual changes to the db. It works fine and is easy to use. Changing simple properties can be done the excel-way (it is all in the table "Game"). More complex tasks like changing artwork or replace developer/publisher would require some more knowledge about the database structure.

bred_pitt Wrote:I just noticed the old "successfull" game import did only index about 65% of the games present in the indexed folders. Some games without game-infos are present in the database. Meaning such games are not hidden in the list.

RCB writes a lot of information to the log while doing the import. Without this information I have no chance to see what is going on.

bred_pitt · 2013-01-28, 09:49

Man seriously, your add-on is gorgeous but full of bugs. I believe you don't wanna find them. I just tried to add a new rom-collection. This time N64-roms. It just didn't import anything - in several runs. It first downloaded sutff for all the games. Afterwards the list was empty. Restart, reboot - nothing helped. I don't file bug-reports for every problem I found. They are too many. Maybe it's just because of frodo - it's not finished yet and many other add-ons fail to work.

Example: Advanced Launcher just erased some of the entries. This is actually a bug to file. Because it's the only one I found. The rest is running fine.