Results 1 to 5 of 5

Thread: search and browse error

  1. #1
    cg1
    cg1 is offline

    Join Date
    Apr 2007
    Posts
    24

    Default 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'

  2. #2
    cg1
    cg1 is offline

    Join Date
    Apr 2007
    Posts
    24

    Default

    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.

  3. #3

    Join Date
    Mar 2007
    Posts
    154

    Default

    Quote Originally Posted by cg1 View Post
    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.

  4. #4
    cg1
    cg1 is offline

    Join Date
    Apr 2007
    Posts
    24

    Default

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

  5. #5
    cg1
    cg1 is offline

    Join Date
    Apr 2007
    Posts
    24

    Default

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. quick search and browse profile
    By angel2008 in forum Dolphin General Discussion v6.00 and above
    Replies: 1
    Last Post: 03-26-2008, 05:30 AM
  2. Replace "Quick Search" with "Browse Profiles" ????
    By Spexmex in forum Dolphin General Discussion v6.00 and above
    Replies: 0
    Last Post: 02-02-2008, 01:18 PM
  3. Dolphin 6.02 BROWSE and SEARCH pages
    By bald55 in forum General Troubleshooting
    Replies: 1
    Last Post: 10-17-2007, 11:38 AM
  4. Link from search.php to browse.php and vice versa
    By Roland1975 in forum FAQ & HOWTO
    Replies: 2
    Last Post: 11-17-2006, 12:56 PM
  5. states in countries for register, search & browse
    By Charlie in forum FAQ & HOWTO
    Replies: 1
    Last Post: 11-03-2006, 10:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •