This question may be related to a resolved thread.
I noted in the thread above it stated that a fix has been committed. I’ve just had this same error in v2.2.1 - Build: date 20110630
This is on a site that’s been on EE2 MSM for a good while now.
Running the query below worked
ALTER TABLE exp_upload_no_access ADD COLUMN upload_loc varchar(3) NOT NULL AFTER upload_idThought I’d better pipe up as it’s obviously not gone away.