Forum OpenACS Q&A: Response to Polls error

2: Response to Polls error (response to 1)
Posted by Michael A. Cleverly on
The above date will bomb because one of the checks ns_buildsqldate does is to make sure that day is not less than 1 or greater than 31.  The 08 is interpreted by Tcl as being an octal value instead of an integer value.  (The function is defined in the Tcl privart library directory in the file ad-aolserver-3.tcl.preload beginning at line 545.)

It seems this function would be a tad bit more robust if it stripped and leading zeros off of the day... I've just checked in a new version of ad-aolserver-3.tcl.preload that does this.  This problem would only occur for the 8th & 9th of the month.  So good thing you didn't wait until Wednesday to add a poll! 😊

(If you are running AOLserver 2.3, and not 3.0, then my changed ns_buildsqldate code won't do you any good, and you'll need to poke around in modules/tcl under the AOLserver home and find where it is declared.)