Import from SMF 2.011 failed (Unknown column 'pm_receive_from' in 'field list')
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 –
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 –
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 –
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 –
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 –
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 –
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 –
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 –
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 –
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....