I'm not sure why you've had so many issues with the installer not running the queries. What version of PHP are you running?
This error can be fixed by running the following query:
Code:
ALTER TABLE `xf_user_option` ADD `uix_collapse_signature` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' AFTER `uix_collapse_user_info`;
This is not recommended
What type of stack are you using for PHP and your web server?
The permissions you need to set depend on your server configuration. If you're using SuPHP you shouldn't have to change any permissions. If you are not using SuPHP (or not having your webserver run as the user that owns the files) it is highly recommended that you use the FTP option, or manually update.
I believe this only works on Chrome for Android, but I may be wrong.
@kylerc would probably know more than I do though.
I'm still not able to replicate this on any of our boards. Would you mind sending me a PM with admin details and a link to your board so I can see what is going on?