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
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
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' "
What does that mean?
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.
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