just gonna hijack this thread for another question/problem ;-)

I recently found out that "DELETE UNUSED STATISTIC AFTER RESCAN" does
not work (on my system). the following is logged:

2006-10-21 22:29:46.6136 Database error: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'left join tracks on
track_statistics.url=tracks.url where tracks
2006-10-21 22:29:46.6142 Database error: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'left join tracks on
track_history.url=tracks.url where tracks.ur

I don't know why these message are truncted - Trackstat/Storage.pm
contains the full lines of course ...

system: Debian + SS6.5.1 (nightly, 2 days old) + included mysqld  +
Trackstat 1.30

Is this some error in the plugin/sql-statement or caused by invalid db
content maybe? (names with ' or something like this) 

thanks in advance and even more for one of my favorite plugins!
Markus


-- 
schiegl
------------------------------------------------------------------------
schiegl's Profile: http://forums.slimdevices.com/member.php?userid=6654
View this thread: http://forums.slimdevices.com/showthread.php?t=28653

_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins

Reply via email to