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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
