Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
April 05, 2016, 10:16:12 am
Thought I could wriggle out of this easily by deleting the column and the reference to it but the values don't add up on import. As I do not know sql in details I can't get past this, unless I do not import members. Unsuccessful! This query: SELECT id_member, member_name, date_registered, posts, id_group, lngfile, last_login, real_name, unread_messages, unread_messages, new_pm, buddy_list, pm_ignore_list, pm_prefs, mod_prefs, message_labels, passwd, email_address, personal_text, gender, birthdate, website_url, website_title, location, hide_email, show_online, time_format, signature, time_offset, avatar, pm_email_notify, usertitle, notify_announcements, notify_regularity, notify_send_body, notify_types, member_ip, member_ip2, secret_question, secret_answer, 1 AS id_theme, is_activated, validation_code, id_msg_last_visit, additional_groups, smiley_set, id_post_group, total_time_logged_in, password_salt, ignore_boards, IFNULL(warning, 0) AS warning, passwd_flood, pm_receive_from AS receive_from FROM padding_smf .elk_members LIMIT 0, 500; Caused the error: Unknown column 'pm_receive_from' in 'field list'
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #1 – April 05, 2016, 10:20:43 am
Could you also post the original query that you modified?
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #3 – April 05, 2016, 10:54:06 am
Are you saying that your SMF 2.0.11 install does not have a pm_receive_from column in the members table ?
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #4 – April 05, 2016, 10:56:11 am
The opposite I think. Caused the error: Unknown column 'pm_receive_from' in 'field list' The import failed with that message.
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #5 – April 05, 2016, 10:58:21 am
I tried removing it to see if the importer would continue but ran into problems. I do not know the sql query to delete it properly and remove the value from each users data.
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #6 – April 05, 2016, 11:02:14 am
I'm going to run a quick test on a 2.0.11 to see if I get the error. Looking quickly that error should mean the importer can't find the pm_receive_from column in your SMF members table. Since importing members is mandatory, it stops at that point.
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #7 – April 05, 2016, 11:06:42 am
I have a sneaky feeling that a 'pm' column was dropped or emptied (after some trouble). Maybe the column with the pm texts. I'm not sure as it happened quite a long time ago and cannot get hold of the person now. Maybe you can see straight away if one is missing, for me I would need to set up a new install and compare.
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #8 – April 05, 2016, 11:15:01 am
If its missing, you should be able to add it back with phpmyadmin or adminer. Just add a new tinyint column named pm_receive_from with a default value of 1 to your smf_members table. That should be easier than trying to adjust the importer code
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #9 – April 05, 2016, 11:17:09 am
I think that is what it is - will give it ago tomorrow as its late here. Thanks, Andy
Re: Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
Reply #14 – April 05, 2016, 11:51:49 pm
It is only a test site so not important. After deleting the line in xml 2.0 importer file I got another error about 'like' posts. So I went back to the advanced options and unchecked several things that I thought were not essential ('like' posts, anything about PMs etc), and it worked. Its all working now....