Thread: search and browse error

when a loged in meber does a search or browses a users profiles, they get database access error, i am using doplin 5.8, these are the error i get by email,

Error in /search_result.php: Unknown column 'Height' in 'field list'
Query: 'SELECT Sex, Relationship, Height, BodyType, DateOfBirth FROM Profiles WHERE ID = 5'

Error in /profile.php: Unknown column 'Height' in 'field list'
Query: 'SELECT Sex, Relationship, Height, BodyType, DateOfBirth FROM Profiles WHERE ID = 5'

i also get this error when rating a photo
_______________________________________
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, cg1@cg1network.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Originally Posted by cg1

when a loged in meber does a search or browses a users profiles, they get database access error, i am using doplin 5.8, these are the error i get by email,

Error in /search_result.php: Unknown column 'Height' in 'field list'
Query: 'SELECT Sex, Relationship, Height, BodyType, DateOfBirth FROM Profiles WHERE ID = 5'

Error in /profile.php: Unknown column 'Height' in 'field list'
Query: 'SELECT Sex, Relationship, Height, BodyType, DateOfBirth FROM Profiles WHERE ID = 5'

That means in Words youve wrecked the SQL Structure by deleting a Profile Field.

Easiest Way to fix that: Simply reinstall the Database.

Also an Advice: Do not delete any Profile-Fields, just HIDE em by editing the "Show on Page" in the Profiles Desc via PHP My Admin ..that way you can at least make sure that u dont mess up your Database by any deleting Attempts.

is it possiable to just reinstall that table as i have made changes to the site, e.g installed forum

i deleted the table and reinstled it using the sql command on boonex's website http://www.boonex.net/websvn/filedet...Fsql%2Fv56.sql

i'm still geting the error