[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
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

JHochstuhl,

The proper way to handle this is to "fix" the convertor and run the conversion again. I did discover this problem recently, but haven't had a chance to update the convertor files yet.

You could do a query on the database to fix those. Then you will have to reparse the post_texts.

Code: Select all

update phpbb_posts set post_text = replace(post_text, '[font="Comic Sans MS"]', '[font=Comic Sans MS]')
You would have to do this for every font style used and similarly for the size tags. There is proabley a way to do it with MySQL wildcards and regex, but I am not enough of a MySQL expert to know how to do this. In any case, after doing the queries, the text has to be reparsed which can be done with the Support Toolkit.

Another solution is to write a script to go through the posts_text, do the replacements and parse the text all in one go.
Have you hugged someone today?
User avatar
FaresNB
Registered User
Posts: 271
Joined: Tue May 22, 2007 11:50 am
Location: Syria
Name: Fares Alnaeb

Re: [Convertor] vBulletin 3.x to phpBB3

Post by FaresNB »

Hello

My vb database collation is : latin1_swedish_ci
And in the browser I find :

Code: Select all

<meta http-equiv="Content-Type" content="text/html; charset=windows-1256"
I tried to put it in the converter file to : windows-1256
But the result of the conversion was unreadable characters
I tried before to put it to : utf-8
and the result was the same, so what should I put or how to know ?

-URGENT-

Regards
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

If the board is Arabic
and the MySQL charset is UTF-8 Unicode (utf8)
and the MySQL connection collation is utf8_unicode_ci
and the table & field collation is set to latin1_swedish_ci
and the characters are stored in the database like

Code: Select all

ÇáÚÑÈíÉ
then windows-1251 should work.

An Arabic vBulletin board that I have, the table & field collation is set to latin1_general_ci. I don't know if that will make a difference.
Have you hugged someone today?
boyousif
Registered User
Posts: 3
Joined: Sun Sep 12, 2010 12:51 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by boyousif »

i have successfully convert my vb 3.8.1 to phpbb3

but i've this problem
can anybody help

thanks
You do not have the required permissions to view the files attached to this post.
JHochstuhl
Registered User
Posts: 119
Joined: Wed Dec 30, 2009 3:05 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by JHochstuhl »

Ok, mostly finished the conversion.

One side effect I just noticed.. As a result of the conversion for some reason, there were 3597 posts marked as "awaiting moderation". Why, I have no idea.

The moderator Control Panel is near useless for this quantity as it only allows the release of 5 at a time. Someone is gonna grow old releasing near 4000 of these suckers 5 at a time. LOL

Does anyone know how these posts can be released in mass?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

JHochstuhl,

I haven't run into this before, but this should work:
In the posts_table, set post_approved to 1.
In the topics_table, set topic_approved to 1 and set topic_replies_real = topic_replies.
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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

boyousif wrote:i have successfully convert my vb 3.8.1 to phpbb3

but i've this problem
can anybody help

thanks
boyousif,

Is it just the forum titles and descriptions? Is everything else okay, in viewforum and viewtopic?

I have run across this before and, unfortunately, I don't have a solution for you other than to edit the forum titles and descriptions in phpBB3.
Have you hugged someone today?
boyousif
Registered User
Posts: 3
Joined: Sun Sep 12, 2010 12:51 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by boyousif »

D¡cky wrote:
boyousif wrote:i have successfully convert my vb 3.8.1 to phpbb3

but i've this problem
can anybody help

thanks
boyousif,

Is it just the forum titles and descriptions? Is everything else okay, in viewforum and viewtopic?

I have run across this before and, unfortunately, I don't have a solution for you other than to edit the forum titles and descriptions in phpBB3.
Unfortunately, all the fourm is like this
forum titles, descriptions, viewforum and viewtopic.

I am very frustrated about this error as the utf-8 conversion should be part of the convertor :idea: .
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

boyousif wrote:Unfortunately, all the fourm is like this
forum titles, descriptions, viewforum and viewtopic.
For the topic titles, do this:

OPEN convert_vb30x.php
FIND

Code: Select all

array('topic_title',			'thread.title',				array('function1' => 'utf8_encode', 'function2' => 'phpbb_set_encoding')), //'utf8_htmlspecialchars'
REPLACE WITH

Code: Select all

array('topic_title',			'thread.title',				'phpbb_set_encoding'),
For the forum title and descriptions:
OPEN functions_vb30x.php
FIND

Code: Select all

				'forum_name'		=> phpbb_set_encoding($row1['title']),
				'parent_id'			=> (int) $row1['parentid'],
				'forum_parents'		=> '',
//				'forum_desc'		=> phpbb_set_encoding($row1['description']),
				'forum_desc'		=> htmlspecialchars(phpbb_set_default_encoding(htmlspecialchars_decode(html_entity_decode($row1['description']), ENT_QUOTES)), ENT_COMPAT, 'UTF-8'),
REPLACE WITH

Code: Select all

				'forum_name'		=> phpbb_set_encoding($row1['title']),
				'parent_id'			=> (int) $row1['parentid'],
				'forum_parents'		=> '',
				'forum_desc'		=> phpbb_set_encoding($row1['description']),
The above code appears in two places, so be sure to check both of them.
You want to ensure that forum_name and forum_desc use only the phpbb_set_encoding function.
Have you hugged someone today?
sabillondesigns
Registered User
Posts: 6
Joined: Mon Sep 20, 2010 2:10 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by sabillondesigns »

Hello, I'm trying to do the conversion of vbulletin to phpBB3 and I get this error while doing the conversion:

This webpage is not available.

The webpage at http://mzhonduras.com/phpBB3/install/in ... anguage=en might be temporarily down or it may have moved permanently to a new web address.

More information on this error
Below is the original error message

Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error.



any help please?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

sabillondesigns,

I have not seen that error before. It looks like it may be related to a server timeout. Try the following:

Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id: install_convert.php 9936 2009-08-07 12:50:25Z bantu $
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/
After add:

Code: Select all

@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');
Have you hugged someone today?
sabillondesigns
Registered User
Posts: 6
Joined: Mon Sep 20, 2010 2:10 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by sabillondesigns »

Hi Dicky,

I added the code like this:

Code: Select all

<?php
/**
*
* @package install
* @version $Id$
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
* @set_time_limit(0);
* @ini_set('memory_limit', '256M');
* @ini_set('upload_max_filesize', '128M');
* @ini_set('post_max_size', '256M');
* @ini_set('max_input_time', '-1');
* @ini_set('max_execution_time', '-1');
* @ini_set('expect.timeout', '-1');
* @ini_set('default_socket_timeout', '-1');
*/

/**
*/
Now when I go back and click on continue previosly started conversion I get this error:;

Code: Select all

General Error
SQL ERROR [ mysql4 ]

MySQL client ran out of memory [2008]

SQL

SELECT attachment.attachmentid, attachment.postid, post.threadid, attachment.userid AS poster_id, attachment.filedata, attachment.thumbnail, attachment.userid, attachment.filename, attachment.counter, attachment.filesize, attachment.dateline, attachment.thumbnail_filesize FROM attachment, post WHERE (post.postid = attachment.postid) ORDER BY attachment.attachmentid LIMIT 2000

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

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

FILE: install/install_convert.php
LINE: 1243
CALL: dbal_mysql->sql_query_limit()

FILE: install/install_convert.php
LINE: 213
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

Re: [Convertor] vBulletin 3.x to phpBB3

Post by D¡cky »

Evidently the MySQL server does not have enough memory to run the conversion. You can speak to your host to see if there is anything they can do to increase the memory allocation. Otherwise, you will have to do the conversion locally. Use EasyPHP, WampServer, or XAMPP.
Some helpful tips are in this Knowledge Base article, Offline Conversions
Have you hugged someone today?
sabillondesigns
Registered User
Posts: 6
Joined: Mon Sep 20, 2010 2:10 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by sabillondesigns »

I see. My host is GoDaddy, you havent heard about this issue before? I will need to contact them.

Thanks for the help.
sabillondesigns
Registered User
Posts: 6
Joined: Mon Sep 20, 2010 2:10 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by sabillondesigns »

D¡cky wrote:Evidently the MySQL server does not have enough memory to run the conversion. You can speak to your host to see if there is anything they can do to increase the memory allocation. Otherwise, you will have to do the conversion locally. Use EasyPHP, WampServer, or XAMPP.
Some helpful tips are in this Knowledge Base article, Offline Conversions
Hi dicky, is there a guide of converting vbulletin to phpbb3 offline. THe offline conversion you posted is from phpbb2 to phpbb3. Thanks!

Return to “[3.0.x] Convertors”