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
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
0
Answers
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.
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"
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_forumsand 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
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
@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 1293And:
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.
@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.
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?
Not off the top of my head, no.
Does anyone else know? Or is there any way I can look it up?
[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.
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.