[Rawt-devel] Postgresql 8.3.6 problem

[Andreas W. <we...@an...>]

Hi!
I just wanted to install RAWT for usage in the upcoming VHF/UHF contest weekend.
I tried the latest debian stable release "lenny" and set up my apache server this way: Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny2 with Suhosin-Patch mod_python/3.3.1 Python/2.5.2 mod_perl/2.0.4 Perl/v5.10.0 and APC (php cache). But there seems to be an incompatibility with Postgresql 8.3.6:
when selecting "statistics" I get this error:
Warning: pg_query() [function.pg-query]: Query failed: FEHLER: Funktion pg_catalog.substring(timestamp with time zone, integer, integer) existiert nicht LINE 1: ...ints_h from t_act_contest_60_1236000075_117 where substring ... ^ HINT: Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. in /var/www/functions/psqlif.php on line 64
In module dbif, function query_arr: An error occured:
  	UTC 	Pts 	% 	Pts/h 	%/h 	QSOs 	% 	QSOs/h 	%/h 	Pts/QSO 	Pts/QSO (h)

I don't think this is an error with the debian Postgresql package. It more seems like the 8.3.x version handles the pg_catalog.substring function more strict. You probably have to use to_char function first.

Another thing is ADIF? RAWT links to /contest/adif_auswertung.php but this file doesn't exist: neither in CVS nor in the download tar package.

Thank you!


Regards,
  Andreas Weller, DF1PAW