Re: [SlimDevices: Beta] latest 7.4 is broken
I'm running 27942 and there is no SQL that includes reference to albums.year - only album.year. -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal... SB3 (wired) - TACT 2.2X (Linear PSU) + Good Vibrations S/W - MF Triplethreat(Audiocom full mods) - Linn 5103 - Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Townsend Supertweeters, Blue Jeans Digital,Kimber Speaker Chord Interconnect cables Outdoors: Boom Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
hm, that rings a bell... more than one week ago I tried to change sort order by editing the browsedb.html and I remember being confused with album. and albums. too. But since then I did 3 re-installs and even deleted the whole directory I think. Could it be SC ALTHOUGH uses this old query? do i have any chance to see, where it'staken from? the link that's shown leads to http://127...:9000/browsedb.html?... I'd be very thankful. -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
With August 3 nightly (28008), my server's HD is spinning constantly (I figured it out when I stopped SC and it immediately stopped). Being as I don't want to kill me HD by having it spin in perpetuity, I have elected to leave things stopped for now, pending a fix of some sort. No separate server/PC for me yet and it was massively slowing my system down. If there's a log that would help, pls. tell me where to find it and I'll be glad to submit. Thanks!! -- Keymaster Keymaster's Profile: http://forums.slimdevices.com/member.php?userid=30281 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
frank1969;445882 Wrote: hm, that rings a bell... more than one week ago I tried to change sort order by editing the browsedb.html and I remember being confused with album. and albums. too. But since then I did 3 re-installs and even deleted the whole directory I think. Could it be SC ALTHOUGH uses this old query? do i have any chance to see, where it'staken from? the link that's shown leads to http://127...:9000/browsedb.html?... I'd be very thankful. Can't you just select to view the HTML source in the web browser and see if it contains your changes or not ? The browsedb.html file is taken from your Squeezebox Server installation directory from the file: If you use Default skin: - HTML/Default/browsedb.html If you use Classic or Fishbone skin: - HTML/EN/browsedb.html I'm guessing that you might also see your changes after the ? character in the url you listed. You could try to clear the web browser cache, although I don't think this is the problem. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
Today's Windows build 28065 takes a very long time to start. During the
startup process SqueezeSrv.exe hands control over to mysqld.exe and this
process hugs the CPU at 90%+ for over 12 minutes. I'm sure there is no
scanning being done during this period as scanner.exe process never
comes up.
On a couple occasions the SquezeSrv.exe crashed when I tried advance a
track using the progress bar in the player panel of the Web UI. I found
the error below in the Window's app event log, but I don't know if it is
related to the crash. As expected, there were no messages left in the
server log. The server is running on Windows XP
Event Type: Error
Event Source: Application
Event Category: None
Event ID: 0
Date: 8/5/2009
Time: 8:19:28 AM
User: N/A
Computer: TPA20
Description:
The description for Event ID ( 0 ) in Source ( Application ) cannot be
found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following information
is part of the event: Carp::Clan::__ANON__(): DBI Connection failed: DBI
connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
failed: Can't connect to MySQL server on '127.0.0.1' (10061) at
/C:\PROGRA~1\Squeezebox\server\SqueezeSvr.exeDBIx/Class/Storage/DBI.pm
line 715
.
--
tamanaco
tamanaco's Profile: http://forums.slimdevices.com/member.php?userid=4620
View this thread: http://forums.slimdevices.com/showthread.php?t=66307
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
erland;445936 Wrote:
Can't you just select to view the HTML source in the web browser and see
if it contains your changes or not ?
Yes, I Can - but there are no changes - everything is set to album.
nothing to albums. Besides, all files are from 04-08-2009, yesterday,
when I did the clean re-install.
erland;445936 Wrote:
I'm guessing that you might also see your changes after the ?
character in the url you listed.
No, it's not - but maybe we could try to fix it and find it step by
step?
The arists name in the Web Interface links to
http://127.0.0.1:9000/browsedb.html?hierarchy=contributor,album,tracklevel=1contributor.id=508player=X
(seems right?)
clicking on it produces the SQL-error below:
DBD::mysql::st execute failed: Unknown column 'albums.year' in 'order
clause' [for Statement SELECT album.id, album.titlesort,
album.contributor, album.compilation, album.year, album.artwork,
album.disc, album.discc, album.musicmagic_mixable, album.titlesearch,
album.replay_gain, album.replay_peak, album.musicbrainz_id, album.title
FROM contributors me LEFT JOIN contributor_album contributorAlbums ON
contributorAlbums.contributor = me.id JOIN albums album ON album.id =
contributorAlbums.album WHERE ( ( contributorAlbums.role IN ( ?, ?, ? )
AND me.id = ? ) ) GROUP BY album.id ORDER BY albums.year,concat('0',
contributors.namesort),concat('0', albums.titlesort) LIMIT 6 with
ParamValues: 0=1, 1=5, 2=6, 3=508] at
/C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXESlim/Schema/Storage.pm line
86
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x779ceb4)
But where did this SQL-statement result from`?
You told me, there must be album.year instead of albums.year - but
who wrote this statement? Can't find it in the browsedb.html (sorry,
I'm only speaking HTML and a little PHP, so my question may seem
naive...)
If we could find where and why this statement is produced, we maybe
could fix the error?
btw: Clearing the cache didn't change anything
Thanks
Frank
--
frank1969
frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156
View this thread: http://forums.slimdevices.com/showthread.php?t=66307
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
The reference to album.year IS in Browsedb.html.. -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal... SB3 (wired) - TACT 2.2X (Linear PSU) + Good Vibrations S/W - MF Triplethreat(Audiocom full mods) - Linn 5103 - Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Townsend Supertweeters, Blue Jeans Digital,Kimber Speaker Chord Interconnect cables Outdoors: Boom Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
frank1969;446042 Wrote: And: Why does only the Web interface produce this wrong query while the controller seems to send the right SQL-statement? btw: Clearing the cache didn't change anything I don't have the time to look at it in detail at the moment but I wonder if it might be stored in a cookie ? Could you try to: 1. Change the sorting drop list in the album view. (I'm not sure if this is possible due to the SQL error, but if it is, it might re-write the cookie) 2. Clear all cookies in Internet Explorer (or at least all that belongs to SqueezeCenter) -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
Beneath is a list: The following applications are using port 9000: But the list is empty. Hmm... this needs improvement. But what this means is: some application is listening on port 9000, thus SC can't use it. But we haven't found out what application it was (thus the empty line after the colon). Do you see SC running in task manager? Anything in the server.log? Please open the command line (cmd.exe) and run the following command: netstat -ab Do you see anything listening on port 9000? -- Michael ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
thanks, I'll try tonight and post it here. squeez~3.exe is in the taskmanager and the serverlog ist completely empty (just the sc started line). BUT... this isonly a recognition besides, for it only happens in safe mode, the problem is in normal mode it says it CAN reach/listen to port 9000 and i can get the start page - but nothing more. clicking any link (including just options) leads to loding... endlessly but showing no side. the only thing i changed with this installation, i used the faster options for artwork scan and i disabled the statistics box (counting albums etc., it said it would make scanning faster and it has been 4 times faster...) any connection to be seen with this? many thanks Frank -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
So i just updated to the last nightly and tried the netstat -ab: TCP -:3483 -:0 LISTENING TO 2136 [SQUEEZ~3.EXE] TCP -:9000 -:0 LISTENING TO 2136 [SQUEEZ~3.EXE] TCP -:9090 -:0 LISTENING TO 2136 [SQUEEZ~3.EXE] TCP -:9092 -:0 LISTENING TO 3992 [mysqld.exe] TCP -:1812 localhost:9092 CONNECTED 2136 [SQUEEZ~3.EXE] TCP -:9092 localhost:1812 CONNECTED 3392 [mysqld.exe] TCP -:3483 XXX.XXX.X.8:26184 CONNECTED 2136 [SQUEEZ~3.EXE] (* xx for my network ip) UDP -:3483 *:* 2136 [SQUEEZ~3.EXE] UDP -:1820 *:* 2136 [SQUEEZ~3.EXE] Is this any helpful? -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
UDP -:3483 *:* 2136 [SQUEEZ~3.EXE] UDP -:1820 *:* 2136 [SQUEEZ~3.EXE] Is this any helpful? Yes. This tells us that your SC is running. Michael ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
It looks to me as if your installation has partially failed and you are left with a malformed database. I would do a remove install via Control Panel, restart the PC and then a fresh install of the latest 7.4 nightly. -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal... SB3 (wired) - TACT 2.2X (Linear PSU) + Good Vibrations S/W - MF Triplethreat(Audiocom full mods) - Linn 5103 - Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Townsend Supertweeters, Blue Jeans Digital,Kimber Speaker Chord Interconnect cables Outdoors: Boom Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
That's just what I did. To tell the whole story: - The same error happened within the last SQLite Nightly (so i had to do a re-install), - It happened again with the first Mysql 7.4, - Then i de-installed, even cleaned registry from anything looking like squeeze* or mysql* and did a reinstall... with a new scan (about 5 hours). I just know a little about MySQL, but I run the line in the error file and it seems that the mistake is produced by the '?' part of the sql-statement? Maybe one of the developers could tell me where this error message could result from or what I could check THANKS! Frank -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
frank1969;445815 Wrote:
I just know a little about MySQL, but I run the line in the error file
and it seems that the mistake is produced by the '?' part of the
sql-statement?
No, that's a red herring. Think of '?' as a placeholder, which is what
it is.
The query was (reformatted to be a ton easier to read):
Code:
SELECT album.id, album.titlesort, album.contributor, album.compilation,
album.year, album.artwork, album.disc, album.discc,
album.musicmagic_mixable, album.titlesearch, album.replay_gain,
album.replay_peak, album.musicbrainz_id, album.title
FROM contributors me
LEFT JOIN contributor_album contributorAlbums
ON contributorAlbums.contributor = me.id
JOIN albums album ON album.id = contributorAlbums.album
WHERE ( me.id = ? )
GROUP BY album.id ORDER BY albums.year,
concat('0', contributors.namesort),
concat('0', albums.titlesort)
LIMIT 32
The key is the little bit in the log file after that:
with ParamValues: 0=243
ie, the first ? being replaced with 243.
What it is mad about is much simpler: it says there is no column called
'year' in the albums table.
Which means something somewhere in the db initializing went horribly
wrong: there should be a 'year' column.
--
snarlydwarf
snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179
View this thread: http://forums.slimdevices.com/showthread.php?t=66307
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
snarlydwarf;445817 Wrote: What it is mad about is much simpler: it says there is no column called 'year' in the albums table. Which means something somewhere in the db initializing went horribly wrong: there should be a 'year' column. That's been my first idea too so I checked the db with MySQLAdmin. That's the result - to me it seems ok, could someone check? Thanks!! And the table is filled with data, looking normally... TABLE `slimserver`.`albums` ( `id` int(10) unsigned NOT NULL auto_increment, `title` blob, `titlesort` text, `titlesearch` text, `customsearch` text, `compilation` tinyint(1) default NULL, `year` smallint(5) unsigned default NULL, `artwork` int(10) unsigned default NULL, `disc` tinyint(1) unsigned default NULL, `discc` tinyint(1) unsigned default NULL, `replay_gain` float default NULL, `replay_peak` float default NULL, `musicbrainz_id` varchar(40) default NULL, `musicmagic_mixable` tinyint(1) default NULL, `contributor` int(10) unsigned default NULL, PRIMARY KEY (`id`), KEY `albumsTitleIndex` (`title`(255)), KEY `albumsSortIndex` (`titlesort`(255)), KEY `albumsSearchIndex` (`titlesearch`(255)), KEY `albumsCustomSearchIndex` (`customsearch`(255)), KEY `compilationSortIndex` (`compilation`), KEY `albumsYearIndex` (`year`), KEY `albumsDiscIndex` (`disc`), KEY `albumsDiscCountIndex` (`discc`), KEY `albumsArtworkIndex` (`artwork`) -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
mherger;445611 Wrote: Beneath is a list: The following applications are using port 9000: But the list is empty. Hmm... this needs improvement. But what this means is: some application is listening on port 9000, thus SC can't use it. But we haven't found out what application it was (thus the empty line after the colon). Do you see SC running in task manager? Anything in the server.log? Please open the command line (cmd.exe) and run the following command: netstat -ab Do you see anything listening on port 9000? -- Michael For me, with the older version installed but turned off, nothing listening on 9000 (although quite a few things on TIME_WAIT). With it (the old, working version) turned on, some squeezeboxen ESTABLISHED. Let me know what else I can do. -- opaqueice opaqueice's Profile: http://forums.slimdevices.com/member.php?userid=4234 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
Just filed a bug - I tested with the controler (Squeezebox Duet) and it all works fine - so I don't think the database is damaged... -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
snarlydwarf;445817 Wrote:
What it is mad about is much simpler: it says there is no column called
'year' in the albums table.
Which means something somewhere in the db initializing went horribly
wrong: there should be a 'year' column.
There is a year in albums, but the albums table is aliased as album
(instead of albums) in the query so I believe the order by should be
ORDER BY album.year instead of ORDER BY albums.year.
However, it's still strange because my setup still generates a correct
query that looks like this:
Code:
SELECT album.id, album.titlesort, album.contributor, album.compilation,
album.year, album.artwork, album.disc, album.discc, album.musicmagic_mixable,
album.titlesearch, album.replay_gain, album.replay_peak, album.musicbrainz_id,
album.title FROM contributors me
LEFT JOIN contributor_album contributorAlbums ON
contributorAlbums.contributor = me.id
JOIN albums album ON album.id = contributorAlbums.album
WHERE
( me.id = ? )
GROUP BY album.id
ORDER BY album.year,
concat('0', me.namesort),
concat('0', album.titlesort)
LIMIT 1
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=66307
___
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] latest 7.4 is broken
Same with me, I described the problem in this thread = http://forums.slimdevices.com/showthread.php?t=66292 but without answer till now. What I recognized today: Using the Control Panel it shows No connection to port 9000. Beneath is a list: The following applications are using port 9000: But the list is empty. Can anyone tell me, where I can find out, which program could use this port? -- frank1969 frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=66307 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
