[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 » Wed Apr 05, 2006 1:23 pm

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 » Wed Apr 05, 2006 1:59 pm

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 » Wed Apr 05, 2006 2:47 pm

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 » Wed Apr 05, 2006 3:57 pm

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 » Wed Jun 07, 2006 1:40 pm

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 » Wed Jun 07, 2006 8:24 pm

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 » Wed Jun 07, 2006 8:35 pm

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 » Fri Jun 09, 2006 3:08 pm

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 » Fri Jun 09, 2006 8:28 pm

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 » Sat Jun 10, 2006 9:26 am

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 » Sat Jun 10, 2006 1:50 pm

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 » Thu Jul 06, 2006 4:40 am

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 » Sun Aug 27, 2006 1:19 pm

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 » Sun Aug 27, 2006 2:51 pm

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 » Mon Jan 08, 2007 11:59 pm

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”

Who is online

Users browsing this forum: No registered users and 5 guests