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.
Get Involved
Locked
wlx
Registered User
Posts: 7
Joined: Thu May 24, 2007 8:45 am

vB 3.x convertor

Post by wlx » Sun Jun 24, 2007 3:56 pm

[edit]
This topic has been closed. The current convertor is located at http://www.phpbb.com/community/viewtopi ... &t=1722325
[/edit]

1. Just skip this step if your database's encoding is utf8. Otherwise, you need to convert your vb3 database's encoding to utf8.
Suppose your system is linux, fox e.g., my system is ubuntu feisty.
export mysql:

Code: Select all

mysql -uroot -p --add-drop-database --default-character-set=latin1 your_database > db.sql
then convert the encoding, so you know the encoding you are using now?

Code: Select all

iconv -f old_encoding -t utf8 db.sql > db_utf8.sql
then do some extra work: replace all latin1 with utf8 in db_utf8.sql, and insert the code in the beginning:

Code: Select all

SET NAMES utf8;
SET CHARACTER_SET_CLIENT=utf8;
SET CHARACTER_SET_RESULTS=utf8;
and then create a new database, and restore the db_utf8.sql.

Code: Select all

mysql -uroot -p
> create database db_utf8
mysql -uroot db_utf8 < db_utf8.sql
if errors occurs here, please check your sql file.

2. copy the old vb3.0.x to your test server.
3. Install a new phpbb3 system, and when install finished, do not close the window.
4. copy my converter to the phpbb3/install/convertors directory
5. run the converter from the installing window.
6. modify auth_db.php file, make it like with what I offered, or you can simple replace it with old one.

BTW 1: There is a chinese version, in my blog: http://wlx.westgis.ac.cn/388/
BTW 2: I could not upload the attachment now, so you can download it in my blog.
Last edited by D¡cky on Mon Aug 03, 2009 3:37 am, edited 1 time in total.
Reason: Add reason for closing topic

mohammedessam
Registered User
Posts: 1
Joined: Wed Jul 04, 2007 1:11 am

Re: vB 3.0.x convertor for phpbb3 rc1

Post by mohammedessam » Wed Jul 04, 2007 1:15 am

i get this error
[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 73: copy(./../../vb/../attach/1/8/1.attach) [function.copy]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /install/convertors/functions_vb30.php on line 73: copy(./../../vb/../attach/1/6/4.attach) [function.copy]: failed to open stream: No such file or directory

Return to the index page
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: 133
CALL: dbal_mysql->sql_error()

FILE: install/install_convert.php
LINE: 1103
CALL: dbal_mysql->sql_query()

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

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

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

and i have convert hte database to utf8

Tob76
Registered User
Posts: 29
Joined: Mon Jun 11, 2007 5:18 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by Tob76 » Wed Aug 01, 2007 5:08 pm

It does not work for me as well. I just want to import from vB 3.6.7 - my phpBB3 is RC4.

Got the following error:

Code: Select all

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: 133
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: 362
CALL: install_convert->main()

FILE: install/index.php
LINE: 234
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 » Wed Aug 08, 2007 12:09 pm

OPEN convert_vb30.php

FIND and DELETE

Code: Select all

array('target','ALTER TABLE '. TOPICS_TABLE . ' DROP COLUMN goodnees'),
Have you hugged someone today?

kosovaa
Registered User
Posts: 2
Joined: Fri Oct 12, 2007 8:37 pm

Re: vB 3.0.x convertor for phpbb3 rc1

Post by kosovaa » Fri Oct 12, 2007 8:40 pm

I get this error ??

Code: Select all

General Error
SQL ERROR [ mysqli ]

Incorrect string value: '\xEBt nd\xEB...' 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 ('3', 'Gjuha shqipe dhe gjuh�t nd�rkomb�tare', 0, '', '', 0, 0, '', 11, 12)

BACKTRACE

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

FILE: nstall/convertors/functions_vb30.php
LINE: 200
CALL: dbal_mysqli->sql_query()

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

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

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

FILE: nstall/index.php
LINE: 363
CALL: install_convert->main()

FILE: nstall/index.php
LINE: 235
CALL: module->load()

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 » Wed Oct 31, 2007 11:40 pm

Where can I download this convertor? Can't find the link anywhere...

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 » Thu Nov 01, 2007 4:27 am

Nando wrote:Where can I download this convertor? Can't find the link anywhere...
The link is in the first post.
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 » Thu Nov 01, 2007 10:13 am

I must be blind then, coz the only link I see is to a chinese page. Could you point me the link, please?

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 » Fri Nov 02, 2007 2:40 am

Nando wrote:I must be blind then, coz the only link I see is to a chinese page. Could you point me the link, please?
The download link is on the Chinese page. If you scroll down a little bit, you will see vb 3.0.x convertor. Click it.
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 » Fri Nov 02, 2007 9:57 am

Oh I see.... thanks! :D

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 » Fri Nov 02, 2007 10:52 am

Well, I'm doing something wrong... I've installed phpbb3 and now I'm trying to convert it with no success...

I should put my old forums folder inside the same installation folder as phpbb3, right? So why am I getting this error: (check attachment)

thanks!
Attachments
Untitled-1.jpg
Untitled-1.jpg (75.94 KiB) Viewed 14627 times

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by Raimon » Fri Nov 02, 2007 12:12 pm

Where is you old board located , on domain name/forums_old ?
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

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 » Fri Nov 02, 2007 12:49 pm

Yeah, but then I moved it into: domain name/phpbb3/old_forums

And it doesn't work either.

User avatar
Raimon
Former Team Member
Posts: 12088
Joined: Tue May 30, 2006 5:31 pm
Location: Netherlands
Name: Raimon Meuldijk
Contact:

Re: vB 3.0.x convertor for phpbb3 rc1

Post by Raimon » Fri Nov 02, 2007 1:28 pm

When you move it into the phpbb3 directory, just select this as old board path ; /forums_old :)
Need phpBB installation, extenstions, Styles or integrate phpBB with you website?
Contact me for fair prices and good service!

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 » Fri Nov 02, 2007 1:41 pm

Now this happens:

What's wrong?
Attachments
Untitled-2.jpg
Untitled-2.jpg (78.35 KiB) Viewed 14133 times

Locked

Return to “[3.0.x] Convertors”