[SUPPORT] PunBB to phpBB convertor

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
nanowish
Registered User
Posts: 3
Joined: Wed Apr 05, 2006 1:19 pm

Post by nanowish »

Hi,

I tried to convert my punbb to php and when convret Posts table I have this error.

Code: Select all

Couldn't insert post
1366: Incorrect integer value: '' for column 'forum_id' at row 1

INSERT INTO phpbb_posts (post_id,topic_id,forum_id,poster_id,post_time,poster_ip,post_username,enable_bbcode,enable_html,enable_smilies,enable_sig,post_edit_time,post_edit_count)
				VALUES (715, '247', '', '302', '1142760270','52403426', 'Sarviide','1','0','1','1', '1142760332', '1')
and this for all posts.

Any ideas?
Thanks.

(sorry for my english)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

OPEN conv_posts.php for editing.

FIND this line

Code: Select all

VALUES (" . $pid . ", '" . $topic_id . "', '" . $forum_id . "', '" . $author_id . "', '" . $post_date . "','" . $ip_addy . "', '" . $user_name . "','1','0','1','1', '" . $edit_time . "', '" . $edit_count . "')";
REPLACE WITH

Code: Select all

VALUES (" . $pid . ", '" . $topic_id . "', '0', '" . $author_id . "', '" . $post_date . "','" . $ip_addy . "', '" . $user_name . "','1','0','1','1', '" . $edit_time . "', '" . $edit_count . "')";
SAVE and run the convertor again.

You must be running MySQL 5.x and it doesn't like that the forum_id is blank, so we put a zero in there. The fourm_id will get filled in later.
Have you hugged someone today?
nanowish
Registered User
Posts: 3
Joined: Wed Apr 05, 2006 1:19 pm

Post by nanowish »

thank you for your very fast answer! Now I have this message

Code: Select all

Couldn't insert post
1264: Out of range value adjusted for column 'post_edit_time' at row 1

INSERT INTO phpbb_posts (post_id,topic_id,forum_id,poster_id,post_time,poster_ip,post_username,enable_bbcode,enable_html,enable_smilies,enable_sig,post_edit_time,post_edit_count)
            VALUES (3, '175', '0', '294', '1142761297','53caf294', 'Nessa','1','0','1','1', '', '0')

For all post without Edit.

I use mysql 5 ^-^

[edit]This error appears with Strict Mode actived in mysql options.
Last edited by nanowish on Wed Apr 05, 2006 3:58 pm, edited 1 time in total.
nanowish
Registered User
Posts: 3
Joined: Wed Apr 05, 2006 1:19 pm

Post by nanowish »

EDIT: sorry i'ts my fault

Working yet now! very thanks for this script :)
silent1643
Registered User
Posts: 44
Joined: Wed Jun 07, 2006 1:38 pm

does this work with?

Post by silent1643 »

does this work with punbb 1.2.10?
thanks
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: does this work with?

Post by D¡cky »

silent1643 wrote: does this work with punbb 1.2.10?

I believe it does. Use the link in the first post for the punbb 1.2 series.
Have you hugged someone today?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: does this work with?

Post by D¡cky »

silent1643 wrote: does this work with punbb 1.2.10?

I believe it does. Use the link in the first post for the punbb 1.2 series.
Have you hugged someone today?
bartolli
Registered User
Posts: 9
Joined: Fri Jun 09, 2006 2:50 pm

Beta 0.1.2?

Post by bartolli »

D¡cky wrote: Download link is in the first post. Beta 0.1.2

Where i can find this 0.1.2 version? In the first post is missing.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Beta 0.1.2?

Post by D¡cky »

bartolli wrote:
D¡cky wrote:Download link is in the first post. Beta 0.1.2

Where i can find this 0.1.2 version? In the first post is missing.

The link in the first post will always bring you to the latest version.
Have you hugged someone today?
bartolli
Registered User
Posts: 9
Joined: Fri Jun 09, 2006 2:50 pm

Re: Beta 0.1.2?

Post by bartolli »

D¡cky wrote:
bartolli wrote:
D¡cky wrote:Download link is in the first post. Beta 0.1.2

Where i can find this 0.1.2 version? In the first post is missing.

The link in the first post will always bring you to the latest version.

Thank you! I converted with success 64 MB forum database with over 208322 postings :) I have problems only with passwords, but i read about it. Users must use password re-send system. Thak for great convertor.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Beta 0.1.2?

Post by D¡cky »

bartolli wrote: Thank you! I converted with success 64 MB forum database with over 208322 postings :) I have problems only with passwords, but i read about it. Users must use password re-send system. Thak for great convertor.

You're welcome. I believe included with the convertor are instructions on how to make the passwords work.
Have you hugged someone today?
marcus1060
Registered User
Posts: 18
Joined: Mon Feb 16, 2004 5:05 am

Post by marcus1060 »

Because punBB allows for longer topic subjects, they will cause errors if the title is longer then phpBB's limit of 60.
This is fixed by trimming down subjects.

In conv_topis.php add

Code: Select all

				if(strlen($subject) > 60) {
					$subject = substr_replace($subject, "...", 60 - 3);
				}
Below:

Code: Select all

				$subject = str_replace( "<"    ,"<" , $subject ); 
				$subject = str_replace( ">"    ,">" , $subject ); 
				$subject = str_replace( """  ,"\"", $subject ); 
				$subject = str_replace( "'"  ,"'" , $subject ); 
				$subject = str_replace( "&"   ,"&" , $subject ); 
				$subject = str_replace( "!"  ,"!" , $subject ); 
				$subject = str_replace( "|"  ,"|" , $subject ); 
 
				$subject = addslashes($subject);
killerpistol
Registered User
Posts: 1
Joined: Sun Aug 27, 2006 1:16 pm

Lost

Post by killerpistol »

how do you do this i'm not the host, i have a remote webhost with Cpanel for linux. How am i do these things?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Post by D¡cky »

You don't have to be the host. You can install phpBB on your server that has the PunBB install and upload the convertor files to your phpBB installation and run the convertor.

Or you can setup a server on your own computer with a package like easyPHP and do the conversion locally.
Have you hugged someone today?
lemonrock
Registered User
Posts: 2
Joined: Mon Jan 08, 2007 11:28 pm

Re: [SUPPORT] PunBB to phpBB convertor

Post by lemonrock »

D¡cky wrote: I have made available a convertor for PunBB 1.1.x and 1.2.x to phpBB.


Successfully converted from PunBB 1.2.14 to phpBB 2.0.22. We will get each user to re-request their password.

A breeze to use. Thanks!

http://www.lemonrock.com/forum
Locked

Return to “[2.0.x] Convertors”