vB 3.x convertor

[D¡cky]

Do you see the row that has a forum_id of -1? I'll bet that is where the problem is. I assume ther os no forum with an id of -1.

Try to fix that in the Admin Panel by checking what forums user_id 1 moderates. If it can't be fixed in the Admin panel, remove that row from the database. I cant guarantee what other problems that will cause, though, but I think it is worth a try. Or you could change the forum_id to a valid forum_id.

[Nando]

I cant access the forum anymore, I just have the database. I will have to edit the database table then. Should I remove the row? or simply edit the number for some other number, like 0 or 1?

[D¡cky]

Edit the forum_id to a valid forum_id, but not one that user_id 1 is already a moderator of.

[Nando]

I just edit the tables and didn't do the last changes you mentioned. It worked perfectly. convertion was finished. I had problems loging in, though. I had to reset the password, then it worked. I guess this will help with all users... :-/

The board seems to be messed up, forums and subforums out of order and stuff like that. Will have a lot of work setting it back.

Anyway, thank you very much for your help. I really appreceiated it. You rock!

Cheers!

[Blaine0002]

Ok, so i managed to apply all changed mentioned in this thread, and everything seemed to work completely, except, i try to log in, and it says wrong password even though it is right.
im comverting from 3.6.7 if that matters


Thanks

btw im attaching a zip with everything fixed..

tell me if you want it removed.

ty

[DieHardcc]

btw im attaching a zip with everything fixed..

Wow, thanks for contributing your help to the community. I'll look into this updated vbulletin convertor this weekend. Let us know how you resolve the login issue and if you uploaded a new version of the vbulletin convertor?

[Blaine0002]

Well i resolved my issue, it was actually a combination of things.

one i forgot to delete my install directory, so my forum was inactive

2, i still wasnt able to login, so i just went find lost password, since my forum wasnt very big (<20 people) i just told them to do the same.

[iamcommie]

Hi, I've been trying the converter and have hit almost every error that Nando was getting (and the fixes have worked for me so far) but I've hit a new error not listed here:

Code: Select all

SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_id' at row 1 [1264]

Any ideas?

[D¡cky]

Try this

OPEN functions_vb30.php

FIND

Code: Select all

return $option+1;

REPLACE WITH

Code: Select all

return (int) $option+1;

If it doesn't work, post the complete error message, please.

[iamcommie]

Thanks for the help. I got the same error:

Code: Select all

SQL ERROR [ mysqli ]

Out of range value adjusted for column 'poll_option_id' at row 1 [1264]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(425,10392,"HOMEMADE",33)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 51
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1653) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: install/install_convert.php
LINE: 1653
CALL: eval()

FILE: install/install_convert.php
LINE: 800
CALL: install_convert->jump()

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

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()

[r1chardyoung]

Converting from mySQL VB 3.6 to phpbb3 I receive the following error:

Code: Select all

General Error
SQL ERROR [ mssql ]

Incorrect syntax near the keyword 'COLUMN'.
Incorrect syntax near the keyword '%.*ls'. [156]

SQL

ALTER TABLE phpbb_users ADD COLUMN salt varchar(3)

BACKTRACE

FILE: includes/db/mssql.php
LINE: 137
CALL: dbal_mssql->sql_error()

FILE: install/install_convert.php
LINE: 1104
CALL: dbal_mssql->sql_query()

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

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()

[r1chardyoung]

Think Ive found an issue:

Warning: The table 'phpbb_users' has been created but its maximum row size (11240) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

[A_Jelly_Doughnut]

This convertor is not intended to work with MSSQL (since vBulletin doesn't support MSSQL)

[iamcommie]

Try this

If it doesn't work, post the complete error message, please.

You know, I just tried importing by vbulletin database into simplemachines forum to see what would happen and it choked on the polls as well. I deleted the poll tables and tried the import again and BAM no problem. I suspect my poll tables may have been broken. I will attempt the import again later (500,000+ posts ) and see what happens. I suspect it should be smooth sailing.

Thanks for the help.

edit: confirmed the problem was my database. Deleting the poll tables fixed everything.

[thejdm]

guessing this will work for vb3.6.4 converting to phpbb3 gold?

i converted from phpbb to vB awhile back but i had a friend do it. is it that hard to do?