Icy Phoenix

Old Support Topics - Phpbb2s Post To Running Ip

Rene [ Wed 28 Nov, 2007 12:19 ]
Post subject: Phpbb2s Post To Running Ip

Hi,

I refer to this post: http://www.icyphoenix.com/viewtopic.php?f=2&t=2804&p=19690

For me its the same, I have a working phpbb2 witch is used by some users and I've got a working IP for testing.

Now I want to transfer all posts of the working phpbb2 to the new IP Portal.

I can't copy the hole database tables of the phpbb2 to the IP Installation because there're many changes on the database, see for example the forum table.

novice programmer [ Wed 28 Nov, 2007 18:33 ]
Post subject: Re: Phpbb2s Post To Running Ip

You can copy it.

There is no problem, as the non-value fields will take the default values.

Rene [ Wed 28 Nov, 2007 19:47 ]
Post subject: Re: Phpbb2s Post To Running Ip

novice programmer wrote: [View Post]
You can copy it.

There is no problem, as the non-value fields will take the default values.

So I only have to use the insert statements to update right? Because my actual backup contains "drop table if exists" statements, so the tables will be created new.

Rene [ Sun 02 Dec, 2007 14:16 ]
Post subject: Re: Phpbb2s Post To Running Ip

Novice can you explain it in more detail please? Many tables of IP have a other structure (more fields) than the tables in phpbb2. So a backup would set all tables to the phpbb2 structure.

novice programmer [ Sun 02 Dec, 2007 20:52 ]
Post subject: Re: Phpbb2s Post To Running Ip

Rene wrote: [View Post]
Novice can you explain it in more detail please? Many tables of IP have a other structure (more fields) than the tables in phpbb2. So a backup would set all tables to the phpbb2 structure.

Delete the instrucitons:

Code: [Hide] [Select]

DROP*

DELETE*

CREATE*

ADD*

ALTER*

to get only the insert lines

As in the other thread, make sure the prefixes are the same.

Stickygreen [ Wed 02 Jan, 2008 19:06 ]
Post subject: Re: Phpbb2s Post To Running Ip

It doesn't work that easily I'm afraid. Just so no one get's the wrong idea this method doesn't work.

You will get this error:

#1136 - Column count doesn't match value count at row 1

I'll have to modify the script that mighty has in the contrib folder just to convert forums, users, and posts over.

If I have any luck I'll attach it here.