punbb 1.2.16 to vanilla

fluchtweg

This discussion is related to the Vanilla Porter addon.

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

Lincoln

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.

nahana

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.

UnderDog

@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

emiluzelac

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

emiluzelac

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.

emiluzelac

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

nahana

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.

nahana

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 `

nahana

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

Lincoln

@emiluzelac Thanks for the heads up.