<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi<br>
<br>
I tried the SQLite import, that worked fine.<br>
I originally had some old entries in there before I enabled MySql in
1.4.<br>
<br>
Thanks, I found the table after looking a bit deeper. :)<br>
<br>
So I ran the sql in the mysql db to see why it wasnt being detected.<br>
I found the deviceid in the stats table had 99% of the rows as -1 <br>
which matched NULL on the join. So I issued an update to set <br>
the deviceid to match a valid id in device table. <br>
<br>
I tried the import again it failed with no tracks to import.<br>
<br>
When I run the query in mysql, I get 2600+ rows back.<br>
<br>
I did notice many of my paths in the url column were never updated.<br>
So I ran a script on the column to correct the path of the files.<br>
<br>
I thought maybe it was a path issue.<br>
So now I tried again, still not recognizing the tracks.<br>
<br>
Since the songs were collected when I ran 2.02 for the first time,<br>
this would generate a new unique id. Would this be causing the <br>
tracks not be picked up?<br>
<br>
What determines a valid track in the import?<br>
<br>
<br>
<br>
Thanks<br>
Rich<br>
<br>
<br>
Seb Ruiz wrote:
<blockquote
cite="mid:60ebdd0b0903142213w1c36cc35ief52e73ddfc991cd@mail.gmail.com"
type="cite">
<pre wrap="">2009/3/15 Rich <a class="moz-txt-link-rfc2396E" href="mailto:budman85@eastlink.ca"><budman85@eastlink.ca></a>:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
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?
</pre>
<blockquote type="cite">
<pre wrap="">
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
<a class="moz-txt-link-abbreviated" href="mailto:Amarok@kde.org">Amarok@kde.org</a>
<a class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/amarok">https://mail.kde.org/mailman/listinfo/amarok</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>