Probably the issue is as per recent post Error 404: Failed to prepare transaction - #9 by cscs
ie that you still have the community repo in pacman.conf.
No amount of refreshing will make that go away.
I found removing this ALSO caused a whole raft of apparently missing dependencies of the type reported in Dependencies cannot be satisfied on update - #4 by Nachlese to disappear.