[Convertor] vBulletin 3.x to phpBB3

[Alagos]

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]

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?

[D¡cky]

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

[Persia1]

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]

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 *

[HATANO]

不好意思，因為我不會英文的關係，還請您讓我用中文來表達。（因為我得知您應該是中國人）
是這樣的，我目前正在將一個 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

[D¡cky]

@HATANO,

English please.

[HATANO]

Sorry, but the problem has been resolved!

[HATANO]

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!

[D¡cky]

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.

[HATANO]

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?

[D¡cky]

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

[HATANO]

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]

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!

[D¡cky]

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.