Import stats from 1.4 into 2.0

[Rich]

Hi

I tried the SQLite import, that worked fine.
I originally had some old entries in there before I enabled MySql in 1.4.

Thanks, I found the table after looking a bit deeper. :)

So I ran the sql in the mysql db to see why it wasnt being detected.
I found the deviceid in the stats table had 99% of the rows as -1
which matched NULL on the join.  So I issued an update to set
the deviceid to match a valid id in device table.  

I tried the import again it failed with no tracks to import.

When I run the query in mysql, I get 2600+ rows back.

I did notice many of my paths in the url column were never updated.
So I ran a script on the column to correct the path of the files.

I thought maybe it was a path issue.
So now I tried again, still not recognizing the tracks.

Since the songs were collected when I ran 2.02 for the first time,
this would generate a new unique id.  Would this be causing the
tracks not be picked up?

What determines a valid track in the import?



Thanks
Rich


Seb Ruiz wrote:
> 2009/3/15 Rich <budman85 at eastlink.ca>:
>   
>> Hi
>>
>> I tried importing old stats from mysql in amarok 1.4, but turns up with
>> no tracks found.
>>
>> I checked the source sql, the lastmountpoint column doesn't exist so the
>> import fails.
>> Is there another table missing or is this column not needed?
>>     
>
> The importer does a join on the device table, which contains this column.
>
> Are you getting any errors when running Amarok from the command line
> with the --debug option enabled?
>
>   
>> SELECT lastmountpoint, S.url, createdate, accessdate, percentage,
>> rating, playcounter, lyrics from statistics ORDER BY lastmountpoint, url;
>> ERROR 1054 (42S22): Unknown column 'lastmountpoint' in 'field list'
>> mysql> describe statistics;
>> +-------------+--------------+------+-----+---------+-------+
>> | Field       | Type         | Null | Key | Default | Extra |
>> +-------------+--------------+------+-----+---------+-------+
>> | url         | varchar(255) | NO   | PRI |         |       |
>> | deviceid    | int(11)      | NO   | PRI | 0       |       |
>> | createdate  | int(11)      | YES  |     | NULL    |       |
>> | accessdate  | int(11)      | YES  |     | NULL    |       |
>> | percentage  | float        | YES  | MUL | NULL    |       |
>> | rating      | int(11)      | YES  | MUL | 0       |       |
>> | playcounter | int(11)      | YES  | MUL | NULL    |       |
>> | uniqueid    | varchar(32)  | YES  | UNI | NULL    |       |
>> | deleted     | tinyint(1)   | YES  |     | 0       |       |
>> +-------------+--------------+------+-----+---------+-------+
>>
>>
>> Thanks
>> Rich
>> _______________________________________________
>> Amarok mailing list
>> Amarok at kde.org
>> https://mail.kde.org/mailman/listinfo/amarok
>>
>>     
>
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/amarok/attachments/20090315/d800b2de/attachment.html>