Looks like you have a column "name" in jos_comprofiler, which shouldn't be there. That column is in jos_users. Therefore MySQL doesn't know which to use and errors.
You can safely remove the "name" column from jos_comprofiler (maybe check that there is no other columns of jos_users table duplicated there !
Probably due to another extension ? which?