hey guys i just installed a clean copy of dolphin 7.1.3 , an try ta import my profile sql backup, an got this error is there away ta fix this

Error

SQL query:

-- -- Dumping data for table `Profiles` -- INSERT INTO `Profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`, `SuperAntiSpam`, `SpamBlock`, `Interestedin`) VALUES (1, 'HowlPendragon', 'admin@deepanimallovers.com', '6937d8202ada3a459f7e9d33eae83bb731f1cfd5', 'ZGQwNzk2', 'Active', 3, 0, 'male', '', 'The One And Only', '<p>I am as epic as she wants me to be :)</p>\r\[...]

MySQL said: 

#1054 - Unknown column 'SuperAntiSpam' in 'field list' 

Thanks Doug

Your getting errors because your trying to import a SQL from a backup that contains fields in the table that your new install does not have.

The fields i see that are not part of a default dolphin install are the following.

SuperAntiSpam
SpamBlock
Interestedin

The solution would be to either manually create those missing profile fields by hand if you have the information needed to match the datatype and field size, or to install any modules that may have created those fields.

so the information would be in the backup rite ? ta manually create those missing profile fields 

or can i just go in the sql an take those items out of it , would that help or make it worse lol

Correct. The part of the sql that contains the command to create the table has the information of the fields datatype and size.

You can try and remove the information from the sql as well, but you may find that not to be very easy to do.

k, i'l see what i can do, thx deano fer yer input :-)

well took out those items now i get this error

#1136 - Column count doesn't match value count at row 1 

That error means the count of the columns specified does not match the data.

Meaning the number of columns specified in the insert portion.

INSERT INTO `Profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`, `SuperAntiSpam`, `SpamBlock`, `Interestedin`)

Does not match the number of values in the VALUE portion.

VALUES (1, 'HowlPendragon', 'admin@deepanimallovers.com', '6937d8202ada3a459f7e9d33eae83bb731f1cfd5', 'ZGQwNzk2', 'Active', 3, 0, 'male', '', 'The One And Only', '<p>I am as epic as she wants me to be :)</p>\r\[...]

You apparently only edited one section.

As i said, you will find removing the data from the sql will not be easy. Because not only does the insert need to be updated, but every value line has to be updated as well to match. 

omg i think i will have everyone redo there joining lol

That's why i suggested adding the profile fields to dolphin instead. It's the easier way. Those fields can then be removed from dolphin after the import is done.

would  you kno whre i might be able ta find those fields in dolphin ?

 Fields can be added and removed using the Profile Field Builder (under builders)

Here you find the fields for the different forms (join form/edit profile/view profile/search profiles)