Thanks for confirming that this column can be NULL.
The fix is to make the column not mandatory in the initial sql create script:
setup/osticket.sql
find:
`api_whitelist` tinytext NOT NULL,
replace:
`api_whitelist` tinytext NULL,
Seriously the install script executes setup/osticket.sql and inserts the first config row by only updating the timestamp column bascially triggering all the defaults, but this column 'api_whitelist' is missing the default so it is a MySQL error.
Clean install on Windows machine not upgrade.
php5.2.5
MySQL 5.0.45
This is definitely a bug, can we more this to bugs.. forums or do we make a another post?