Yeah, I tried that earlier (api_whitelist tinytext NOT NULL,), then I got another error:
You have an error in your SQL syntax INSERT INTO ost_config SET isonline=1, updated=NOW()
So, now I changed that to:
INSERT INTO %TABLE_PREFIX%config SET isonline=1, updated=NOW(), api_whitelist='';
And boom, that seemed to work and got the sweet confirmation: "Congratulations osTicket basic installation completed!"
So,
1. Is the hack above recommended?
2. Do I need to hack any other file as far as 'api_whitelist' field is concerned?
3. Did I get this error because of the MySQL version, or that I am using Windows - not all behavior can be expected to run as they should?
I have fiddled with osTicket a bit, and think it's a fantastic application with great attention to detail and quality. Thanks for this excellent application!