[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.
Scam Warning
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 »

kevin_lee wrote:Why vBulletin 3.x convert into phpBB? is there any error which can't solve using vBulletin?
This is not the place to discuss vBulletin vs. phpBB. People each have their own personal reasons for using one over the other. We are not here to judge those reasons. Any further discussion on this matter will be deleted.
Have you hugged someone today?
User avatar
nextgen
Registered User
Posts: 2395
Joined: Mon Jul 26, 2010 10:58 pm
Location: Guatemala
Name: Melvin García

Re: [Convertor] vBulletin 3.x to phpBB3

Post by nextgen »

the conversion was successful but user passwords does not recognize. :?
メルビン・ガルシア • nextgen SolutionsDDAnimeXenForo Hispano

Please do NOT contact for support via PM or email.
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 »

nextgengt wrote:the conversion was successful but user passwords does not recognize. :?
What is the error message when attempting to login?

You can try the attached auth_vb3.php. Unzip and upload to your phpBB3 includes/auth folder.
You do not have the required permissions to view the files attached to this post.
Have you hugged someone today?
User avatar
nextgen
Registered User
Posts: 2395
Joined: Mon Jul 26, 2010 10:58 pm
Location: Guatemala
Name: Melvin García

Re: [Convertor] vBulletin 3.x to phpBB3

Post by nextgen »

still does not recognize the password, the message that tells me is that the password is incorrect.

I have the version: 3.8.6 from vBulletin.
メルビン・ガルシア • nextgen SolutionsDDAnimeXenForo Hispano

Please do NOT contact for support via PM or email.
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 »

"the password is incorrect" message means that the password has already been converted and that the incorrect password is being entered or for some reason, the password is not being identified as needing to be converted.

Look in the database at the phpbb_users table and find that user.
What is the user_pass_convert field set to?
What does the user_password field look like. Does the password start with $H$ and is a mixture of upper & lower case letters and numbers and, possibly, symbols or is it a 32 character string with a mixture of lower case letters and numbers.
Have you hugged someone today?
User avatar
nextgen
Registered User
Posts: 2395
Joined: Mon Jul 26, 2010 10:58 pm
Location: Guatemala
Name: Melvin García

Re: [Convertor] vBulletin 3.x to phpBB3

Post by nextgen »

the password is the password because restoration through the mail recovery

$H$95YaeGIcOhdeVSx36X4tI1lIRrFqeM1

but other users have something

28df082c61468427a8919bb59d2bf0b4
メルビン・ガルシア • nextgen SolutionsDDAnimeXenForo Hispano

Please do NOT contact for support via PM or email.
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 »

nextgengt wrote:the password is the password because restoration through the mail recovery

$H$95YaeGIcOhdeVSx36X4tI1lIRrFqeM1
This is the phpBB3 password format. This user is able to log in or not? When receiving a new password by email, the link in the email has to be used in order to log in for the first time.
nextgengt wrote:but other users have something

28df082c61468427a8919bb59d2bf0b4
This is the vBulletin password format and it needs to be converted. Is there an entry in the user_passwd_salt field?
What is the user_pass_convert field set to?
This user should not be getting the "password is incorrect" message if the password is not a match. They should be getting a different message if the password is not a match.
Have you hugged someone today?
User avatar
nextgen
Registered User
Posts: 2395
Joined: Mon Jul 26, 2010 10:58 pm
Location: Guatemala
Name: Melvin García

Re: [Convertor] vBulletin 3.x to phpBB3

Post by nextgen »

D¡cky wrote:This is the phpBB3 password format. This user is able to log in or not? When receiving a new password by email, the link in the email has to be used in order to log in for the first time.
so, the user can pay regularly to reset your password
D¡cky wrote:This is the vBulletin password format and it needs to be converted. Is there an entry in the user_passwd_salt field?
What is the user_pass_convert field set to?
This user should not be getting the "password is incorrect" message if the password is not a match. They should be getting a different message if the password is not a match.
look this table phpbb_users

Regards and Thank's Dicky for you attention. :)
Edit:
Last edited by nextgen on Wed Jan 05, 2011 8:47 pm, edited 2 times in total.
メルビン・ガルシア • nextgen SolutionsDDAnimeXenForo Hispano

Please do NOT contact for support via PM or email.
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 »

nextgengt wrote:
D¡cky wrote:This is the phpBB3 password format. This user is able to log in or not? When receiving a new password by email, the link in the email has to be used in order to log in for the first time.
so, the user can pay regularly to reset your password
i don't understand what you wrote. One user cannot reset another user's password, if that is what you mean.
D¡cky wrote:This is the vBulletin password format and it needs to be converted. Is there an entry in the user_passwd_salt field?
What is the user_pass_convert field set to?
This user should not be getting the "password is incorrect" message if the password is not a match. They should be getting a different message if the password is not a match.
look this table phpbb_users

Regards and Thank's Dicky for you attention. :)[/quote]
Do you know somebody's password that cannot log in? PM it to me if you do.

I am deleting your attachment so your users' information doesn't get out in the wild.
Have you hugged someone today?
User avatar
nextgen
Registered User
Posts: 2395
Joined: Mon Jul 26, 2010 10:58 pm
Location: Guatemala
Name: Melvin García

Re: [Convertor] vBulletin 3.x to phpBB3

Post by nextgen »

mp sent with user data.
メルビン・ガルシア • nextgen SolutionsDDAnimeXenForo Hispano

Please do NOT contact for support via PM or email.
marin
Registered User
Posts: 4
Joined: Wed Dec 29, 2010 8:21 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by marin »

do you have an update for convert a vb4 ?
i have this error message:
[

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

Unknown column 'attachment.postid' in 'field list' [1054]

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 vbulletin_attachment attachment, vbulletin_post post WHERE (post.postid = attachment.postid) ORDER BY attachment.attachmentid LIMIT 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()
with kregs
Maher
Registered User
Posts: 2
Joined: Wed Jan 12, 2011 9:29 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Maher »

Hello, and thanks for your support.
I've successfully converted from vbulletin 3.8.4 into phpBB 3.0.8.
But I still have a little problem, which I couldn't resolve.
The problem is that topic titles are not shown properly! They are like أƒآŒ أƒآ‡أƒآ،أƒآ¤أƒآ¥أƒآ‡أƒآ†أƒآ­أƒآ‰
Where everything else in the forum is diplayed properly in Arabic.
I've changed collation for every single table in vbulletin into utf8_bin before converting.
So I don't know whats the problem! Help would be much appreciated.

Link to forum: http://www.ibinnish.com/forum

Thank you again.
Maher
Registered User
Posts: 2
Joined: Wed Jan 12, 2011 9:29 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Maher »

Maher wrote:Hello, and thanks for your support.
I've successfully converted from vbulletin 3.8.4 into phpBB 3.0.8.
But I still have a little problem, which I couldn't resolve.
The problem is that topic titles are not shown properly! They are like أƒآŒ أƒآ‡أƒآ،أƒآ¤أƒآ¥أƒآ‡أƒآ†أƒآ­أƒآ‰
Where everything else in the forum is diplayed properly in Arabic.
I've changed collation for every single table in vbulletin into utf8_bin before converting.
So I don't know whats the problem! Help would be much appreciated.

Link to forum: http://www.ibinnish.com/forum

Thank you again.
Problem solved.
Someone told me to update the topic titles from the title of the first post of every topic.

Code: Select all

update phpbb_topics t set topic_title=(select post_subject from phpbb_posts p where p.topic_id=t.topic_id group by topic_id)
Works like a charm ;)
itsmefahad
Registered User
Posts: 5
Joined: Tue Oct 13, 2009 11:16 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by itsmefahad »

I convert from vb to phpbb 3.0 7 steps complete, the time of private msgs move to phpbb it shows errors and i restart conversion i try more than 4 times but still the same.
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 »

itsmefahad wrote:I convert from vb to phpbb 3.0 7 steps complete, the time of private msgs move to phpbb it shows errors and i restart conversion i try more than 4 times but still the same.
I can't help unless I know what the error is. The more information you can give, the easier it is to help.

Is the error when you are converting?
Is the error after the conversion and when you are viewing phpBB Private Messages?
Have you hugged someone today?

Return to “[3.0.x] Convertors”