[Convertor] vBulletin 3.x to phpBB3

[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]

If the ISO standard hasn't been set correctly. What will happen?

[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?

[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.

[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?

[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?

[ninowebs]

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]

Can you help me, I only users who have enabled the board member list unauthorized access
thank you

[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()

[D¡cky]

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.

[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]

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!!!!!!

[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.

[Cyber_Punk]

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_]

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]

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