Release WatchedList - service to automatically save/restore watched state
(2017-09-09, 11:40)carsten888 Wrote: [...]
I would like to use .sql but in the config there is no export setting for that.
Do I first need to convert it .db to .sql?
Or how to open it in phpMyAdmin?
(2017-09-10, 08:00)carsten888 Wrote: @alexxxx
ok I installed the extra database program and it reads the .db file.

@watchlist @schapplm
Maybe someone should edit the wiki, as phpMyAdmin can not be used as suggested here:
http://kodi.wiki/view/Add-on:WatchedList#MySQL_Database

To clarify again:
  • .db is the file extension for SQLite databases, .sql is the default extension for mySQL-data, that is exported via phpmyadmin.
  • whether the addon uses SQLite or mySQL depends on the addon settings described in the wiki
  • if you want to use mySQL, you have to follow the instructions in the wiki, i.e. create the according database and make sure a server is running (only for advanced users)
  • You can convert your database from SQLite to mySQL like described in the wiki, but mySQL should not be needed any more if you sync watchedlist between different devices via Dropbox

(2017-09-06, 07:59)carsten888 Wrote: I get this message:
"0 movies and 0 episodes read from Kodi-DB"
there must be a fair number in there.

What am I overlooking?
(2017-09-10, 08:00)carsten888 Wrote: @all
My .db does not have any data. Structure is there, but no rows. When I run the script manually it says it can not read the kodi-DB.

if your watchedlist.db only contains the structure, there was no data written into it by the addon, probably due to the error reading the Kodi-DB (which is a different error probably unrelated to the mySQL/SQlite thing and which we will have to look into). The empty structure is automatically created when starting the WatchedList addon with SQLite setting activated.
All watched movies and episodes in your db should be imported. Check if the JSON queries from #88 return something.
My addon: service.watchedlist
My HTPC: Kodi 18.3; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Streacom FC8B Evo with 120W picoPSU
Reply
 
Thread Rating:
  • 3 Vote(s) - 5 Average


Messages In This Thread
RE: WatchedList - service to automatically save/restore watched state - by schapplm - 2017-09-18, 11:07


Logout Mark Read Team Forum Stats Members Help
WatchedList - service to automatically save/restore watched state53