vB 3.x convertor

[Nando]

This time it went a bit further and I had to click 'next step', so I clicked and now the following error message appears:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'pm.pmid' in 'order clause' [1054]

SQL

SELECT pmtext.pmtextid, pmtext.fromuserid AS poster_id, pmtext.iconid, pmtext.dateline, pmtext.allowsmilie AS enable_smilies, pmtext.showsignature, pmtext.title, pmtext.dateline AS post_time, pmtext.message, pmtext.touserarray FROM pmtext ORDER BY pm.pmid 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]

FIND

Code: Select all

			array(
				'target'		=> PRIVMSGS_TABLE,
				'primary'		=> 'pm.pmid',

REPLACE

Code: Select all

				'primary'		=> 'pm.pmid',

WITH

Code: Select all

				'primary'		=> 'pm.pmtextid',

[Nando]

now this message shows up:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'pm.pmtextid' in 'order clause' [1054]

SQL

SELECT pmtext.pmtextid, pmtext.fromuserid AS poster_id, pmtext.iconid, pmtext.dateline, pmtext.allowsmilie AS enable_smilies, pmtext.showsignature, pmtext.title, pmtext.dateline AS post_time, pmtext.message, pmtext.touserarray FROM pmtext ORDER BY pm.pmtextid 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]

Sorry. I told you wrong.

Instead of

Code: Select all

				'primary'		=> 'pm.pmtextid',

it shoiuld be

Code: Select all

				'primary'		=> 'pmtextid',

[Nando]

Now this:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

ALTER TABLE phpbb_users DROP COLUMN salt

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

[D¡cky]

FIND

Code: Select all

//poll选项独立作为一个函数来进行处理？					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN goodnees'),
					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

REPLACE WITH

Code: Select all

//poll选项独立作为一个函数来进行处理？					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN goodnees'),
//					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

FIND

Code: Select all

					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN salt'),
					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

REPLACE WITH

Code: Select all

//					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN salt'),
					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

[Nando]

[quote="D¡cky"]FIND

Code: Select all

//poll选项独立作为一个函数来进行处理？					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN goodnees'),
					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

REPLACE WITH

Code: Select all

//poll选项独立作为一个函数来进行处理？					array('target','ALTER TABLE '. USERS_TABLE . ' DROP COLUMN goodnees'),
//					array('target','ALTER TABLE '. USERS_TABLE . ' ADD COLUMN salt varchar(3)'),

Isn't this code the same?

Anyway I found the second piece of code, replaced it and managed to go a few steps further, then I got the following message:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'The Singing Nun" Dickson",3)' at line 1 [1064]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(15,315,"Alex "The Singing Nun" Dickson",3)

BACKTRACE

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

FILE: install/convertors/functions_vb30.php
LINE: 51
CALL: dbal_mysql->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()

[D¡cky]

FIND <snip>

Isn't this code the same?

No, I commented out the lines with //

Anyway I found the second piece of code, replaced it and managed to go a few steps further, then I got the following message:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'The Singing Nun" Dickson",3)' at line 1 [1064]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(15,315,"Alex "The Singing Nun" Dickson",3)

BACKTRACE

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

FILE: install/convertors/functions_vb30.php
LINE: 51
CALL: dbal_mysql->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()

The problem is being caused by the quotation marks in the option_text. Try this
OPEN functions_vb30.php
FIND

Code: Select all

			$sql='insert into '.POLL_OPTIONS_TABLE.' (poll_option_id,topic_id,poll_option_text,poll_option_total) values('.$row['pollid'].','.$topicid.',"'.$option[$i-1].'",'.$vote[$i-1].')';

REPLACE WITH

Code: Select all

			$sql='insert into '.POLL_OPTIONS_TABLE.' (poll_option_id,topic_id,poll_option_text,poll_option_total) values('.$row['pollid'].','.$topicid.',"'.addslashes($option[$i-1]).'",'.$vote[$i-1].')';

[Nando]

Ok, it worked, went some more steps further and then:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_acl_users (user_id, forum_id, auth_role_id) VALUES (1038, -1, 11)

BACKTRACE

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

FILE: includes/functions_convert.php
LINE: 1512
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_vb30.php
LINE: 708
CALL: mass_auth()

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

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

[D¡cky]

Can you check your vB forumpermission table and see if there is a forumid of -1?

[Nando]

no forumid -1, just forumid 28, 27, 72 and 123

[Nando]

so, no idea on how to fix this error?

thanks!

[DieHardcc]

For your information, all these troubleshooting to convert vBulletin (I hope it works with vBulletin 3.6.x) to phpBB3, I hope the next iteration of this converter would be ready for prime-time very soon.

Thank you guys.

[D¡cky]

so, no idea on how to fix this error?

thanks!

Actually, I don't, but I do see something that is not right. See if this helps:

OPEN functions_vb30.php
FIND

Code: Select all

				if (isset($access['forumpermissions']) && ($access['forumpermissions'] & 131072))

REPLACE WITH

Code: Select all

				if (isset($access['forumpermissions']) && ($access['forumpermissions'] == 131072))

[Nando]

this is the error now:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_acl_users (user_id, forum_id, auth_role_id) VALUES (1038, -1, 11)

BACKTRACE

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

FILE: includes/functions_convert.php
LINE: 1512
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_vb30.php
LINE: 708
CALL: mass_auth()

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

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