Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

punbb 1.2.16 to vanilla

edited January 2012 in Vanilla 2.0 - 2.8

hi there,

the converter does convert this:

Vanilla Export: 1.6.4, Source: PunBB 1.*, HashMethod: punbb 
// Export Started: 2012-01-17 14:36:11 
// Exported Table: User (0 rows, 00:00.00) Table: Role RoleID,Name 1,"Admin" 2,"Mod" 3,"Gast" 4,"Pirat" 7,"Herforder" 
// Exported Table: Role (5 rows, 00:00.01) 
// Exported Table: Permission (0 rows, 00:00.00) Table: UserRole UserID,RoleID 1,3 2,1 263,7 3,1 4,7 5,7 6,7 8,7 10,7 12,1 25,7 18,7 26,7 20,7 303,7 24,1 275,7 299,7 209,7 266,7 265,7 267,7 269,7 268,7 
// Exported Table: UserRole (24 rows, 00:00.01) Table: UserMeta Name,Value "Plugin.Signatures.Sig","Nur Idioten halten Ordnung\, Genies beherrschen das Chaos!" "Plugin.Signatures.Sig","4566." "Plugin.Signatures.Sig","they see me trollin'\, they hatin'" "Plugin.Signatures.Sig","123" "Plugin.Signatures.Sig","\"Was ist das?\" ... \"Blaues licht!\" ... \"Was macht es?\" ... \"Es leuchtet blau!!!\"" "Plugin.Signatures.Sig","Wurst für ALLLE!" "Plugin.Signatures.Sig","21\, Dr. Sport. Geh ne Runde laufen..." "Plugin.Signatures.Sig","Aequis aequus\,\ \ olibaba" 
// Exported Table: UserMeta (8 rows, 00:00.00) 
// Exported Table: Category (0 rows, 00:00.00) 
// Exported Table: Discussion (0 rows, 00:00.00) 
// Exported Table: Comment (0 rows, 00:00.00) 
// Exported Table: Tag (0 rows, 00:00.00) 
// Exported Table: TagDiscussion (0 rows, 00:00.00) 
// Exported Table: Media (0 rows, 00:00.00) 
// Export Completed: 2012-01-17 14:36:12 
// Elapsed Time: 00:00.03

it doesnt convert users, posts, threads...

what can i do about that

thanks in advance
robin

