vB 3.x convertor

[Raimon]

Is the prefix of your board VB_ you can find that into the config.php file i believe, or you can go to your phpmyadmin selected your VB database , you will find there nameprefix_table , what you find before the table is the prefix.

[Nando]

Now I get this error message:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xE3s.\x0D\x0A' for column 'forum_desc' at row 1 [1366]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_flags, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons, left_id, right_id) VALUES ('46', 'Meltdown', '56', '', 'General chat / Forum de bate-papo com outros f�s.\r\n', 1, 0, 34, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0, '44', 45)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 270
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php(1004) : eval()'d code
LINE: 4
CALL: phpbb_insert_forums()

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

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

[D¡cky]

The vBulletin database needs to be on the same server as the phpBB3 database.

[Nando]

but they are on the same server

[Raimon]

And have you also installed phpBB3 on the same database where you have installed VB ?

[Nando]

no, they're different databases. Should I have installed in the same database?

[Raimon]

Yes, the must be in the same database otherwise it don't work.

[Nando]

I installed it again, this time in the same database as vbulletin and the following error appeared:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\xF3rum B...' for column 'forum_name' at row 1 [1366]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_rules, left_id, right_id) VALUES ('120', 'F�rum Brasileiro', 0, '', '', 0, 0, '', 63, 64)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: install/convertors/functions_vb30.php
LINE: 200
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php(1004) : eval()'d code
LINE: 4
CALL: phpbb_insert_forums()

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

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

[D¡cky]

See if this will work

OPEN functions_vb30.php
FIND

Code: Select all

function phpbb_set_encoding($text, $grab_user_lang = true)
{
	return $text;
}

REPLACE WITH

Code: Select all

function phpbb_set_encoding($text, $grab_user_lang = true)
{
	global $lang_enc_array, $convert_row, $db_character_set;
	global $convert, $phpEx;
	
	$encoding = $db_character_set;

	return utf8_recode($text, $encoding);
}

FIND

Code: Select all

			'forum_name'	=> $row['title'],

REPLACE WITH

Code: Select all

			'forum_name'	=> htmlspecialchars(phpbb_set_default_encoding($row['title']), ENT_COMPAT, 'UTF-8'),

[Nando]

So, I replaced everything as you said and when I went to convert it again, it asked me if wanted to resume the previous convertion and I clicked yes. And the following error message appeared:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Can't DROP 'goodnees'; check that column/key exists [1091]

SQL

ALTER TABLE phpbb_topics DROP COLUMN goodnees

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: install/install_convert.php
LINE: 1104
CALL: dbal_mysql->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()

[A_Jelly_Doughnut]

In convert_vb30.php, find and remove this line

Code: Select all

							array('target','ALTER TABLE '. TOPICS_TABLE . ' DROP COLUMN goodnees'),

There is not supposed to be a 'goodnees' column in phpBB3.

[Nando]

That's the error message I get now:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'thread.goodnees' in 'field list' [1054]

SQL

SELECT thread.threadid, thread.forumid, thread.iconid, thread.postuserid, thread.attach, thread.title, thread.dateline, thread.views, thread.replycount, thread.sticky, thread.firstpostid, thread.postusername, thread.lastposter, thread.lastpost, thread.goodnees, poll.question, poll.dateline, poll.timeout, poll.numberoptions, poll.multiple FROM thread LEFT JOIN poll ON thread.pollid = poll.pollid ORDER BY thread.threadid LIMIT 2000

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 153
CALL: dbal_mysql->_sql_query_limit()

FILE: install/install_convert.php
LINE: 1234
CALL: dbal->sql_query_limit()

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

[D¡cky]

Also delete these two lines in convert_vb30.php

Code: Select all

							array('target','ALTER TABLE '. TOPICS_TABLE . ' ADD COLUMN goodnees smallint(5)'),

Code: Select all

				array('goodnees',	'thread.goodnees',			''),

Check your phpBB3 topics table and remove the column 'goodnees' if it exists. It is not used in phpBB3.

[Nando]

I don't have any topics in phpbb3 to delete, It's a fresh install. ButvI deleted he lines you mentioned and I think things got even worse, here's the error message:

Code: Select all

General Error
Unknown encoding:

Please notify the board administrator or webmaster

[D¡cky]

I don't have any topics in phpbb3 to delete, It's a fresh install. ButvI deleted he lines you mentioned and I think things got even worse, here's the error message:

I know you don't have any topics. The convertor creates a new column in the phpBB topics table named goodnees. You can safely remove that column. If you can't find it, don't worry about it.

Code: Select all

General Error
Unknown encoding:

Please notify the board administrator or webmaster

Add this:
FIND

Code: Select all

$encoding = $db_character_set;

BEFORE, ADD

Code: Select all

$db_character_set = 'utf8';

You should replace utf8 with the character set that vB is using. I don't know where the character set is stored. It might be in the configuration table in the database or in a language file.