SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: msql query

  1. #1
    SitePoint Member
    Join Date
    Jul 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    msql query

    Hello everyone,

    I'm setting up my site called internetcruisingclub dot com from a basic Dolphin social network template.
    Because it was basically a dating site, on the "join" page it had a field "Looking for"' which I didn't want, so changed it to "Name of boat"
    I thought I knew more about phpmyadmin than I actually did, so now I've mucked up the "join" page, and I get the message:

    Database query error
    Query:
    INSERT INTO `Profiles` SET `NickName` = 'peteract', `Password` = 'sunshine', `Email` = 'peteract@gmail.com', `DateReg` = '2009-07-21 05:05:54', `DateLastEdit` = '0000-00-00', `Status` = 'Active', `DateLastLogin` = '0000-00-00', `Featured` = 0, `Sex` = 'male', `LookingFor` = '', `DescriptionMe` = 'I want to load articles', `DateOfBirth` = '', `Headline` = '', `Country` = 'AU', `City` = 'Macgregor', `Couple` = 0, `Tags` = '', `zip` = '2615', `Name_of_boat` = 'Lettuce Spray'
    Mysql error:
    Unknown column 'LookingFor' in 'field list'

    I also get:

    Found error in file /home/cruising/public_html/inc/classes/BxDolProfilesController.php
    at line 111. Called db_res function with erroneous argument #0

    Where can I find "field list" in phpmyadmin, so I can fix the problem?
    (and learn a bit more sql stuff)

    Many thanks in advance,

    Peter

  2. #2
    rajug.replace('Raju Gautam'); bronze trophy Raju Gautam's Avatar
    Join Date
    Oct 2006
    Location
    Kathmandu, Nepal
    Posts
    4,013
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Click in the Profile table in the left hand side of phpmyadmin then you will see the fields in the right hand side. And it says that the field 'LookingFor' does not exist in the table.
    Mistakes are proof that you are trying.....
    ------------------------------------------------------------------------
    PSD to HTML - SlicingArt.com | Personal Blog | ZCE - PHP 5

  3. #3
    SitePoint Member
    Join Date
    Jul 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Rajug,

    I put the field back in, and the "join" page on the site worked perfectly.
    I just had to put "Disregard this field" on the joining form - go to the site and see what I mean.

    Not a very elegant solution, as I just wanted to get rid of the field altogether, but at least it works.

    Will try and learn how to insert and delete fields in a table

    Cheers,

    Peter

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,018
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by peter_act View Post
    I just had to put "Disregard this field" on the joining form
    LOL @ "Name of your boat (if any)"
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Member
    Join Date
    Jul 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, this site will be for dreamers too, if I ever learn how to set things up.
    I don't mind paying someone to do it, but then I will never learn to do it myself

    Cheers from Australia,

    Peter


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
  •