SMF 2 to Wedge importer errors

txcas

  • Bug Zapper
  • Posts: 202
SMF 2 to Wedge importer errors
« on February 26th, 2014, 06:43 PM »
I just tried to import my forum using the latest importer and got hundreds of these errors:
Code: [Select]
Importing settings... ✔
Importing members...
Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/creedmoo/public_html/upgrade/import.php(743) : eval()'d code on line 8

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/creedmoo/public_html/upgrade/import.php(743) : eval()'d code on line 8
Code: [Select]
INSERT INTO `creedmoo_wedge`.wedge_members
 (id_member, member_name, date_registered, posts, id_group, lngfile, last_login, real_name, instant_messages, unread_messages, new_pm, buddy_list, pm_ignore_list, pm_prefs, 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, is_activated, validation_code, id_msg_last_visit, additional_groups, smiley_set, id_post_group, total_time_logged_in, password_salt, ignore_boards, warning, passwd_flood, pm_receive_from, message_labels, secret_question, secret_answer, mod_prefs, data)
 VALUES...
All members and their info is listed for the values.  After that I get.
Code: [Select]
Unknown column 'new_pm' in 'field list'


Nao

  • Dadman with a boy
  • Posts: 16,079
Re: SMF 2 to Wedge importer errors
« Reply #1, on February 26th, 2014, 10:54 PM »
I'm on it. Will commit fixes asap.
Posted: February 26th, 2014, 10:44 PM

Committed. Keep me posted!

txcas

  • Bug Zapper
  • Posts: 202
Re: SMF 2 to Wedge importer errors
« Reply #3, on February 26th, 2014, 11:51 PM »
Now I get:
Code: [Select]
Importing...
Message: mysqli_free_result() [function.mysqli-free-result]: Couldn't fetch mysqli_result

Trace: mysqli_free_result() [function.mysqli-free-result]: Couldn't fetch mysqli_result

Line: 1810

File: /home/creedmoo/public_html/upgrade/import.php

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: SMF 2 to Wedge importer errors
« Reply #4, on February 26th, 2014, 11:57 PM »
Is this during the attachment import step..?
If yes, please test the new committed version.

txcas

  • Bug Zapper
  • Posts: 202
Re: SMF 2 to Wedge importer errors
« Reply #5, on February 27th, 2014, 12:06 AM »
I just tried the latest commit and now get:
Code: [Select]
Importing settings... ✔
Importing members... Unsuccessful!
 This query:

SELECT
 id_member, member_name, date_registered, posts, id_group, lngfile, last_login,
 real_name, instant_messages, unread_messages, buddy_list, pm_ignore_list,
 pm_prefs, 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, 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,
 message_labels, secret_question, secret_answer, mod_prefs, '' AS data
 FROM `creedmoo_wedge`.wedge_members
 LIMIT 0, 500;
Caused the error:

Unknown column 'message_labels' in 'field list'

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: SMF 2 to Wedge importer errors
« Reply #6, on February 27th, 2014, 12:09 AM »
message_labels is a valid members table fields in SMF 2... I don't know why it wouldn't work.

@TE, what do you think..? Is the <preparsecode> block buggy..?

Off to bed, personally.

live627

  • Should five per cent appear too small / Be thankful I don't take it all / 'Cause I'm the taxman, yeah I'm the taxman
  • Posts: 1,670
A confident man keeps quiet.whereas a frightened man keeps talking, hiding his fear.

txcas

  • Bug Zapper
  • Posts: 202
Re: SMF 2 to Wedge importer errors
« Reply #8, on February 27th, 2014, 03:46 AM »
It worked, but avatars are gone.  I think the last error was caused by the previous failed attempts to migrate the forum.

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: SMF 2 to Wedge importer errors
« Reply #9, on February 27th, 2014, 10:21 AM »
John, what are you trying to say..?

txcas, avatars should have been imported. Are attachments okay?
Make sure you didn't forget any of these steps:
- Let's say SMF is in /forum/
- Install Wedge in /forum2/ (or a sub-folder, but it requires some more work later)
- Run the importer
- Make sure /forum2 is working fine.
- Now, rename the /forum folder to /forum3, and immediately rename /forum2 to /forum
- Go to /forum, admin area, go to the 'Path' page (first sub-menu in the admin menu!)
- Fix all paths.
- Go to avatar and attachment settings pages, and fix all paths.
- IIRC, you also have to go to the skin settings page, and fix paths.

I should be building a tool to automatize the fixing of ALL paths with the 'wrong' folder in their name, if the main folder was modified... Oh yeah, that would be swell.

At this point, Aeva Media items still aren't imported. You'll need to move /forum3/media files to /forum/media, and then manually import AeMe database tables into the new location... Well, that one is NOT fun. Unfortunately, because @TE doesn't seem to want to finish the importer tool to support AeMe files (and I'm still not familiar enough with it to deal with adding an import step myself), upgrading your forum at this point MAY mean you'll lose your existing AeMe data forever.

Also, looking at your site, I really need to do something about the header CSS... Obviously, the header at wedge.org is working well, and it's not so good elsewhere, because I have custom.css CSS I never bothered to commit, but I really need to do it at this point.

txcas

  • Bug Zapper
  • Posts: 202
Re: SMF 2 to Wedge importer errors
« Reply #10, on February 27th, 2014, 01:16 PM »
Avatars and attachments are working now that I changed their paths.  Pretty URLs is the only thing that is broken because they are trying to use the old path.

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: SMF 2 to Wedge importer errors
« Reply #11, on February 27th, 2014, 02:35 PM »
You may have to run phpMyAdmin, edit the wedge_boards table, and modify all 'pretty_url' fields manually to match your new URL.

This is something that is better done with an automatic script, I guess, but I won't start work on this until I have a complete list of URLs and paths I'd need to update on the fly.
Also, I'm still wondering whether it's "worth" keeping variables such as $jsdir and $cssdir and others, when there really isn't much of a reason to 'hide' these files from view to visitors.

Pandos

  • Living on the edge of Wedge
  • Posts: 635
# dpkg-reconfigure brain
error: brain is not installed or configured

txcas

  • Bug Zapper
  • Posts: 202

Pandos

  • Living on the edge of Wedge
  • Posts: 635
Re: SMF 2 to Wedge importer errors
« Reply #14, on February 27th, 2014, 03:10 PM »
Go to: /do/admin/?area=manageboards;sa=board;boardid=1 (or whatever your boardid is).
There you can change PURL's settings for the desired board. Normally there is a select box where you can choose your URL (if defined).