hi all
I am using mmw 4.1.26
from reading a thread:
How Do You "Delete" A Portable Device?
http://www.mediamonkey.com/forum/viewtopic.php?t=60662
I installed the SQL-Viewer 2.4 script, which is supposed to work from mm 3 and above
as from above thread it says:
"If you are comfortable using the sql viewer script, you can use this sql statement to identify the device id's
SELECT * FROM Medias "
which is strange as i am looking to delete DEVICES not MEDIAS...
so what happens:
SELECT * FROM Medias " ... actually gives me devices table! ???
can anybody reproduce this?
is this in any way related to this script being quite old ?..
more weird is that attempting to run from either using "medias" or "devices" sometimes gave me the expected results and some others the unexepcted as I mentioned eariler
how silly was I, that eventually (to clean the devices list) run: DELETE FROM Medias WHERE IDMedia <= 100
whereas, logically, I should have used "devices" , I didn't...(as medias seemed to work)
and then i got the the actual "medias" table wiped out (not devices).
and after doing maintenance to the mm db, it mean most of my db was wiped out: the tracks (lucklily i do have som back up from a couple of months ago, though I have not yet relaoded it)
regardless , now when i run "select * from devices" (from the wiped db) it doesnt give the full list of (actual) devices, but just a few (1 to 4)
if i run the same "select * from devices" using another sql manager (SQLiteStudio 3.1)
.. it does return all the devices (being 216)...
if i run "select * from medias" it shows me the same 4 remaining medias (that were not wiped) on both sql managers
but how on the earth the same (devices) query gives me different results (as said above as from using differente engines)???