I get this error on join /BxDolProfilesController.

I get this error on join:

Database query error

Query:

INSERT IGNORE INTO `Profiles` SET `NickName` = 'Sexyass', `Password` = '12loveyoumore', `Email` = 'myemail@sample.com', `DateReg` = '2013-01-27 22:49:02', `DateLastEdit` = '0000-00-00', `Status` = 'Unconfirmed', `DateLastLogin` = '0000-00-00', `Featured` = 0, `Sex` = 'female', `LookingFor` = 'male,female', `DescriptionMe` = '

I like to share but not being just used

', `DateOfBirth` = '1978-04-12', `Headline` = 'Sexy me', `Country` = 'US', `City` = 'San Francisco', `Couple` = 0, `Tags` = 'sexy, ass, beauty', `zip` = '94103', `EmailNotify` = 1, `Height` = '', `Weight` = '', `Income` = '', `Occupation` = '', `Religion` = '', `Education` = '', `RelationshipStatus` = 'In a Relationship', `Hobbies` = '', `Interests` = '', `Ethnicity` = '4', `FavoriteSites` = '', `FavoriteMusic` = '', `FavoriteFilms` = '', `FavoriteBooks` = '', `FirstName` = 'Susanne', `LastName` = 'Sincere', `Sexual_Oriantation` = 'Bisexual', `SexualOriantation` = 'Bisexual', `InterestedIn` = 'Dating,Friends,Discreet Relationship', `LifeStyle` = 'Fetishism,Nudism', `LangID` = 1

Mysql error:

Unknown column 'FavoriteSites' in 'field list'

Found error in the file '/home/xxxxxx/public_html/erotic-unity.net/inc/classes/BxDolProfilesController.php' at line 124.

Called 'db_res' function with erroneous argument #0.

Debug backtrace:

Array

(

    [1] => Array

        (

            [file] => /home/xxxxxx/public_html/erotic-unity.net/inc/classes/BxDolDb.php

            [line] => 237

            [function] => error

            [class] => BxDolDb

            [type] => ->

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => Unknown column 'FavoriteSites' in 'field list'

                    [host] => localhost

                    [port] => 

                    [socket] => 

                    [dbname] => xxxxxx_sex

                    [user] => *****

                    [password] => *****

                    [link] => Resource id #27

                    [current_res] => 

                    [current_arr_type] => 1

                    [oParams] => BxDolParams Object

                        (

                            [_oDb] => BxDolDb Object

 
There is your error.

And it means the field FavoriteSites could not be found in the profiles table.

This is a standard dolphin profile field and for some reason it is missing.

 Hi Deano, the thing is I can see the field at sys-profile_fields

 but not at Profiles tables :-)

can I just add this no matter what the ID is?

Perhaps it is in that table, but that is not the table i was referring to. It also must exist in the Profiles table as well. Thats whats causing the error.

I can give you the query to insert it, but you need to actually verify it is not in the Profiles table.

Thanks Deano I fixed it :-)

You need to make sure it's the right type.

This is the query to insert it at the position it would normally be in when dolphin is installed.

ALTER TABLE `Profiles` ADD `FavoriteSites` text NOT NULL AFTER `Ethnicity`