Answers

  • LincLinc Detroit Admin

    Looks like there's a problem on the UserMeta table.

    If you want to send me a dump of your database, I'll give it a test. Unfortunately I don't have punBB test data sitting around. Email is in my profile.

  • Hi, I am having a similar problem for the French PunBB 1.2.15 that is based on PunBB 1.2.17. The converter tells me that there is no User Table.

  • @nahana Can you look in the source of the Porter Plugin and look for the text that the Porter Plugin is showing? Code is more understandable in this case

    There was an error rendering this rich post.

  • edited June 2012

    Hi Guys,

    Hopefully I am not "hijacking" the post here. Quick question. Few days ago I've installed latest Vanilla and everything went great and since you guys offer this nice tool I wanted to import PunBB 1.4.2 over to Vanilla, however it doesn't matter what I do, only users and tags are imported over.

    I checked and double checked just to make sure nothing was missed, but it doesn't matter what I do, topics, posts are not transferred.

    If anyone can tell me how to get this going I would highly appreciate?

    Thanks,
    Emil

  • And in case that you want to see the message after the "Begin Export"

    Export Started: 2012-06-28 22:22:48
    Exported Table: User (1742 rows, 00:00.32)
    Exported Table: Role (5 rows, 00:00.00)
    Exported Table: Permission (5 rows, 00:00.01)
    Exported Table: UserRole (1743 rows, 00:00.02)
    Exported Table: UserMeta (5 rows, 00:00.00)
    Exported Table: Category (0 rows, 00:00.00)
    Exported Table: Discussion (0 rows, 00:00.00)
    Exported Table: Comment (0 rows, 00:00.00)
    Exported Table: Tag (1009 rows, 00:00.04)
    Exported Table: TagDiscussion (1912 rows, 00:00.04)
    Exported Table: Media (120 rows, 00:00.02)
    Export Completed: 2012-06-28 22:22:49
    Elapsed Time: 00:00.46
    

    Just tried it once again.

  • Found the issue actually. Porter allows you to change the database prefix right? well mine was changed to something else and from porter directly this was not working the way it should (even after renaming the prefix to what I changed that in) because punbb_ was in the code itself.

    For example if this is hardcoded in porter:

    punbb_forums

    and your prefix is different it will not work. I renamed all punbb_ to my custom prefix, upload it, ran it again and voila, everything was in place and fully working. You guys might want to check this.

    Thanks,
    Emil

  • UnderDog said:
    @nahana Can you look in the source of the Porter Plugin and look for the text that the Porter Plugin is showing? Code is more understandable in this case

    How can I find the source? Sorry if this is a silly question.

  • Oops My file looks so different then everyone elses so I got confused. Here you go (I deleted some of it because it was way to long to fit in here):

    `Vanilla Export: 1.6.4, Source: PunBB 1.*, HashMethod: punbb

    // Export Started: 2012-06-29 11:54:46

    // Exported Table: User (0 rows, 00:00.00)

    Table: Role
    RoleID,Name
    1,"Administrateurs"
    2,"ModÈrateurs"
    3,"InvitÈs"
    4,"Membres"

    // Exported Table: Role (4 rows, 00:00.00)

    // Exported Table: Permission (0 rows, 00:00.00)

    Table: UserRole
    UserID,RoleID
    1,3
    2,1
    3,4
    (It goes on like this for a while)

    "Plugin.Signatures.Sig","IT"
    "Plugin.Signatures.Sig","I'am love cats."
    "Plugin.Signatures.Sig","MLM"
    "Plugin.Signatures.Sig","http://designery.info/"
    "Plugin.Signatures.Sig","[url=http://www.espanacams_krs.espanacams.com]Espanacams web cams[/url]"
    "Plugin.Signatures.Sig","Cheap travel cot"
    "Plugin.Signatures.Sig","Good luck!"
    "Plugin.Signatures.Sig","http://207.226.173.106/123/teen/1/index.htm"
    "Plugin.Signatures.Sig","Agriculture"
    "Plugin.Signatures.Sig","Porn Sex :esbian Sex"
    "Plugin.Signatures.Sig","Your figaro friend"
    "Plugin.Signatures.Sig","Find some good music at [url=http://www.dreadnut.net]www.dreadnut.net[/url] or support us at [url=http://www.sellaband.com/dreadnut]SellaBand.com[/url]"
    "Plugin.Signatures.Sig","www.myspace.com/xURSUSS"
    "Plugin.Signatures.Sig","Eric R"
    "Plugin.Signatures.Sig","Mboa ngÙ nyÈ ndÈ mboa."

    // Exported Table: UserMeta (5092 rows, 00:00.24)

    Table: Category
    CategoryID,Name,Description,Sort,ParentCategoryID
    9,"CONCERTS","Went to a Richard Bona concert? Share your thoughts.",20,1000
    10,"RECORDINGS","What do you think about Richard Bona's recordings?",30,1000
    11,"BONA AS A SIDEMAN","Share your thoughts about all of the artists Richard has played and recorded with over the years.",80,1000
    12,"QUESTIONS","Have a question about Richard?",100,1000
    13,"RICHARD BONA BAND","Have any questions or comments about the musicians that play with Richard? Ask them here.",70,1000
    15,"MISC","For any post that doesn't fit with the other topics.",110,1000
    16,"Welcome/Bienvenue","Please email forum@bonamusic.com to register.",10,1000
    17,"APPEARANCES on TV and RADIO",\N,40,1000
    19,"PRESS & LINKS","Found something interesting about Richard on the internet? Post it here.",50,1000
    20,"GEAR","Want to know what gear Richard was playing? Ask here.",90,1000
    22,"LYRICS","Translate your favorite song or learn what the lyrics mean.",60,1000
    6000,"CONCOURS / CONTEST","",10,\N
    4000,"OTHER DISCUSSIONS :","",40,\N
    3000,"MUSICIANS","",30,\N
    2000,"VISITOR'S BOOK","",50,\N
    1000,"RICHARD BONA","",20,\N

    // Exported Table: Category (16 rows, 00:00.00)

    // Exported Table: Discussion (0 rows, 00:00.00)

    // Exported Table: Comment (0 rows, 00:00.00)

    // Exported Table: Tag (0 rows, 00:00.00)

    // Exported Table: TagDiscussion (0 rows, 00:00.00)

    // Exported Table: Media (0 rows, 00:00.00)

    // Export Completed: 2012-06-29 11:54:46
    // Elapsed Time: 00:00.38
    `

  • Hello, I figured this out by transferring my forum from punbb 1.x to phpbb2, and then to Vanilla

  • LincLinc Detroit Admin

    @emiluzelac Thanks for the heads up.

  • This isn't working for me either. I tried emiluzelac's trick but that didn't seem to change anything.

    What I get:

    Warning: Invalid argument supplied for foreach() in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 7374 Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 2887
             select 
               u.*, 
               concat(u.password, '$', u.salt) as PasswordHash, 
               from_unixtime(registered) as DateInserted, 
               from_unixtime(last_visit) as DateLastActive
             from oldlounge_users u
             where group_id <> 2;Unknown column 'u.salt' in 'field list'
    Notice: Unknown column 'u.salt' in 'field list' in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
          select
             g.*,
             g_post_replies as `Garden.SignIn.Allow`,
             g_mod_edit_users as `Garden.Users.Add`,
             case when g_title = 'Administrators' then 'All' else null end as _Permissions
          from oldlounge_groups g;Unknown column 'g_mod_edit_users' in 'field list'
    Notice: Unknown column 'g_mod_edit_users' in 'field list' in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
          select
            id,
            forum_name,
            forum_desc,
            disp_position,
            cat_id * 1000 as parent_id
          from punbb_forums f
          union
    
          select
            id * 1000,
            cat_name,
            '',
            disp_position,
            null
          from punbb_categories;Table 'ottens_co_uk.punbb_forums' doesn't exist
    Notice: Table 'ottens_co_uk.punbb_forums' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
          select t.*, 
            from_unixtime(p.posted) as DateInserted, 
            p.poster_id, 
            p.poster_ip,
            p.message,
            from_unixtime(p.edited) as DateUpdated, 
            eu.id as UpdateUserID,
            'BBCode' as Format
          from punbb_topics t
          left join punbb_posts p
            on t.first_post_id = p.id
          left join punbb_users eu
            on eu.username = p.edited_by;Table 'ottens_co_uk.punbb_topics' doesn't exist
    Notice: Table 'ottens_co_uk.punbb_topics' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
                select p.*, 
            'BBCode' as Format,
            from_unixtime(p.posted) as DateInserted,
            from_unixtime(p.edited) as DateUpdated, 
            eu.id as UpdateUserID
          from punbb_topics t
          join punbb_posts p
            on t.id = p.topic_id
          left join punbb_users eu
            on eu.username = p.edited_by
          where p.id <> t.first_post_id;Table 'ottens_co_uk.punbb_topics' doesn't exist
    Notice: Table 'ottens_co_uk.punbb_topics' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
    select * from oldlounge_tags;Table 'ottens_co_uk.oldlounge_tags' doesn't exist
    Notice: Table 'ottens_co_uk.oldlounge_tags' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
    select * from oldlounge_topic_tags;Table 'ottens_co_uk.oldlounge_topic_tags' doesn't exist
    Notice: Table 'ottens_co_uk.oldlounge_topic_tags' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
          select f.*,
             concat('FileUpload/', f.file_path) as Path,
             from_unixtime(f.uploaded_at) as DateInserted,
             case when post_id is null then 'Discussion' else 'Comment' end as ForeignTable,
             coalesce(post_id, topic_id) as ForieignID
          from oldlounge_attach_files f;Table 'ottens_co_uk.oldlounge_attach_files' doesn't exist
    Notice: Table 'ottens_co_uk.oldlounge_attach_files' doesn't exist in /customers/e/e/2/ottens.co.uk/httpd.www/lounge/vanilla2export.php on line 1293
    

    And:

    Exported Table: User (0 rows, 00:00.02)
    Exported Table: Role (6 rows, 00:00.01)
    Exported Table: Permission (0 rows, 00:00.64)
    Exported Table: UserRole (189 rows, 00:00.01)
    Exported Table: UserMeta (97 rows, 00:00.01)
    Exported Table: Category (0 rows, 00:00.02)
    Exported Table: Discussion (0 rows, 00:00.01)
    Exported Table: Comment (0 rows, 00:00.01)
    Exported Table: Tag (0 rows, 00:00.31)
    Exported Table: TagDiscussion (0 rows, 00:00.01)
    Exported Table: Media (0 rows, 00:00.01)
    

    What should I do?

  • Sorry, the code I posted was actually from before I tried emiluzelac's advice and renamed the prefix from "oldlounge" to "punbb" but the result is pretty much the same.

  • LincLinc Detroit Admin

    @Ottens Sounds like version differences we haven't accounted for yet. We've only had a few punBB runs to test it against and no one on the team knows its history.

  • Thanks for your reply @Lincoln. I have version 1.2.16, same as @fluchtweg. Is there anything I can change to the conversion script to make it work? Or update to a newer version of punBB? I'm not sure which one the converter is designed for.

  • LincLinc Detroit Admin

    Sure, you could do either. The source files are here: https://github.com/lincolnwebs/vanillaporter

    You can just drop all the files into your webroot (instead of the single vanilla2export.php) and edit the punBB class, then run it directly from index.php. If you fix it so that it works with the various versions (rather than hacking it so it just works with yours and breaks for others) a pull request would be appreciated (or paste your changes here and we'll fix it eventually).

  • @Lincoln, I wouldn't know exactly which changes to make though! It might be more practical to upgrade to the version of punBB that the converter was designed for. Do you know which that would be?

  • LincLinc Detroit Admin

    Not off the top of my head, no.

  • Does anyone else know? Or is there any way I can look it up?

  • edited October 2013

    [Split] Hi. Sorry for bumping as well. I have found solutions to this.
    Not all queries use the database prefix, there are some hardcoded punbb_ queries.
    Then I needed to modify some queries to add a few joins since first_post_id didn't exist in my DB.
    My export is ok now, but thu punbb passmord check fails in vanilla, since it's stored as sha1 without salt. Vanilla's CheckPassword function of class.passwordhass.php only accounts for md5 and sha1 + salt.
    Hope this helps, i'll make a diff of my changes to porter once I have everything working. Sadly I require a change to Vanilla, so I'll create another post for that.

  • LincLinc Detroit Admin
    edited December 2013

    I've fixed the hardcoded prefix in punbb for the Porter 1.9 release.

    I've fixed the sha1 hashing issue for Vanilla 2.1.

    I do not know how to resolve the first_post_id because I have no data for that.

Sign In or Register to comment.