Code:
Unable to execute query: SELECT count(*) as total from `process_queue` as p, `signup` as s where p.user=s.username ORDER BY `status`asc
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
This is due to wrong collations set as default on the server. You can edit the table "process_queue" in phpMyadmin and set collations to none to fix it.

As for upload.php, your files seems corrupted, you need to download the file again and upload to your web site in BINARY mode.

Since upgrade is done by hostonnet, you can contact them to get the problem fixed.