[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
Locked
Trokanda
Registered User
Posts: 2
Joined: Fri Dec 04, 2009 9:20 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Trokanda »

no matter, got it sorted. 'ADD user_passwd_salt varchar(5) COLLATE utf8_bin NOT NULL DEFAULT' apparently doesn t work on MySQL 4.0.

in "functions_vb30" 'user_passwd_salt' gets 1st deleted and then the converter tries to add a new entry by
$create_sql = 'ALTER TABLE ' . USERS_TABLE . ' ADD user_passwd_salt VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT \'\' NOT NULL';
which is not working with my mySQL 4.0.
I changed the line to
$create_sql = 'ALTER TABLE ' . USERS_TABLE . ' ADD `user_passwd_salt` VARCHAR( 5 ) NOT NULL';
and the convertion worked without giving errors. Unfortunately did it not convert the passwords tho which isn t a big issue as I just send a mail to all Users that they have to restore their password on next login.
ferret141
Registered User
Posts: 2
Joined: Sun Dec 06, 2009 7:29 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by ferret141 »

If the ISO standard hasn't been set correctly. What will happen?
mooshotty
Registered User
Posts: 3
Joined: Sat Oct 04, 2008 5:18 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by mooshotty »

i am having a problem and i am hoping you can help.

the VB site is on a different hosting account. i have the database uploaded to the same accounts as the phpbb board.

am i able to make this work?
User avatar
imkingdavid
Former Team Member
Posts: 2673
Joined: Sun Jul 26, 2009 7:59 pm
Location: EST
Name: David King

Re: [Convertor] vBulletin 3.x to phpBB3

Post by imkingdavid »

Hey I just converted from vBulletin to phpBB for a friend and the BBCode works fine in posts but it doesn't get parsed at all in signatures. So it shows up like [b]bold[/b] instead of actually bolding it. :/ Maybe I missed something, but is there a fix for this? Do I have to go back and add each of them in as custom bbcode or will that not work?

EDIT: nvm. the "Disable BBCode" option was checked by default for some reason. :roll:
Don't forget to smile today. :)
Please do NOT contact for support via PM or email.
ferret141
Registered User
Posts: 2
Joined: Sun Dec 06, 2009 7:29 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by ferret141 »

I'm trying to use ISO-8859-6 but can't because I get the following error.

Code: Select all

General Error
Unknown encoding: iso-8859-6
Any advice?

Do I need to get an appropriate language pack installed on that server?
User avatar
InternetMafia
Registered User
Posts: 146
Joined: Sun Apr 06, 2008 4:55 pm
Location: New York
Contact:

Re: [Convertor] vBulletin 3.x to phpBB3

Post by InternetMafia »

Ok, I have a stupid question.

How am I supposed to find the proper encoding for my vbulletin install.

I mean where do I look in vbulletin to find what it is currently using?
Dangerous But Worth The Risk
ninowebs
Registered User
Posts: 191
Joined: Tue Dec 15, 2009 6:36 pm
Location: Italia Sicilia
Contact:

Re: [Convertor] vBulletin 3.x to phpBB3

Post by ninowebs »

D¡cky wrote:
Seanieb1983 wrote:Anyway it converts now, but i cant log in there's something up with the password field:

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'user_passwd_salt' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
The convertor should have created the user_passwd_salt field. You can create it manually in phpMyAdmin by entering the following code in the SQL tab: (If your table prefix is not phpbb_ replace with your table_prefix)

Code: Select all

ALTER TABLE phpbb_users ADD user_passwd_salt varchar(5) COLLATE utf8_bin NOT NULL DEFAULT ''
You will need to rerun the convertor so the field gets filled in.
ok, have succeeded but the list is not visible to users, are not authorized message, how can I do?
thanks
ninowebs
Registered User
Posts: 191
Joined: Tue Dec 15, 2009 6:36 pm
Location: Italia Sicilia
Contact:

Re: [Convertor] vBulletin 3.x to phpBB3

Post by ninowebs »

Can you help me, I only users who have enabled the board member list unauthorized access
thank you
Cyber_Punk
Registered User
Posts: 7
Joined: Wed Jan 20, 2010 1:07 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Cyber_Punk »

Hi, I am trying to convert vB 3.8.4 and I keep getting this error, I was getting a different error till I read through this thread and it recommended I removed all the vB hacks (plugins) which I did but now I get this error and I have no idea what it is I need to do.
General Error
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 attachment, 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: 405
CALL: install_convert->main()

FILE: install/index.php
LINE: 282
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 »

Cyber_Punk wrote:Hi, I am trying to convert vB 3.8.4 and I keep getting this error, I was getting a different error till I read through this thread and it recommended I removed all the vB hacks (plugins) which I did but now I get this error and I have no idea what it is I need to do.
General Error
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 attachment, post WHERE (post.postid = attachment.postid) ORDER BY attachment.attachmentid LIMIT 2000
Look in the vBulletin attachments table. There should be a column that tells vB which post an attachment is attached to. It may be named differently than what the convertor is looking for.
Have you hugged someone today?
Cyber_Punk
Registered User
Posts: 7
Joined: Wed Jan 20, 2010 1:07 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Cyber_Punk »

D¡cky wrote:
Cyber_Punk wrote:Hi, I am trying to convert vB 3.8.4 and I keep getting this error, I was getting a different error till I read through this thread and it recommended I removed all the vB hacks (plugins) which I did but now I get this error and I have no idea what it is I need to do.
General Error
SQL ERROR [ mysqli ]

Unknown column 'attachment.postid' in 'field list' [1054]
Look in the vBulletin attachments table. There should be a column that tells vB which post an attachment is attached to. It may be named differently than what the convertor is looking for.
O.k I have looked at the fields and I have Attachmentid, contenttypeid, contentid, userid, dateline, fielddataid, state, counter, posthash, filename, caption, reportthreadid, settings. I really do not see what one it could be or if it was here where would I have to go to change it. Sorry for being a complete noob at this but these are the first forums I ever ran lol. Also I was wondering if there was anyway I could just create the field and have it null just so I could make it through the rest of the conversion. Loosing some attachments is really the least of my worries. (accounts and actual posts on the other hand...)


[EDIT] Actually I believe it may be contentid but in what file do I have to edit postid?
[EDIT2] O.k I found where to change it in convert_vb30.php I changed it and now it saying attachment.filedata is causing the error. What is filedata making reference to so I know what to change it to?

[EDIT 3] Never mind all that I ended up commenting out 4 lines in the conversion file that referenced fields I did not have, I got well beyond that step all the way to the zebra part and I got that post id error I remember reading about that a few pages back so I should be good to go.

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 »

filedata is the actual content of the attachment. This only applies if you have the option set to store attachments in the database. It wouldn't be needed if attachments are saved to the filesystem.
Have you hugged someone today?
Cyber_Punk
Registered User
Posts: 7
Joined: Wed Jan 20, 2010 1:07 am

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Cyber_Punk »

D¡cky wrote:filedata is the actual content of the attachment. This only applies if you have the option set to store attachments in the database. It wouldn't be needed if attachments are saved to the filesystem.
Yeah I don't use that option, everything is now converted over. Thanks a lot Dicky!!
Bartman_
Registered User
Posts: 1
Joined: Wed Jan 20, 2010 4:04 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Bartman_ »

Handy mod this, just finished a test import from vB 3.8.4 and apart from the poll limit it seems to have gone well :)

Would recommend doing this in a htaccess locked dir though. Glad I took that precaution because all private forums were suddenly out in the open... Might send you on a phpBB forum management crash course, if you don't.

One issue's still there though: we rarely use physical delete, and after the import, thousands of soft deleted posts now seem to have reverted to their original visible status, even for unregistered guests. Did I miss an import setting or is this an actual bug (/feature)?
Sunwalker
Registered User
Posts: 11
Joined: Sat Sep 30, 2006 5:07 pm

Re: [Convertor] vBulletin 3.x to phpBB3

Post by Sunwalker »

Is it possible to import users (and optionally usergroups) from vB only?
Locked

Return to “[3.0.x] Convertors”