There is no error with the query your trying to debug.
Based on your error your problem is with trying to get your profile data which is done through a query in the vb3.php file.
We code our application to how vbulletin releases there software. I would think you would want to add the location field back in so that the query can run successfully. If you have modified the user field to be a different field in the
vb database you would have to alter our coding in that file to look for your new field but this should resolve your error as this will add the field back in.
Make sure to add in whatever
vb table prefix your using in your database if any.
http://www.photopost.com/forum/1179129-post5.html