IPB 3.4.5 to Vanilla 2.1 - No Posts

cytrax

Hello,

I am in the process of moving from IPB 3.4.5 to Vanilla 2.1. I ran through the process and everything appeared fine until I ran across an error that is preventing me from exporting Posts:

select t.*, case when t.description <> '' and p.post is not null then concat('<div class="IPBDescription">', t.description, '</div>', p.post) when t.description <> '' then t.description else p.post end as post, case when t.state = 'closed' then 1 else 0 end as closed, 'IPB' as Format, p.ip_address, p.edit_time , from_unixtime(start_date) as start_date_Date, from_unixtime(edit_time) as edit_time_Date from topics t left join posts p on t.topic_firstpost = p.pid where t.tid between -2000000000 and 2000000000;Unknown column 't.description' in 'field list'

Notice: Unknown column 't.description' in 'field list' in /home/mortal7/public_html/365players.com/forums/export/vanilla2export.php on line 1308

Has anyone seen this before?

UnderDog

It's strange, but in your IPB database there's no column 'description' in your 'topics' table. Open your database with phpMyAdmin and doublecheck

cytrax

@UnderDog said:
It's strange, but in your IPB database there's no column 'description' in your 'topics' table. Open your database with phpMyAdmin and doublecheck

Thank you for responding, UnderDog.

That's the weird thing. I don't actually have "Topics" table in my database. I have 'posts' though so I'm thinking of adding a new column called description to see if that fools the porter.

---Edit---
't.description' - This is referring to a table that I can't find. Something strange here...

cytrax

That didn't work. So obviously problem is with 't.description' - This is referring to a table that doesn't exit in IPB 3.4.5.

hgtonight

Welcome to the community!

I assume your IPB install is functional at the moment?

cytrax

@hgtonight said:
Welcome to the community!

I assume your IPB install is functional at the moment?

Thank you.

Yes, the IPB install is definitely fully functional.

hgtonight

Could you share the database table schema for your IPB board?

If you don't know what that is, I would like the output of the mysqldump database_name --compact --no-data command.

cytrax

@hgtonight said:
Could you share the database table schema for your IPB board?

If you don't know what that is, I would like the output of the mysqldump database_name --compact --no-data command.

Here it is, sir: http://pastebin.com/zUqet95T

hgtonight

Looks like they changed the db structure for that version.

The IPB class will prolly need to be tweaked.

cytrax

@hgtonight said:
Looks like they changed the db structure for that version.

The IPB class will prolly need to be tweaked.

MAAN! That was what I feared had happened. Thank you for confirming that.

I guess now I need to move resolution phase. whew!

Simeon_Griggs

Did this ever get fixed? I'm getting the same error right now.

Linc

Looks like IPB optimized their database by moving the description field from the topics table to the posts table. I'm rolling a patch.

Linc

Try this: http://vanillaforums.org/addon/porter-core-2.1.1

Linc

@cytrax Thanks for the database structure dump! Wouldn't have been able to puzzle it out otherwise.

Simeon_Griggs

Thanks for the new version, but I'm still getting the same error...

http://pastebin.com/F3U1C0ta

Linc

Alright, how about this: http://vanillaforums.org/addon/porter-core-2.1.2

Simeon_Griggs

It works! Awesome.

Simeon_Griggs

Notes:

• Profile photos didn't come across but that's okay I did them manually
• No formatting or tags came across from quotes, so quoted posts just look like one long body of a post
• HTML entities are messed up, for example: I & # 3 9 ; m just (but without spaces)

Linc

Adding ?avatars=1 to the porter script URL before doing the export should dump avatars as well. I'm not too familiar with the ins and outs for IPB, but there's definitely code in there to handle it.

The porter looks like it is screwing up the format and Vanilla is sending your posts to plain text as a result. What does IPB use for formatting, BBCode? If so, try running these two queries on the new Vanilla database:

update GDN_Discussion set Format = 'BBCode';
update GDN_Comment set Format = 'BBCode';

Then grab & enable the NBBC addon from the addon directory.

This should also fix the HTML entities, I suspect.

Linc

I've pushed the BBCode fix to GitHub, now.

Simeon_Griggs

Awesome thanks, testing now.

BTW I ran make.php and the vanilla2export.php it created had an error. There's an errant letter 'x' on line 4003.