Well lets see if I can break this down.
1. our application is coded to pull certain default vbulletin fields one of those is location for profile info thats the field your missing.
2. You as the superadmin can make sure your
vb config file under canrunqueries can make sure your admin userid normally 1 is in the config for that option
3. You should be able to login to your
vb admin panel and under maintenance option see the run sql queries option
4. when you hit that option try entering the query I noted and see if your error dissappears.