vB 3.x convertor

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
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
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: vB 3.0.x convertor for phpbb3 rc1

Post by 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',
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
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: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

Sorry. I told you wrong.

Instead of

Code: Select all

				'primary'		=> 'pm.pmtextid',
it shoiuld be

Code: Select all

				'primary'		=> 'pmtextid',
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
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: vB 3.0.x convertor for phpbb3 rc1

Post by 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)'),
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
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: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

Nando wrote:
D¡cky wrote:FIND <snip>
Isn't this code the same?
No, I commented out the lines with //
Nando wrote: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].')';
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
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: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

Can you check your vB forumpermission table and see if there is a forumid of -1?
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by Nando »

no forumid -1, just forumid 28, 27, 72 and 123
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by Nando »

so, no idea on how to fix this error?

thanks!
DieHardcc
Registered User
Posts: 4
Joined: Sun Nov 19, 2006 2:22 am
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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. :)
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: vB 3.0.x convertor for phpbb3 rc1

Post by D¡cky »

Nando wrote: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))
Have you hugged someone today?
Nando
Registered User
Posts: 80
Joined: Sun May 19, 2002 10:40 pm
Location: Rio de Janeiro, Brazil
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by 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()
Locked

Return to “[3.0.x] Convertors”