SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: msql query
-
Jul 21, 2009, 03:20 #1
- 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
-
Jul 21, 2009, 03:38 #2
- 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
-
Jul 22, 2009, 05:42 #3
- 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
-
Jul 22, 2009, 06:24 #4
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
-
Jul 23, 2009, 02:03 #5
- 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