[Convertor] vBulletin 3.x to phpBB3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Anti-Spam Guide
Locked
itsmefahad
Registered User
Posts: 5
Joined: Tue Oct 13, 2009 11:16 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by itsmefahad »

Mention below msg i copy from conversion page, after this message page close & problem loading page error shows.


----------------------
Installation Panel

Skip to content

* Overview
* Convert

* Introduction
* Settings
* Conversion in progress
* Final stage

Filling tables

Filling table phpbb_privmsgs:

skip_rows = 6166:

skip_rows = 8166:
186 rows/s (2000 rows) |

skip_rows = 10166:
175 rows/s (2000 rows) |

skip_rows = 12166:
167 rows/s (2000 rows) |

skip_rows = 14166:
168 rows/s (2000 rows) |

Step 8 of 16
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

If the convertor always stops at the same place, then you probably have a very long private message or a private message with a long unbroken string of characters or smilies.

Look in the phpBB3 priv_msgs table and see what the last message is. Then look in the vBulletin pmtext table after the last message that was inserted in phpBB3 and see if you can spot something out of the ordinary.
Have you hugged someone today?
itsmefahad
Registered User
Posts: 5
Joined: Tue Oct 13, 2009 11:16 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by itsmefahad »

Any way to i discard all of pvt msgs?
Vashidu
Registered User
Posts: 1
Joined: Fri Jan 21, 2011 2:04 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Vashidu »

i have a error, please help me

Code: Select all

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where config_name="board_startdate"' at line 1 [1064]

SQL

update phpbb_config set config_value= where config_name="board_startdate"

BACKTRACE


FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 66
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: install/install_convert.php
LINE: 1654
CALL: eval()

FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 409
CALL: install_convert->main()

FILE: install/index.php
LINE: 286
CALL: module->load()



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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Vashidu wrote:i have a error, please help me
The board start date is taken from the oldest post that was converted to phpBB3. Either your vBulletin posts did not get converted to phpBB3 or the oldest post does not have a post time. Look at the phpbb posts table to see what is going on.
Have you hugged someone today?
killer1993
Registered User
Posts: 3
Joined: Thu Jun 19, 2008 3:26 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by killer1993 »

I tried to convert vBulletin 4.0.7 to phpBB 3.0.8, but the results turned out quite grusome.
First of all, I was spammed with about 4,000 e-mails about failed deliveries.
Next, all e-mails except for mine, were changed to random AOL e-mails.

And, in addition to that, the board refuses to send me a reset password.

I might need a bit of assistance here.
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

To convert vBulletin 4, use the file in this post in addition to the vBulletin 3 convertor files.
Have you hugged someone today?
mhorpheox
Registered User
Posts: 1
Joined: Thu Feb 03, 2011 2:14 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by mhorpheox »

hello i'm converting vbulletin 3.82 to phpbb 3.08 but at step 7 of 16 i have this error:

Code: Select all

SQL ERROR [ mysqli ]

Error writing file '/tmp/MYWwp0nW' (Errcode: 28) [3]

SQL

SELECT user.userid, user.userid AS poster_id, user.usergroupid, user.ipaddress, user.salt, user.joindate, user.username, user.password, user.posts, user.email, user.birthday, user.lastvisit, user.lastactivity, user.timezoneoffset, userfield.field2, userfield.field3, userfield.field4, user.homepage, user.msn, user.yahoo, user.aim, user.icq, user.customtitle, avatar.avatarpath, user.pmunread, user.emailstamp, user.autosubscribe, usertextfield.signature, user.joindate AS post_time FROM ((user LEFT JOIN userfield ON user.userid = userfield.userid) LEFT JOIN usertextfield on user.userid=usertextfield.userid) LEFT JOIN avatar on user.avatarid=avatar.avatarid WHERE (user.userid <> -1) ORDER BY user.userid LIMIT 10994, 2000

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 409
CALL: install_convert->main()

FILE: install/index.php
LINE: 286
CALL: module->load()
Can you help me?
thank u
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

That is a temporary file for the MySQL server. You will need to contact your hosting provider to find why that file is unavailable. It may be that the server became overloaded at that step. If that is the case, restarting the convertor may allow you to continue after the server has settled down. Go to install/index.php and click the convert tab. You will be presented with a "Continue previously started conversion." Clicking this button will start the conversion where it left off and continue on.
Have you hugged someone today?
mario_7
Registered User
Posts: 14
Joined: Wed Mar 23, 2011 12:06 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by mario_7 »

Hi.

First of all - thank you for this convertor. :)

I'd like to share with you fixes and improvements that I developed while converting Polish Ubuntu Linux Forum from vBulletin 3.8.4 to phpBB3.

Fixed:
  • converting form UTF-8 vb3 to UTF-8 phpBB3 (not tested with any other setup)
  • Private Messages IDs (wrong field was considered as PM ID)
  • PMs recipients in Sent folder (all were set to Anonymous)
  • BBCodes conversion (it wasn't covering all cases)
  • convert_zebra function (few details were preventing this function from working at all)
  • importing ranks (even with some kind of special ranks support)
  • updated auth_vb3.php file with code from recent auth_db.php file (the part with anti-bot question which was not working properly)
New features:
  • importing censor (words and usernames)
  • cleaning code tags (vb3 parses other BBCodes inside code tags, phpBB3 does not do this)
  • importing maxonline and maxonlinedate data
  • importing custom user profile fields (or at least example how to do this ;))
  • converting old vb3 style URLs to new phpBB3 style URLs inside posts
  • vb3 characteristic php files that act as redirects to appropriate phpBB3 files
Details about all changes in comments inside php files.

I'm attaching exact script i used to convert forum, so you will probably want to extract universal parts from it.

Hope you will find my code useful.

P.S.
The proof that forum is actually working after conversion: http://ubuntu.pl/forum/ ;)
Attachments
vb3x_to_phpBB3.tar.bz2
(30.26 KiB) Downloaded 102 times
Souljacker
Registered User
Posts: 9
Joined: Wed May 12, 2004 12:22 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Souljacker »

Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?
User avatar
jemiesranova
Registered User
Posts: 19
Joined: Fri Mar 25, 2011 6:44 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by jemiesranova »

Souljacker wrote:Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?
you can try using the format "link" [L] [/ L] or by opening the HTML tips on the forum.
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Souljacker wrote:Hi guys

My old install is at [site]/forum
PHPBB3 is at [site]/f

I've put ../forum at Board path:

but i get this error

Could not find path to your former board. Please check your settings and try again.
» ../forum was specified as the source path.

Can someone help me?
../forum should be the correct path.

Are both boards in the same domain?
The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.
Does the file showthread.php exist in the vBulletin root directory?
Have you hugged someone today?
mario_7
Registered User
Posts: 14
Joined: Wed Mar 23, 2011 12:06 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by mario_7 »

D¡cky wrote:The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.
Isn't it just needed that files and database are on the same server?
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: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

mario_7 wrote:
D¡cky wrote:The convertor will not work across subdomains. If a subdomain in being used, both boards have to be in the same subdomain.
Isn't it just needed that files and database are on the same server?
No, they have to be in the same domain or the same subdomain. Relative paths will not work across different domains or different subdomains.
Have you hugged someone today?
Locked

Return to “[3.0.x] Convertors”