Import stats from 1.4 into 2.0

[Seb Ruiz]

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
>



-- 
Seb Ruiz

http://www.sebruiz.net/
http://amarok.kde.org/