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
CREATE TABLE `tracks` (
`id` int(10) unsigned NOT NULL auto_increment,
`url` text collate utf8_unicode_ci NOT NULL,
When I run SHOW CREATE TABLE tracks, it reports character set utf8, not
collate utf8_unicode_ci.
CREATE TABLE tracks (
id int(10) unsigned NOT NULL auto_increment,
url
Phil Meyer;146870 Wrote:
When I run SHOW CREATE TABLE tracks, it reports character set utf8,
not collate utf8_unicode_ci.
I think I have found the problem. The 7.0 database upgrade in
slimserver doesn't create the same database if you do a clean install
of 7.0a1 compared to if you have
If you wan't to solve the problem in your setup, I would recommend that
you make sure you have backups and then drop all standard slimserver
database tables and restart slimserver. This should re-create all
standard slimserver tables with the correct collate settings and also
make it work with
Phil Meyer;147076 Wrote:
Is it enough to simply drop the tables, or should I delete the database
and recreate it?The settings are stored in the table definitions so it should
be enough
to just drop the tables, that work for me at least. Dropping the whole
database will also work of course.
Solution 1 (If you have access to the mysql db using a database tool)
=
1. Take a backup of the TrackStat data unless you don't have a backup
2. Connect with a database tool and run:
alter table track_statistics convert to
Phil Meyer;146796 Wrote:
Should there be something in the CREATE TABLE statements to force the
correct character encodings?
The reason that I don't do it in the CREATE TABLE statement is that I
wan't it to also work on 6.5.0 which don't have the collate part.
Phil Meyer;146796 Wrote:
If
This is what I see in the log with trackstat debugging turned on when I
navigate to TrackStat / Songs / Most played songs recently played:
2006-10-15 10:35:48.5539 TrackStat: Entering baseWebPage
2006-10-15 10:35:48.5560 TrackStat: Get statistic context for level=1
2006-10-15 10:35:48.5562
Phil Meyer;146338 Wrote:
This is what I see in the log with trackstat debugging turnedYes I know, but
I would like to see the log at startup of slimserver.
TrackStat 1.29.1 and later makes a database table conversion of
trackstat tables at startup, this is required when the slimserver
Sorry, misinterpretted what you were asking for :)
2006-10-15 10:56:43.8270 TrackStat: initialising
2006-10-15 10:56:43.9048 TrackStat: Hook activated.
2006-10-15 10:56:43.9050 TrackStat::Storage: Checking if track_statistics
database table exists
2006-10-15 10:56:43.9074 TrackStat::Storage:
Phil Meyer;146343 Wrote:
Sorry, misinterpretted what you were asking forStrange, it looks like they
already have been converted, but the errors
later on indicates that they haven't.
Do you know if you might have shutdown slimserver in the middle of the
conversion process the first time you
Phil Meyer;146112 Wrote:
I notice that when I start slimserver 7.0 with --d_plugins, the
TrackStat plugin reports the following:
2006-10-14 09:05:02.5978 Requiring Plugins::TrackStat::Plugin plugin.
2006-10-14 09:05:02.8205 Database error: Illegal mix of collations
Are you running 1.29.1 ? If not you will need to upgrade.
Yes, I am running 1.29.1.
I also see this error in the log now when I select any stats option in the
WebUI.
Phil
___
plugins mailing list
plugins@lists.slimdevices.com
Phil Meyer;146147 Wrote:
Are you running 1.29.1 ? If not you will need to upgrade.
Yes, I am running 1.29.1.
Could you turn on TrackStat debugging and restart slimserver and post
the logfile ?
If it is doing database conversion you should see something like this
in the log at startup:
Code:
I tried 7.0 and it works perfecly here so there might be something
special with your setup that is causing this. The best idea is probably
if you could startup slimserver with TrackStat debugging enabled and
post the log as I mentioned in my previous post.
--
erland
Erland Isaksson
'My
This should now be corrected in the 1.13 release.
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
erland's Profile:
16 matches
Mail list logo