Members profiles gone blank

[TravisWPaquin]

Every time I view a members profile it goes blank or we get a 500 server error. It happened while I was uploading a plugin, but I removed the plugin completely. I reinstalled all vb files to recover missed/lost files, I checked the fix user broken profiles, but those were fine and then I disabled all hooks, but they weren't the cause either.

It would be great to know what the cause of this can be. I've been stuck for hours and I just can't seem to find what's causing this issue.

[snakes1100]

Provide a link to the site & a working test account to use.

Did you test with a default style?

Did you disable your plugin system via config.php & test?

The easiest way to find & fix the issue is at the server level.
log files
php debug settings etc

[Lynne]

Here is a page from the manual about troubleshooting blank or 'white' pages: https://www.vbulletin.com/docs/html/blank_pages

[TravisWPaquin]

I fixed the profiles by a back up, but this issue still occurs when I try to save my "edit your details."

Database error in vBulletin 3.8.7:

Invalid SQL:
UPDATE userfield SET
field2 = 'Claifornia, USA, North America',
field1 = '',
field3 = '',
field4 = ''
WHERE userid = 1;

MySQL Error : Unknown column 'field4' in 'field list'
Error Number : 1054
Request Date : Wednesday, November 7th 2012 @ 07:09:13 PM
Error Date : Wednesday, November 7th 2012 @ 07:09:13 PM
Script : http://thepkmndistrict.com/profile.php?do=updateprofile
Referrer : http://thepkmndistrict.com/profile.php?do=editprofile
IP Address : 108.85.149.32
Username : Distortion
Classname : vB_Database
MySQL Version : 5.1.66-community-log

[Lynne]

And do you have a column "field4" in your userfield table? You should, unless you deleted it manually, since it is a default field in the User Profile Field Manager (Occupation field).