vB 3.x convertor

[wlx]

[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.

[mohammedessam]

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]

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

[D¡cky]

OPEN convert_vb30.php

FIND and DELETE

Code: Select all

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

[kosovaa]

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]

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

[D¡cky]

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

The link is in the first post.

[Nando]

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

[D¡cky]

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.

[Nando]

Oh I see.... thanks!

[Nando]

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!

[Raimon]

Where is you old board located , on domain name/forums_old ?

[Nando]

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

And it doesn't work either.

[Raimon]

When you move it into the phpbb3 directory, just select this as old board path ; /forums_old

[Nando]

Now this happens:

What's wrong?