Stephen Edgar (@netweb)

Forum Replies Created

Viewing 25 replies - 2,801 through 2,825 (of 3,353 total)
  • In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    I have made quite a few tweaks 😉

    You can see the revisions I made up until last night here

    https://gist.github.com/4633175/revisions
    (It is a fork or your gist with my changes)

    I have just added ‘topic tags’ and just cleaning up the code ready to submit for bbPress core 😉

    What else have you changed? If you update your original gist, I can look at any differences and merge those also.

    @netweb

    Keymaster

    Rename your CSS file from style-forum.css to bbpress.css in your themes root directory.

    @netweb

    Keymaster

    Are you using the builtin importer included with bbPress?
    https://codex.bbpress.org/import-forums/
    https://codex.bbpress.org/import-forums/simplepress

    Were any replies imported or did the converter stop at topic 490?

    Once the conversion stops if you click ‘start’ again without changing any options does it then complete or stop at the same point?

    If it does continuously stop in the same position open phpMyAdmin and open the `wp_options` table and bump the value stored in `_bbp_converter_start` by 1 and click start again, if it fails again bump this value again.

    When you want to start again fresh and remove all topics, forums, topic tags & replies previously imported check the ‘Start Over’ & ‘Purge Previous Import’ checkboxes.

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    Just finishing this off today and I will post back with a link to the docs and download

    @netweb

    Keymaster

    This is what I am using as a custom plugin on a site:

    
    if ( bbp_has_topics( array( 'author' => 0, 'show_stickies' => 'false', 'meta_key' => '_bbp_last_active_time', 'orderby' => 'meta_value', 'order' => 'DESC', 'post_parent' => 'any', 'posts_per_page' => 5 ) ) )
    		bbp_get_template_part( 'bbpress/loop', 'topics' );
    

    Where post_parent = ‘any’ forum or change this to a specific forum id

    It is based on this https://gist.github.com/4207064

    @netweb

    Keymaster

    – Name BDD : The name in my wp-config (i use the same base for forum and a wordpress installation)

    – Name user BDD : The user in my wp-config

    – Pass : The Pass in my wp-config

    These are your WordPress settings, you need to use your phpBB database name, database user & database user password.

    @netweb

    Keymaster

    These are the settings you should use:
    Select Platform: Mingle
    Database Server: localhost
    Database Port: 3306
    Database Name: My database name
    Database User: My database user name
    Database Password: My database password (which I use to login to phpMyAdmin)
    Table Prefix: wp_

    The changes above are `localhost` for the database server which is the default and is what is needed for most web hosts, the table prefix `wp_` which matches the screenshot you linked to above.

    If this does not work confirm with your webhost the correct settings for your database name, user & password.

    @netweb

    Keymaster

    Is this the full solutions already?

    Yes

    Or the known issues are still there at https://codex.bbpress.org/import-forums/mingle/ ?

    This is up to date, anything listed here are the ‘workarounds’ you will need to do manually.

    1) Which folder to put this file Mingle.php ?

    Download `Mingle.php` using this link and upload the file with FTP to `/wp-content/plugins/bbpress/includes/admin/converters`

    2) Just quickly have a look at my phpMyAdmin http://visionopen.com/questions/phpMyAdmin.png, is there any potential issue(s) for me to proceed with this Mingle.php?

    Everything looks good here, on the import screen where it asks for table prefix use `wp_`

    Remember to backup your web site pages and database first though…

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    Currently there is no support for topic subscriptions or favorites…

    It is all stored in wp_usermeta

    eg. User ID = 1, meta_key = __bbp_subscriptions, topic_id = 181889
    user_id | meta_key | meta_value
    1 | wp__bbp_subscriptions | 181889
    1 | wp__bbp_favorites | 181889
    (Note the double underscores __bbp)

    Your old database will have the old topicid you’ll want to look in wp_postmeta to get some values.

    eg. New TopicID = 181889, meta_key = _bbp_old_topic_id, Old TopicID
    post_id | meta_key | meta_value
    181889 | _bbp_old_topic_id | 4631

    @netweb

    Keymaster

    bbPress uses the permalink settings (/wp-admin/options-general.php?page=bbpress) to determine if we are loading something that is bbPress, if it is bbPress we are loading then we need to load the appropriate bbPress template.

    So if the CPT permalink plugin you are using is hijacking WordPress CPT’s before bbPress can detect its own CPT permalink to load a bbPress template then no bbPress template will be loaded.

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    We will have to go down that route for now as the phpBB import has a similar issue and at the moment the docs state to manually delete these after import.

    We can look into why the converter isn’t doing joins correctly on the user table for future versions as if we changed to much there now I am quite sure we would break other stuff and would have very little time to test this at this stage.

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    Did you use a custom table prefix when importing Vanilla?

    When you setup Vanilla does it let you set a table prefix or does it always use its own choice?

    eg from_tablename’ => ‘User’,

    If ALL Vanilla forums use this structure and you DO NOT enter a table prefix for conversion I have a fix that will the filter users during import.

    @netweb

    Keymaster

    If you are going to use a plugin to hack the permalinks of bbPress, this is ‘that’ plugins support issue not a bbPress issue as permalinks in bbPress work as expected per design.

    You would be far better of asking in the ‘Custom Post Type Permalinks’ support forum and even read some of those topics for similar issues.

    https://wordpress.org/support/plugin/custom-post-type-permalinks

    In reply to: Ipb 3.3 to bbpress

    @netweb

    Keymaster

    There are a couple of diff’s there but just missing ‘post_title’ should still import the replies.

    If you could send me a link to download (FTP, Dropbox, whatever) the database i’ll take a look and try to get things working for both IPB 3.2 & 3.3.

    In reply to: Ipb 3.3 to bbpress

    @netweb

    Keymaster

    Can you open up myPhpAdmin on your webhost and open the IPB database and then the ‘posts’ table and paste the SQL structure for that table here.

    The below is from IPB 3.2 and I am curious if there are any changes in 3.3, It should be similar to this:

    `

    1 pid
    2 append_edit
    3 edit_time
    4 author_id
    5 author_name
    6 use_sig
    7 use_emo
    8 ip_address
    9 post_date
    10 icon_id
    11 post
    12 queued
    13 topic_id
    14 post_title
    15 new_topic
    16 edit_name
    17 post_key
    18 post_htmlstate
    19 post_edit_reason
    20 post_bwoptions
    21 pdelete_time
    `

    @netweb

    Keymaster

    Thanks 🙂

    @netweb

    Keymaster

    Thats great news, would you mind adding a comment to that ticket #2155 in trac with details of your setup and results from your testing.

    @netweb

    Keymaster

    Can you create a bug ticket over at trac for this please

    https://bbpress.trac.wordpress.org/

    In reply to: Ipb 3.3 to bbpress

    @netweb

    Keymaster

    It should convert the replies as I am currently updating it with some ‘extra’ stuff.

    Do you see an error displayed in the yellow status conversion window? If so what is it?

    Did you run the ‘repair tools’ after importing to ‘recount’ all the things?

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    I just added a UserRole table to the DB I am working with and added a field RoleID and set some users to RoleID = 3 and the resulting query should not import users with RoleID = 3 though it is.

    I’ll take another look at what might be going on here as it doesn’t seem to be picking up the ‘join’ when processing the user section.

    Can you upload a copy of your Vanilla converter to http://gist.github.com and i’ll take a look at what you have in there and will add some of the other table mappings that I have been adding to all the other converters over the past week (I haven’t added these to the Example.php converter yet, they are just extra mappings to help bbPress during the recounts after importing etc)

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    Do you have any other ‘joins’ you are trying to use with the ‘user’ section?

    All your mappings including all ‘join’ and ‘where’ statements etc in each field mapping in each of the sections forums, topics, topic-tags, replies & users must all be able to be piled to together to form a valid SQL query for that section.

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    Try this…

    `
    $this->field_map[] = array(
    ‘from_tablename’ => ‘UserRole’,
    ‘from_fieldname’ => ‘UserID’,
    ‘from_expression’ => ‘WHERE User.Deleted = 0′,
    ‘join_tablename’ => ‘User’,
    ‘join_type’ => ‘INNER’,
    ‘join_expression’ => ‘USING (UserID) WHERE UserRole.RoleID != 3′,
    ‘to_type’ => ‘user’,
    ‘to_fieldname’ => ‘_bbp_user_id’
    );
    `

    Unless the ‘from_tablename’ is different from the other ‘from_tablename’ fields in each of the query sections it will not initiate the SQL ‘join’…

    Its just one of those things going on in the whole ‘lets build some awseome SQL queries’

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    1) In the yellow status window of the importer if you right click in Firefox/Chrome ‘inspect element’ you can check the SQL queries that the importer ran, have a look at the SQL query for the user import and check if that is what the SQL query should be.

    The from/join logic is in converter.phpL#777 and you can use that as a guide to how to translate your query to the fields you are mapping.

    2) I would not worry about this option as once you have finished the import and start to run the ‘repair forums’ tools the last option is “Remap existing users to default forum roles” and that will set all users without a bbPress role to ‘participant’

    Feel free to throw any questions you have here as I am trying to fix a join for the Invision.php importer as we speak and its being a pain also 😉

    In reply to: Vanilla 2 Converter

    @netweb

    Keymaster

    What do you want to know?

    There is no need to reverse engineer anything, just grab the latest copy of Example.php either from /bbpress/includes/admin/converters/ or the latest updated version I am working on here and start modifying the table mappings as per the docs in the codex.

    https://codex.bbpress.org/import-forums/ & https://codex.bbpress.org/import-forums/custom-import/

    In reply to: Ipb 3.3 to bbpress

    @netweb

    Keymaster

    Yes, bbPress includes an importer to convert your Invision (IPB) forums and users to bbPress.
    https://codex.bbpress.org/import-forums/

Viewing 25 replies - 2,801 through 2,825 (of 3,353 total)