[Netjuke-devel] Problems with Netjuke 1.0RC2 with PostGreSQL
Status: Beta
Brought to you by:
blakewatters
|
From: <JB...@gm...> - 2004-09-19 18:47:05
|
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 |