Can't attach files on PPC2003 (bug #636)

Ability to create tickets from within KayakoMobile.

Primary key for notes table changed to ticket id + note id

Note content field not SQL-prepared (single quotes not escaped)
Numeric fields for notes and billing entries now default to '' instead of empty.

Table creation statements now wrapped in a transaction and committed
Infinite loop when SQL statement failed to execute
Handwriting attachments get the wrong file name on PPC2003
Now writes SQL errors to file

Better error reporting when trying to save handwriting attachments.

Database creation routine will report any errors that occur during SQL table generation
Miscellaneous scrolling bugs fixed in dialog list control
Critsec list not unlocked if dialog creation fails in dialog list control
Choosing [x] button on either nag screen or register dialog under PPC2003 results in main window not being brought to front
KCELicensing fails to generate a device id on some devices
Dialog List Control items don't resize when screen layout is changed.
2 messages are displayed to the user if user/pass/url are not present when synchronization is attempted
Attachment maximum file size entry field not restricted to numerics
Two messages are displayed to the user when GetURL fails with a known failure message
Size of attached file can be clipped (removed "Size:" prefix)
"Add note" item gets expanded after "Properties" and thus gets brought into view
On PPC2003, reply menu bar isn't properly destroyed
Due date saved through properties is off by time zone offset
Due date viewable in ticket view is off by time zone offset
Focus isn't given to "URL" field in General tab in settings dialog

Optional unload from device memory on exit through Settings->Misc
Null character after POST data causes some servers to throw authentication failed error
Unicode user names don't work for login

Install CAB file did not work on PPC2003 (compression is not supported by that version of the OS). CAB files are now uncompressed.
View->Filter menus were not functional

Ability to create tickets from within KayakoMobile.

Primary key for notes table changed to ticket id + note id

Note content field not SQL-prepared (single quotes not escaped)
Numeric fields for notes and billing entries now default to '' instead of empty.

Table creation statements now wrapped in a transaction and committed
Infinite loop when SQL statement failed to execute
Handwriting attachments get the wrong file name on PPC2003
Now writes SQL errors to file

Better error reporting when trying to save handwriting attachments.

Database creation routine will report any errors that occur during SQL table generation
Miscellaneous scrolling bugs fixed in dialog list control
Critsec list not unlocked if dialog creation fails in dialog list control
Choosing [x] button on either nag screen or register dialog under PPC2003 results in main window not being brought to front
KCELicensing fails to generate a device id on some devices
Dialog List Control items don't resize when screen layout is changed.
2 messages are displayed to the user if user/pass/url are not present when synchronization is attempted
Attachment maximum file size entry field not restricted to numerics
Two messages are displayed to the user when GetURL fails with a known failure message
Size of attached file can be clipped (removed "Size:" prefix)
"Add note" item gets expanded after "Properties" and thus gets brought into view
On PPC2003, reply menu bar isn't properly destroyed
Due date saved through properties is off by time zone offset
Due date viewable in ticket view is off by time zone offset
Focus isn't given to "URL" field in General tab in settings dialog

Optional unload from device memory on exit through Settings->Misc
Null character after POST data causes some servers to throw authentication failed error
Unicode user names don't work for login

View->Filter menus were not functional