[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
Alagos
Registered User
Posts: 2
Joined: Sat Jul 07, 2012 3:32 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Alagos » Sun Jul 08, 2012 11:04 am

The value is ./uploads so I don't see where the problem is.
I look through my /uploads folder and found some .attach files. But looks like some are still missing. Is there any way around this problem?

I could live with some attachments missing, as long as I can switch from vbulletin to phpbb(I really, reall do hate vbulletin ;) )

Edit: I fixed it. Just dropped all files into the database and everything went fine. Thanks for your support anyways. <3 phpBB

Oh btw: I found a really, really small bug when you use german language. We got "Umlaute" (äöü) which sometimes don't seem to produce weired symbols when you convert them. You can just edit that post and everything is fine, but that might be something for a later patch of the converter.

Persia1
Registered User
Posts: 3
Joined: Sun Jan 01, 2012 10:13 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Persia1 » Sun Jul 08, 2012 12:00 pm

D¡cky wrote:
Persia1 wrote:Hello

i've problem in converting my vb to phpbb3

in step 3 ,i got this error
You either don't have any posts in the phpbb_posts table or there is a post that does not have a post time.
sorry , i'm new to phpbb

what should i do exactly?

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 » Sun Jul 08, 2012 5:34 pm

Persia1 wrote:what should i do exactly?
Using phpMyAdmin, look in the phpBB database at the phpbb_posts table. Is it populated? If not, that is the problem. If it is populated, run the following query:

Code: Select all

SELECT post_time FROM phpbb_posts ORDER BY post_id LIMIT 1
If phpbb_ is not your table prefix, replace with your table prefix.
A resulting post time should be displayed.

Executing SQL Queries in phpMyAdmin
Have you hugged someone today?

Persia1
Registered User
Posts: 3
Joined: Sun Jan 01, 2012 10:13 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Persia1 » Thu Jul 12, 2012 10:32 am

D¡cky wrote:
Persia1 wrote:what should i do exactly?
Using phpMyAdmin, look in the phpBB database at the phpbb_posts table. Is it populated? If not, that is the problem. If it is populated, run the following query:

Code: Select all

SELECT post_time FROM phpbb_posts ORDER BY post_id LIMIT 1
If phpbb_ is not your table prefix, replace with your table prefix.
A resulting post time should be displayed.

Executing SQL Queries in phpMyAdmin
thanks for directions, i'll try it :)

Firekissed
Registered User
Posts: 1
Joined: Mon Jul 23, 2012 9:39 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Firekissed » Mon Jul 23, 2012 9:45 am

I'd like to convert a forum Powered by vBulletin® Version 4.1.6 to the latest phpbb3 version.
The database is huge (here is the forum mmolazy.com/forum) I'd like to know if someone has successfuly use this converter on such a version cause I just can't do it.

* removed *
Last edited by marian0810 on Mon Jul 23, 2012 9:52 am, edited 1 time in total.
Reason: solicitation removed as per http://www.phpbb.com/rules/#rule1k

HATANO
Registered User
Posts: 8
Joined: Sat Jun 10, 2006 8:59 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by HATANO » Tue Sep 04, 2012 3:16 am

不好意思,因為我不會英文的關係,還請您讓我用中文來表達。(因為我得知您應該是中國人)
是這樣的,我目前正在將一個 vBulletin 3.8.2 轉換到 phpBB 3.0.11 上面,雖然轉換過程看似正常。
可是當完成作業時,在觀看主題列表的標題全部都是亂碼,在點選文章之後在文章內的標題卻正常。
請問這個該如何解決呢?

PS.我已經將 functions_vb30.php 的 $encoding = 'ISO-8859-1'; 改成 UTF-8 編碼了,請問該如何修正呢?

錯誤資料表:
phpbb_topics

錯誤欄位:
topic_title

正常欄位:
topic_last_post_subject

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 » Tue Sep 04, 2012 3:21 am

@HATANO,

English please.
Have you hugged someone today?

HATANO
Registered User
Posts: 8
Joined: Sat Jun 10, 2006 8:59 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by HATANO » Tue Sep 04, 2012 3:26 am

