• Welcome to Simple Machines Community Forum. Please login or sign up.
December 03, 2021, 06:18:05 AM

News:

Wondering if this will always be free?  See why free is better.


Members and posts transfer from 1.1.9 to new 2rc1.1 help

Started by evilfud, June 04, 2009, 06:06:58 PM

Previous topic - Next topic

evilfud

Ok so here is what im trying to figure out. I have a forum that is NOW version 1.1.9 after a great mess trying to upgrade it. I created a new forum on a different domain and i need all the members and posts transfered over to the new forum. On the posts it dont matter where i can move them to where i want after they are there.


I have tried doing a export of members in phpmyadmin and import in new db and get errors like this

"Error

SQL query:

-- -- Dumping data for table `smf_members` -- INSERT INTO `smf_members` (`ID_MEMBER`, `memberName`, `dateRegistered`, `posts`, `ID_GROUP`, `lngfile`, `lastLogin`, `realName`, `instantMessages`, `unreadMessages`, `buddy_list`, `pm_ignore_list`, `messageLabels`, `passwd`, `emailAddress`, `personalText`, `gender`, `birthdate`, `websiteTitle`, `websiteUrl`, `location`, `ICQ`, `AIM`, `YIM`, `MSN`, `hideEmail`, `showOnline`, `timeFormat`, `signature`, `timeOffset`, `avatar`, `pm_email_notify`, `karmaBad`, `karmaGood`, `usertitle`, `notifyAnnouncements`, `notifyOnce`, `notifySendBody`, `notifyTypes`, `memberIP`, `memberIP2`, `secretQuestion`, `secretAnswer`, `ID_THEME`, `is_activated`, `validation_code`, `ID_MSG_LAST_VISIT`, `additionalGroups`, `smileySet`, `ID_POST_GROUP`, `totalTimeLoggedIn`, `passwordSalt`, `longitude`, `latitude`, `referrals_no`, `referrals_hits`, `referred_by`, `referred_on`, `mgal_total_items`, `mgal_total_comments`) VALUES (1, 'evilfud', 1218908367, 182, 1, 'english[...]

MySQL said: Documentation
#1054 - Unknown column 'memberName' in 'field list' "

If someone could help me out it would be greatly appreciated.

Thanks,
Fud

evilfud

Ok i have searched and im not seeing what your talking about unless you mean i just need to ftp the 2rc1.1 upgrade files to my server and go through the upgrade process again. Is that what you mean?

Thanks for the help also.

Fud

evilfud

Ok now i have updated and when i try to import the sql into the database i still get an error here it is.

"Error

SQL query:

-- -- Dumping data for table `smf_boards` -- INSERT INTO `smf_boards` (`id_board`, `id_cat`, `child_level`, `id_parent`, `board_order`, `id_last_msg`, `id_msg_updated`, `member_groups`, `id_profile`, `name`, `description`, `num_topics`, `num_posts`, `count_posts`, `id_theme`, `override_theme`, `redirect`, `unapproved_posts`, `unapproved_topics`) VALUES (16, 1, 0, 0, 1, 1176, 1176, '-1,0,2,4,5,6,7,8,9,10', 1, 'Introductions', 'Introduce yourself!', 48, 252, 0, 0, 0, '', 0, 0), (1, 1, 0, 0, 2, 1236, 1236, '-1,0,2,9,10,4,5,6,7,8', 1, 'News & Site Information', 'News and Announcements will be located here.', 10, 29, 0, 0, 0, '', 0, 0), (41, 1, 0, 0, 3, 841, 841, '-1,0,2,9,10,4,5,6,7,8', 1, 'Comments/Suggestions', 'Please post any comments or suggestions you have to make the site better.', 3, 10, 0, 0, 0, '', 0, 0), (58, 1, 0, 0, 4, 570, 570, '-1,0,2,9,10,4,5,6,7,8', 1, 'Advertiser Information', '', 1, 1, 0, 0, 0, '', 0, 0), (35, 2, 0, 0, 5, 1160, 1160, '-1,0,2,9,10,4,5,6,7,8', 1, 'P[...]

MySQL said: Documentation
#1062 - Duplicate entry '16' for key 'PRIMARY' "


Antechinus

Question: the backup you are tyring to import. Is it a complete backup (including table structure) or is it just a data backup?
If it is the latter then yes, you will get duplicate entries.

evilfud

Ok to fix everything i did a complete backup with tables and all dropped all the tables then restored the file. Then i had the path to template error but added the index.php?theme=1 to the end of my url and was able to fix it by doing the fix located in theme page to restore paths.

Thanks for all the help. Now my only problem is it seems to have saved info from mods i already installed and im getting errors about like it cannot reapply so and so. I just uninstalled those mods and wont use em i guess.

Fud

Advertisement: