giobby (@giobby)

Forum Replies Created

Viewing 25 replies - 1 through 25 (of 27 total)

  • giobby
    Participant

    @giobby

    Hi,

    It just says “Version 2.6-alpha”.

    I’ll try to download the beta version to check the improvements. Thanks.

    Concerning the feedbacks, I don’t really get anything useful from the users and I start believing they are just lazy.
    Even though, stats speak more than words: before bbpress I had about 11K sessions per month, now I have 800.


    giobby
    Participant

    @giobby

    Hi @thebrandonallen,

    What version of bbPress are you actually running? 2.6a
    Are you running any plugins that make use of new features and functions of 2.6? I don’t know, I am using buddypress and a bunch of other plugins which I don’t think use ay bbpress functionality
    Have you made any customizations to your theme that make use of new features and functions of 2.6? yes I did, but it’s more about styles and elements visibility

    Thanks


    giobby
    Participant

    @giobby

    Hi John,

    I am realising now my post it’s not really useful considering the way I wrote it and I should have thought twice before publishing it. In fact I may have given the wrong impression. Let me elaborate….

    Basically my users are facing some issue in terms of sudden disconnections/logouts and phantom posts (e.g. they create posts and forums and then they “lose” them or they cannot find them anymore).

    I have never faced these issues myself, but it’s also true I don’t access my forum often.
    Also, considering that I am using other plugins, I cannot be sure bbPress is actually the main reason behind the issues.

    What I can tell you for sure as a general feedback is that since I’ve moved to bbPRess from phpBB the forum has suddenly died and users are pushing me to roll back to phpBB as they don’t find bbPress as user friendly.

    2.6a has been there for a while and I am wondering when a stable version will be available and what new functionalities will be available.

    Meanwhile, what do you suggest to make my users happy?
    I am tempted to rollback to phpBB but I am also aware the resulting user experience would be quite disconnected.

    Any idea on how could I make bbPress more PHPBB-Like?

    Thanks,

    Gio


    giobby
    Participant

    @giobby

    Happy it worked for you. Unfortunately it’s more a workaraound than a solution so I don’t think it will be implemented. I’ve shared my feedbacks already and i truly believe there’s a bug in the converter. The temp table in which bbpress stores the metadata for the conversion works fine, so it’s probably about how the converter uses that table.
    Anyway, enjoy your new converted forum! 🙂


    giobby
    Participant

    @giobby

    There’s a missing space…

    wp_postsINNER should be wp_posts INNER


    giobby
    Participant

    @giobby

    Hi @senatorman , I think you’ve replied in the wrong topic (https://bbpress.org/forums/topic/bbpress-2-6-alpha-problem-importing-phpbb/page/2/#post-178123).

    Just to follow up on your error: I’ve copied and pasted my queries from a Ms Word document and something got broken.
    In fact you look at the single quotes in the queries they are all wrong (’ instead of ‘).

    I have fixed the query for you and you can find the new version below:

    
    /* Get all posts with wrong author and correspondent right author from translator table */
    
    create table TMP_ORPHANS as
    select
    <YOUR_SCHEMA>.wp_posts.ID,
    <YOUR_SCHEMA>.wp_posts.post_author,
    <YOUR_SCHEMA>.wp_bbp_converter_translator.value_id real_author,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_date, NULL) post_date,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_date_gmt, NULL) post_date_gmt,
    <YOUR_SCHEMA>.wp_posts.post_content,
    CASE
    WHEN <YOUR_SCHEMA>.wp_posts.post_type = 'reply'
    THEN (SELECT tmposts.post_title from <YOUR_SCHEMA>.wp_posts as tmposts where tmposts.id = <YOUR_SCHEMA>.wp_posts.post_parent)
    ELSE <YOUR_SCHEMA>.wp_posts.post_title
    END post_title,
    <YOUR_SCHEMA>.wp_posts.post_excerpt,
    <YOUR_SCHEMA>.wp_posts.post_status,
    <YOUR_SCHEMA>.wp_posts.comment_status,
    <YOUR_SCHEMA>.wp_posts.ping_status,
    <YOUR_SCHEMA>.wp_posts.post_password,
    <YOUR_SCHEMA>.wp_posts.post_name,
    <YOUR_SCHEMA>.wp_posts.to_ping,
    <YOUR_SCHEMA>.wp_posts.pinged,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified, NULL) post_modified,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified_gmt, NULL) post_modified_gmt,
    <YOUR_SCHEMA>.wp_posts.post_content_filtered,
    <YOUR_SCHEMA>.wp_posts.post_parent,
    <YOUR_SCHEMA>.wp_posts.guid,
    <YOUR_SCHEMA>.wp_posts.menu_order,
    <YOUR_SCHEMA>.wp_posts.post_type,
    <YOUR_SCHEMA>.wp_posts.post_mime_type,
    <YOUR_SCHEMA>.wp_posts.comment_count,
    (	select <YOUR_SCHEMA>.wp_postmeta.meta_value
    from <YOUR_SCHEMA>.wp_postmeta
    where
    <YOUR_SCHEMA>.wp_postmeta.meta_key = '_bbp_author_ip' and
    <YOUR_SCHEMA>.wp_postmeta.post_id = <YOUR_SCHEMA>.wp_posts.id
    ) user_ip
    from <YOUR_SCHEMA>.wp_posts
    left join <YOUR_SCHEMA>.wp_users on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_users.id
    left join <YOUR_SCHEMA>.wp_bbp_converter_translator on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_bbp_converter_translator.meta_value
    where
    <YOUR_SCHEMA>.wp_posts.post_type in ('forum', 'reply', 'topic') and
    (<YOUR_SCHEMA>.wp_users.id is null or
    <YOUR_SCHEMA>.wp_users.id = 1) and
    <YOUR_SCHEMA>.wp_bbp_converter_translator.value_type = 'user' and
    <YOUR_SCHEMA>.wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';
    
    /* Do this to be able to create indexes later – some may not work */
    ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
    ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);
    
    /* we create indexes to speed up the update process */
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);
    
    /* Revert bad authors to good authors */
    UPDATE
    <YOUR_SCHEMA>.wp_postsINNER JOIN <YOUR_SCHEMA>.TMP_ORPHANS
    ON <YOUR_SCHEMA>.wp_posts.id = <YOUR_SCHEMA>.TMP_ORPHANS.id
    set <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.TMP_ORPHANS.real_author
    where <YOUR_SCHEMA>.wp_posts.post_type in ('reply', 'topic') ;
    
    /* Drop TMP table */
    DROP TABLE <YOUR_SCHEMA>.TMP_ORPHANS;
    

    Please remember to execute each query individually and not all of them together.
    You can easily distinguish the queries as I have put a comment before each of them.


    giobby
    Participant

    @giobby

    Yes you should replace <YOUR_SCHEMA> with the name of the database schema in which your tables are.
    Anyway it’s probably not necessary, so you may actually remove it from the script (including the following ‘.’).


    giobby
    Participant

    @giobby

    I try to post here the steps I did to import from PHPBB to BuddyPress v2.6 alpha.
    The concept is the same of what you’ve already read in my previous post but I think the SQL scripts are different.

    So first of all I’ve created manually all the missing columns in my PHPBB tables (I was converting from an old version of PHPBB and the converter was expecting some columns that didn’t exist – this could not be your case):

    ALTER TABLE forum_forums
    ADD forum_posts_approved numeric;

    ALTER TABLE forum_forums
    ADD forum_topics_approved numeric;

    ALTER TABLE forum_topics
    ADD topic_posts_approved numeric;

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_facebook varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_twitter varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_occupation varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_interests varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_location varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_youtube varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_skype varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_googleplus varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_website varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_aol varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_yahoo varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_icq varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_wlm varchar(255);

    Then I’ve performed this KEY STEP: insert a dummy row in the WP_USERS table with a very high userid (e.g.: 99999). This should be higher than the highest userid you have in your phpbb installation.
    In this way, when the users get converted, the system will assigned IDs starting from 100000 (again, if you have more than 100K users, then you need a higher value).
    This step is necessary, so you will always be able to distinguish the old id (PHPBB, < 100000) from the new one assigned after conversion (>= 100000).

    After that I’ve started the conversion (it took long).
    After converting, the authors of certain posts were wrong.
    There is a table that is generated after the conversion that maps the old IDs to the new ones.
    So I’ve execute the following scripts to readjust (cannot guarantee this would fix entirely the problem):

    /* Get all posts with wrong author and correspondent right author from translator table */

    create table TMP_ORPHANS as
    select
    <YOUR_SCHEMA>.wp_posts.ID,
    <YOUR_SCHEMA>.wp_posts.post_author,
    <YOUR_SCHEMA>.wp_bbp_converter_translator.value_id real_author,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_date, NULL) post_date,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_date_gmt, NULL) post_date_gmt,
    <YOUR_SCHEMA>.wp_posts.post_content,
    CASE
    WHEN <YOUR_SCHEMA>.wp_posts.post_type = ‘reply’
    THEN (SELECT tmposts.post_title from <YOUR_SCHEMA>.wp_posts as tmposts where tmposts.id = <YOUR_SCHEMA>.wp_posts.post_parent)
    ELSE <YOUR_SCHEMA>.wp_posts.post_title
    END post_title,
    <YOUR_SCHEMA>.wp_posts.post_excerpt,
    <YOUR_SCHEMA>.wp_posts.post_status,
    <YOUR_SCHEMA>.wp_posts.comment_status,
    <YOUR_SCHEMA>.wp_posts.ping_status,
    <YOUR_SCHEMA>.wp_posts.post_password,
    <YOUR_SCHEMA>.wp_posts.post_name,
    <YOUR_SCHEMA>.wp_posts.to_ping,
    <YOUR_SCHEMA>.wp_posts.pinged,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified, NULL) post_modified,
    IFNULL(<YOUR_SCHEMA>.wp_posts.post_modified_gmt, NULL) post_modified_gmt,
    <YOUR_SCHEMA>.wp_posts.post_content_filtered,
    <YOUR_SCHEMA>.wp_posts.post_parent,
    <YOUR_SCHEMA>.wp_posts.guid,
    <YOUR_SCHEMA>.wp_posts.menu_order,
    <YOUR_SCHEMA>.wp_posts.post_type,
    <YOUR_SCHEMA>.wp_posts.post_mime_type,
    <YOUR_SCHEMA>.wp_posts.comment_count,
    ( select <YOUR_SCHEMA>.wp_postmeta.meta_value
    from <YOUR_SCHEMA>.wp_postmeta
    where
    <YOUR_SCHEMA>.wp_postmeta.meta_key = ‘_bbp_author_ip’ and
    <YOUR_SCHEMA>.wp_postmeta.post_id = <YOUR_SCHEMA>.wp_posts.id
    ) user_ip
    from <YOUR_SCHEMA>.wp_posts
    left join <YOUR_SCHEMA>.wp_users on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_users.id
    left join <YOUR_SCHEMA>.wp_bbp_converter_translator on <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.wp_bbp_converter_translator.meta_value
    where
    <YOUR_SCHEMA>.wp_posts.post_type in (‘forum’, ‘reply’, ‘topic’) and
    (<YOUR_SCHEMA>.wp_users.id is null or
    <YOUR_SCHEMA>.wp_users.id = 1) and
    <YOUR_SCHEMA>.wp_bbp_converter_translator.value_type = ‘user’ and
    <YOUR_SCHEMA>.wp_bbp_converter_translator.meta_key = ‘_bbp_old_user_id’;

    /* Do this to be able to create indexes later – some may not work */
    ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
    ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);

    /* we create indexes to speed up the update process */
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);

    /* Revert bad authors to good authors */
    UPDATE
    <YOUR_SCHEMA>.wp_postsINNER JOIN <YOUR_SCHEMA>.TMP_ORPHANS
    ON <YOUR_SCHEMA>.wp_posts.id = <YOUR_SCHEMA>.TMP_ORPHANS.id
    set <YOUR_SCHEMA>.wp_posts.post_author = <YOUR_SCHEMA>.TMP_ORPHANS.real_author
    where <YOUR_SCHEMA>.wp_posts.post_type in (‘reply’, ‘topic’) ;

    DROP TABLE <YOUR_SCHEMA>.TMP_ORPHANS;

    I hope this helps.

    Gio


    giobby
    Participant

    @giobby

    I hope this helps you: https://bbpress.org/forums/topic/import-phpbb-wrong-authors/
    I had to write some custom queries to fix the wrong authors problems.
    Can’t promise it’s going to work, but when I’ve run some counts on the tables during the process it looked that all the orphan posts were correctly reassigned to the wrong author.

    Good luck!


    giobby
    Participant

    @giobby

    I’ve fixed it by disabling the “nested replies” option.


    giobby
    Participant

    @giobby

    I’ve also tried to rollback to 2.5 but replies are still not paginated


    giobby
    Participant

    @giobby

    Version is 2.6 alpha


    giobby
    Participant

    @giobby

    I’ve used 2.6 alpha for this import on a fresh wordpress installation. I’va also imported the users.
    This behaviour was the same in the previous 2 versions.
    I had more the 60000 posts affected over more than 300000.
    I believe the parser failed to link the replies to the wordpress users under certain conditions but I haven’t been able to prove it yet.
    I am using an old version of phpbb so probably this influenced as well.


    giobby
    Participant

    @giobby

    After further investigations I’ve found a workaround that should work.

    Just to recap on the error: it seems like several posts are left with the old phpBB poster id rather than using the new wordpress user_id (which really makes me think that somewhere in the converter code a wrong reference has been used).

    The best way to work around the issue is the following (assuming a fresh installation):

    1) before migration
    – check what is the highest user_id in your phpBB installation (e.g.: 6235)
    – insert a dummy row in wp_users with id grater than that (e.g.: 6236, or even better, round it up to 10000). In this way all the converted users will have their IDs starting from a higher value (e.g.: 10001, 10002, …) and it will be easy to spot the posts with wrong author (e.g. post_author < 10000).

    2) launch migration as usual
    3) after migration, create a temporary table that lists all the bbpress posts with wrong author

    /* Get all posts with wrong author and correspondent right author from bbpress translator table */
    create table TMP_ORPHANS as
    select 
    wp_posts.ID, 
    wp_posts.post_author,
    wp_bbp_converter_translator.value_id real_author, 
    IFNULL(wp_posts.post_date, NULL) post_date,
    IFNULL(wp_posts.post_date_gmt, NULL) post_date_gmt,
    wp_posts.post_content, 
    CASE 
    	WHEN wp_posts.post_type = 'reply'
        THEN (SELECT tmposts.post_title from wp_posts as tmposts where tmposts.id = wp_posts.post_parent)
        ELSE wp_posts.post_title
    END post_title, 
    wp_posts.post_excerpt, 
    pescasubac, 
    wp_posts.quea.wp_posts.post_status, 
    wp_posts.comment_status, 
    wp_posts.ping_status, 
    wp_posts.post_password, 
    wp_posts.post_name, 
    wp_posts.to_ping, 
    wp_posts.pinged, 
    IFNULL(wp_posts.post_modified, NULL) post_modified,
    IFNULL(wp_posts.post_modified_gmt, NULL) post_modified_gmt,
    wp_posts.post_content_filtered, 
    wp_posts.post_parent, 
    wp_posts.guid, 
    wp_posts.menu_order, 
    wp_posts.post_type, 
    wp_posts.post_mime_type, 
    wp_posts.comment_count,
    	(	select wp_postmeta.meta_value 
    		from wp_postmeta 
    		where 
    			wp_postmeta.meta_key = '_bbp_author_ip' and 
    			wp_postmeta.post_id = wp_posts.id
    	) user_ip
    from wp_posts 
    left join wp_users on wp_posts.post_author = wp_users.id
    left join wp_bbp_converter_translator on wp_posts.post_author = wp_bbp_converter_translator.meta_value
    where 
    wp_posts.post_type in ('forum', 'reply', 'topic') and
    (wp_users.id is null or 
    wp_users.id = 1) and /* all posts of type forum looks to be assigned to the site admin (id=1 in my case)*/
    wp_bbp_converter_translator.value_type = 'user' and 
    wp_bbp_converter_translator.meta_key = '_bbp_old_user_id';
    
    /* this is to be able to create indexes later */
    ALTER TABLE TMP_ORPHANS modify column post_date datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_date_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column post_modified_gmt datetime default NULL;
    ALTER TABLE TMP_ORPHANS modify column user_ip varchar(40);
    ALTER TABLE TMP_ORPHANS modify column post_title varchar(255);
    
    /* indexes to speed up access to the table (some are useless) */
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_date);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(real_author);
    ALTER TABLE TMP_ORPHANS ADD INDEX(user_ip);
    ALTER TABLE TMP_ORPHANS ADD INDEX(post_title);

    4) Now that you’ve got the list of posts with wrong authors, you can update your wp_posts table accordingly

    /* Revert bad authors to good authors */
    UPDATE 
    wp_postsINNER JOIN TMP_ORPHANS 
    ON wp_posts.id = TMP_ORPHANS.id
    set wp_posts.post_author = TMP_ORPHANS.real_author 
    where wp_posts.post_type in ('reply', 'topic') ;

    Final consideration:
    – this workaround seems to be working for me, but of course I don’t assume any responsibility in case it doesn’t work for you. The update trusts the converter table generated by the bbpress forum converter and assumes that a wrong author id matches the original author id of phpBB forum (I executed some checks and it seems like the problem is always the same = phpBB author id rather than new wordpress author id).
    – the update doesn’t fix posts of type ‘forum’ because by default these are assigned to the wordpress site administrator. If you wish to assign them to the original phpBB author, just modify the where condition:
    where wp_posts.post_type in ('forum','reply', 'topic') ;

    message to the developers: I truly believe somewhere in the converter code a wrong reference is used under certain conditions. The pattern of the error is always the same: when the author doesn’t match it’s because the author id of the phpBB forum rather than the new converted author id.

    @netweb


    giobby
    Participant

    @giobby

    Hi Stephen

    Just to let you know I’ve tried 2.6 alpha and the result is even worse in terms of post authors.
    I’ve got plenty of anonymous and mismatching authors.

    What I’ve noticed it’s again the same behaviour: several converted posts have an associated author id that is either 0 or that matches the author id of the imported forum.
    Example:
    PhpBB post’s author id is 1102
    WP converted post’s author id is 1102 when it should be 18044

    I’ve created a table that translates the phpbb user id to the bbpress user id by joining on email address. This in theory can allow me to set the post_author to the appropriate value.
    The problem is to spot the affected posts.
    I am trying a mix of criteria, by looking at the post creation date, user ip, etc. but it’s no simple.

    I would be happy to provide additional info if you want.

    Regards,

    Gio

    @netweb


    giobby
    Participant

    @giobby

    Ok, I’ve finally completes the conversion (took only 8 hours against the 2 days of the previous versions).

    Nevertheless, big problem here: I can see no forum after the conversion.
    I’ve been checking the database schema in which wordpress is installed and nothing….
    I can only find an empty wp_bbp_converter_translator table and for the rest: no users converted, no posts, no forum and topics tables.

    Does someone has any idea why this happened?
    It actually looked like it was converting something and the number of interactions I’ve seen in the log during the conversion matches the actual numbers in PhpBB.

    I would appreciate if someone can help.

    Thanks,

    Gio


    giobby
    Participant

    @giobby

    Ok, I had to create manually all these columns.
    Here what I did (I use ‘forum_’ as table prefix):

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_facebook varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_twitter varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_occupation varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_interests varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_location varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_youtube varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_skype varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_googleplus varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_website varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_aol varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_yahoo varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_icq varchar(255);

    ALTER TABLE forum_profile_fields_data
    ADD pf_phpbb_wlm varchar(255);


    giobby
    Participant

    @giobby

    Just realised I didn’t post the right error.
    Here it is…

    Error Code: 1054. Unknown column ‘profile_fields_data.pf_phpbb_website’ in ‘field list’.

    That column doesn’t exist in my profile_fields_data table.
    Also, I was not getting that error with the previous version of the converter so i am wondering if the converter expects a specific/recent phpBB version to convert from


    giobby
    Participant

    @giobby

    Adding additional details:

    I am using MySql Server 5.7.12
    I’ve tried to change my database charset to utf8mb4 but I still get the same error.


    giobby
    Participant

    @giobby

    After further investigation, It looks to be something related to the character – see error below.

    Error Code: 1115. Unknown character set: ‘“utf8mb4”’

    Not sure why it’s trying to make this conversion :-\


    giobby
    Participant

    @giobby

    That’s good to know.
    I’ve already created a dev environment but the conversion takes too long, so I prefer to wait until the official release is out as I will have to redo the conversion on with that version anyway.

    Does anybody know when 2.6 will be released?


    giobby
    Participant

    @giobby

    Not yet. I am actually waiting for 2.6 to be released as I prefer not to roll out with the alpha version.
    Any idea on when 2.6 will be release?

    Thanks,

    Gio


    giobby
    Participant

    @giobby

    I have the same issue with the blank page when recalculating replies position (I am running on 2.5.9, but I have faced the same behaviour on 2.5.8 also).


    giobby
    Participant

    @giobby

    Any update on when the new version will be release?

    I am using the latest 2.5.9 but still no success (I was using 2.5.8 when I wrote this post)


    giobby
    Participant

    @giobby

    Thanks Stephen,

    That’s great news.
    I will wait for the stable version and then I’ll run again the conversion.

Viewing 25 replies - 1 through 25 (of 27 total)