Saturday, January 27, 2007

New Image Available

I just uploaded the newest code with all the bug fixes to date. The latest one includes a modification to the GUI that allows commas to be used in group names. Before it was delimiting data items with commas, which would cause a problem. Note that special characters such as & and | should be avoided in unit names. So you may want to call it the @#%#^ Committee, but igor won't be able to parse that yet. The character translations between SQL and CGI are bothersome, and I'll nail it all down eventually. You may find other characters, like accent marks that don't work properly in some of the dialogs.

The GUI has been modified to fix the 'Add Subordinate Unit' drop-down. Now the drop-down box actually works like it should. Before, a long list would scroll off the screen so you couldn't use it.

Finally, the default graphics are correct in this package. I had put some custom ones in the last package by mistake.

Note that if you are upgrading, you want to preserve your I do occasionally make changes to that file, but those will be easy to detect by inspection. No changes this time.

Thursday, January 25, 2007

End of File Issues

If you install IGOR and get 'premature end of script headers' or something similar when you try to log in, make sure that the perl files (*.pl) are executable. Then run


to see if that works. If you get errors here, either the perl interpreter isn't at /usr/bin/perl, or you may have DOS end of line characters instead of unix ones on the files. This is easy to do when you use FTP. You can use

dos2unix *.pl
chmod a+x *.pl

to switch them over. That should fix it.

Tuesday, January 16, 2007

IE Database Bug Fix

The Actions and Improvements box on the IE interface has a bug in the database. The character limit is set to 45 instead of to TEXT. Here's the SQL to fix it.

ALTER TABLE `IGOR`.`IE_Objectives` MODIFY COLUMN `Improvements` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';