Database question

I re-installed my site with the 7.0.7 script. I want to import the members from my previous website which was based on 7.0.6

It seems that some fields have changed in the profiles table. How can I import this one into my new database without getting errors such as duplicate entry ?

Any help would be much appreciated.

Import your whole database from the 7.0.6 site then run the upgrade script that comes with the 7.0.7 patch.

Here's the patch:

 http://get.boonex.com/Dolphin-Patch-v.7.0.7

The only thing you would really need to upload is the /upgrade directory. Delete the .htaccess from the /upgrade dir then run www.yoursite.com/upgrade/

If you installed 7.0.7 from scratch then your files are all new so after you do these steps the database will be 7.0.7 also.

That's not really what I want to do because there were errors in the 7.0.6 database. I just want to import the profiles,messages, pictures and avatars. All goes well except the profiles.

You could setup a temporary install somewhere with the old database and run the update script.. then export JUST the profiles table and import it into the new install. This would fix the profiles problem but did you have any pictures, avatars, music, movies, blogs or anything like that on the old site? 

That's a good idea ! I still have the old script on my server. I'll give it a try and will let you know.

I only had pictures and avatars. I already imported them and that was no problem.

It works but I still have this 'unknown control type' field in the members profile. Besides that, I now have the membership block, so it looks ok so far.

That's a tough one, that must be from another table that was tied into profiles table somehow. Did you have any custom membership levels on the old site? Also do you have all the same modules installed on the new site you had on the old one?

Look at all the fields in the profiles table and see if anything rings a bell as being something you changed or installed on the old site, then you might have to import those tables too. Or just make the same changes on the new site.

Yes, I installed UE30's events state mod and that's when all the trouble started. This mod ads tables and profile fields. So when I re-installed my site and used the profiles table from the database, there were still extra fields from that mod in it.

I already told UE30 that he should make his mod not part of Boonex mods but a separate mod instead. He doesn't answer nor care about the problem.