[@mikehaceman Participant 8 years ago]

any update on this matter?

Thanks

[@mikehaceman Participant 8 years ago]

Thanks for the advice @timsilva_ Unfortunately im not generating any income from my forum so spending tons of money just to move it from smf to bb is not the best solution in my case 🙁

@netweb
error is [Key column ‘meta_id’ doesn’t exist in table] – im not sure this error is specific to my website only. Im guessing here of course, but it sounds like meta_id has not been created by bb converter but it needs it during conversion process…

[@mikehaceman Participant 8 years ago]

Ok it was hanging for too long so here what i found out:

on the patch page (https://bbpress.trac.wordpress.org/attachment/ticket/3026/3026.patch) you made few mistakes:

1. Line 663 KEY meta_join (meta_key, meta_value) ) {$charset_collate};”;
should finish with ” , ” not ” ;”; ” otherwise it will crash error

2. Line 660 PRIMARY KEY (meta_id),
is duplicated so i guess 660 or 661 can be removed

3. when running import after those changes in wordpress, converter is giving error message:

WordPress database error: [Key column ‘meta_id’ doesn’t exist in table]
CREATE TABLE wp_bbp_converter_translator ( value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key, meta_value) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Btw… im not a coder. No clue about php im just applying some logic to what i see 😉

[@mikehaceman Participant 8 years ago]

I followed the patch instruction and updated the file manually. The conversion did kicked off and the wheel is spinning for an hour now.

Fingers crossed, because it is doing something!!

Hopefully it will not crash, Ill leave it for some time. Will update as soon as possible.

Thanks

[@mikehaceman Participant 8 years ago]

Hi @johnjamesjacoby

Thanks for the update. I have downloaded again the alpha and installed it fresh on my website. Unfortunately still the same error message:

Repair any missing information: Continue
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_bbp_converter_translator ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key, meta_value) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
No data to cleanStarting Conversion

[@mikehaceman Participant 8 years ago]

Thank you for the reply. I have downloaded and installed alpha.
When running import im getting error:

Repair any missing information: Continue
WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE wp_bbp_converter_translator ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key, meta_value) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

I tried to find this error and potential solution. I found someone recommending bbpress toolkit. I have installed it and system info is as follow:

WP version 4.6.1
Theme Twenty Sixteen 1.3
PHP version 5.4.19
bbPress version 2.6-alpha-6091
Active Plugins Name and Version
– p1 bbP Toolkit 1.0.6
– p2 bbPress 2.6-alpha

Any idea ?

[@mikehaceman Participant 8 years ago]

bump or it will be lost 🙁

[@mikehaceman Participant 8 years, 1 month ago]

Hi @runamuck

Have you found solution to this problem? I have almost exactly same issue here!

[@mikehaceman Participant 8 years, 1 month ago]

Nobody knows what could be the problem here?

[@mikehaceman Participant 8 years, 1 month ago]

Any ideas? Am I the only one moving smf to bbpress?