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
INSERT INTO `Profiles` SET `NickName` = 'peteract', `Password` = 'sunshine', `Email` = 'firstname.lastname@example.org', `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'
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,