Sorry, but the problem has been resolved!

HATANO
Registered User
Posts: 8
Joined: Sat Jun 10, 2006 8:59 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by HATANO » Tue Sep 04, 2012 11:17 am

I am sorry!
while I have to modify the file, in accordance with the teaching!
but the title is not input text contains single quotes, if the input becomes blank, ask how to solve it?

Our website:
http://forum.wdo.tw/viewforum.php?f=11

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

Post by D¡cky » Tue Sep 04, 2012 1:03 pm

HATANO wrote:I am sorry!
while I have to modify the file, in accordance with the teaching!
but the title is not input text contains single quotes, if the input becomes blank, ask how to solve it?
If it is just a few topics, I would edit the first post in the topic to correct the title.

You can also try this with phpMyAdmin:

Code: Select all

UPDATE phpbb_topics t SET topic_title=(SELECT title FROM thread p WHERE p.threadid=t.topic_id GROUP BY topic_id)
You will need to adjust the table prefixes to match your database.
Have you hugged someone today?

HATANO
Registered User
Posts: 8
Joined: Sat Jun 10, 2006 8:59 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by HATANO » Tue Sep 04, 2012 4:11 pm

Thanks for your reply!
Therefore, by the vBulletin 3.x to phpBB3 Convertors
The conversion of the system can not be directly input any single quote character on it?
New topic can not enter the single quote character, and I ask this question?

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 » Tue Sep 04, 2012 5:20 pm

Yes, you can have single quotes in a topic title.

If the convertor cannot handle the encoding in a topic, it will result in a blank topic title. You can modify the convertor to change the way it converts topic titles. See:
viewtopic.php?f=65&t=1722325&p=12862449#p12862449
viewtopic.php?f=65&t=1722325&p=12796126#p12796126
viewtopic.php?f=65&t=1722325&p=12488965#p12488965
Have you hugged someone today?

HATANO
Registered User
Posts: 8
Joined: Sat Jun 10, 2006 8:59 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by HATANO » Tue Sep 04, 2012 8:20 pm

I have to be modified in accordance with the above steps, just Although most of the headlines, but the characters that contains single quotes, the topic title is still blank ...

Evidently single quote character or can not be properly interpreted, I can only give up!

Taiwan side will use the English title anyway not many opportunities, only to give up!

But rather double quotation marks are actually able to use HTML code correct interpretation storage,so I was quite surprised!

Anyway thanks your reply, this is a good conversion tool, you worked hard!

cerberos
Registered User
Posts: 9
Joined: Tue Dec 23, 2008 6:53 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by cerberos » Fri Sep 07, 2012 11:33 pm

Hello, is that possible with Vb4 as well?

I tried to run it but i have an error i cant really understand what's the problem. My old forum is vbulletin 4.1.1

The error i face:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'userfield.field2' in 'field list' [1054]

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 ((vb4user user LEFT JOIN vb4userfield AS userfield ON user.userid = userfield.userid) LEFT JOIN vb4usertextfield AS usertextfield on user.userid=usertextfield.userid) LEFT JOIN vb4avatar AS avatar on user.avatarid=avatar.avatarid WHERE (user.userid <> -1) ORDER BY user.userid LIMIT 2000

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

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

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

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

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

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

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()
Hope someone can help!

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 » Sat Sep 08, 2012 2:34 am

cerberos wrote:Hello, is that possible with Vb4 as well?

I tried to run it but i have an error i cant really understand what's the problem. My old forum is vbulletin 4.1.1

The error i face:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'userfield.field2' in 'field list' [1054]
Hope someone can help!
In vBulletin, userfields can be changed. Many boards use 'userfield.field2' for a member's location, but if you no longer have the field, it can be removed from the convertor.

OPEN install/convertors/convert_vb30.php
FIND

Code: Select all

				array('user_from',				'userfield.field2',			array('function1' => 'vb_set_encoding')),
REPLACE WITH

Code: Select all

//				array('user_from',				'userfield.field2',			array('function1' => 'vb_set_encoding')),
And just to be sure, you should be using the vBulletin 4 convertor.
Have you hugged someone today?

Locked

Return to “[3.0.x] Convertors”