[Netjuke-devel] Problems with Netjuke 1.0RC2 with PostGreSQL

[<JB...@gm...>]

Hi everyone


I'm not very familiar with Netjuke source, so I'm not gonna submit any
patches. However i'll post my solutions to two related problems with
Netjuke and using PostgreSQL as a backend.


1)  <databasebackend>->Execute(..)
That one returns either an object or FALSE, atleast at one place, ~121=20
while(isset($dbrs) &&...) always returns true, even if the SQLquery failed.
I wouldn't be suprised if this happens on more then this place, havn't look=
ed..

2) PGSQL does not support 'order by' on something that you don't
return. this means that SQL queries like this fail
SELECT distinct tr.location, tr.time, tr.name, ar.name, al.name, tr.id
from netjuke_tracks tr, netjuke_artists ar, netjuke_albums al ,
netjuke_genres ge where ar.id =3D tr.ar_id and al.id =3D tr.al_id order by
al.name, tr.track_number, ar.name, tr.id;

as we don't return the tr.track_number.=20
I would suspect this happens at rather many places, first I found was
play.php:~266
(the example I posted)

Hope this will be fixed asap.

Cheers guys
/Johan Bj=F6rk