war stories of migration

1. PB added a module to SGH.mdb named "ImportCSV"... it had a line "Am*.csv" - unfortunately this was somehow matching with not only AmerStream.csv, but also AsiaStream.csv and AfriStream.csv! This was causing AmeriStream schedule to have 114 items instead of 38, for example. Changing it to Amer*.csv solved the issue!

2. maillist and shoutstats have issues with PHP5. shoutstats updated to new version 0.8.4, solved issue of not displaying multiple servers. automailer.php is currently not taking the args supplied as a GET request. Current workaround is to supply the date by hard-coding in the php file by find-replace!

3. afristream dies when ameristream or asiastream changes playlist. Don't know why, current workaround is to run auto_africa.sh just after the changeover.

4. saiwaves audio directory has only 2 GB left. So, currently krishna's audio directory (which has 24 kbps files) is mounted with smbmount on saiwaves

5. radiosai.asp has some code-changes to reflect the three change-over times instead of a hard-coded single change-over time. The date calculation for the page displayed when visited for the first time has to be fine-tuned - if cookie exists, must take appropriate changeover time instead of the hard-coded one to calculate date.

6. running main_ftp.sh etc on saiwaves - not working initially, since SEQUENCES were not existing. PB manually created them with psql:

CREATE SEQUENCE file_id_fileid_seq  START 16279;

and so on.