IPB 2.3.x to phpBB 3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Suggested Hosts
cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 5:36 pm

Hi, when I click on Convert, i've this error
Database info are good :(

Code: Select all

SQL ERROR [ mysql4 ]

Table 'db222709344.ibf_' doesn't exist [1146]

SQL

SELECT * FROM ibf_

BACKTRACE

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

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

FILE: includes/functions_convert.php
LINE: 281
CALL: get_config()

FILE: install/convertors/functions_ipb23.php
LINE: 234
CALL: get_config_value()

FILE: install/install_convert.php
LINE: 733
CALL: include('install/convertors/functions_ipb23.php')

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

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 5:54 pm

check config schema in /install/convertors/convert_ipb23.php
check prefix.

cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 5:58 pm

In convert_ipb23.php, this is:

Code: Select all

       'table_prefix'   => 'ibf_',
And in my db is: ibf_xxx
I don't understand !

(PS: sorry for my english)

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 6:13 pm

$config_schema = array(
'table_name' => 'conf_settings',
'table_format' => array('conf_key' => 'conf_value'),
'settings' => array(
'msg_allow_code'=> 'allow_bbcode',
'auth_allow_dnames'=> 'allow_namechange',
'avatars_on' => 'allow_avatar_local',
'avatar_url' => 'allow_avatar_remote',
'board_offline' => 'board_disable',
'board_name' => 'sitename',
'session_expiration' => 'session_length',
'display_max_posts' => 'posts_per_page',
'display_max_topics' => 'topics_per_page',
'allow_skins' => 'override_user_style',
'max_poll_choices' => 'max_poll_options',
'max_sig_length' => 'max_sig_chars',
'show_max_msg_list' => 'max_inbox_privmsgs',
'smtp_port' => 'smtp_delivery',
'smtp_host' => 'smtp_host',
'smtp_username' => 'smtp_username',
'smtp_password' => 'smtp_password',
'flood_control' => 'flood_interval',
'csite_article_date' => 'default_dateformat',
'time_offset' => 'board_timezone',
'disable_gzip' => 'not(gzip_compress)',
'use_coppa' => 'is_empty(coppa_mail)',
'coppa_fax' => 'coppa_fax'
)
);
so, ibf_conf_settings should exist and every listed key should be in ibf_conf_settings.conf_key

cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 6:47 pm

I'm sorry but i don't understand that you say.
This is ma database:
Image

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 7:05 pm

your db is modded. check structure and fields in ibf_conf_settings.

cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 7:28 pm

There are many many fields in conf_settings ! (more 450 !)
I must delete all fields except:

Code: Select all

       'msg_allow_code'=> 'allow_bbcode',
          'auth_allow_dnames'=> 'allow_namechange',
          'avatars_on'   => 'allow_avatar_local',
          'avatar_url'   => 'allow_avatar_remote',
          'board_offline'         => 'board_disable',
          'board_name'            => 'sitename',
          'session_expiration'      => 'session_length',
          'display_max_posts'      => 'posts_per_page',
          'display_max_topics'      => 'topics_per_page',
          'allow_skins'   => 'override_user_style',
          'max_poll_choices'      => 'max_poll_options',
          'max_sig_length'         => 'max_sig_chars',
          'show_max_msg_list'         => 'max_inbox_privmsgs',
          'smtp_port'         => 'smtp_delivery',
          'smtp_host'            => 'smtp_host',
          'smtp_username'         => 'smtp_username',
          'smtp_password'         => 'smtp_password',
          'flood_control'      => 'flood_interval',
          'csite_article_date'   => 'default_dateformat',
          'time_offset'      => 'board_timezone',
          'disable_gzip'         => 'not(gzip_compress)',
          'use_coppa'         => 'is_empty(coppa_mail)',
          'coppa_fax'            => 'coppa_fax'


?

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 7:37 pm

no. you must check every field if they're exist.

or change config schema to this.
$config_schema = array(
'table_name' => 'conf_settings',
'table_format' => array('conf_key' => 'conf_value'),
'settings' => array(
'board_name' => 'sitename',
)

but in this case your board settings will not converted(except sitename).

cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 7:47 pm

no. you must check every field if they're exist.
Since i've installed ipb, i didn't delete fields, why fileds not will be in the database ?
Do you want my databse ?

I'm sorry, I speak english since few months !

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 8:25 pm

Since i've installed ipb, i didn't delete fields, why fileds not will be in the database ?
maybe installed mods changed structure of db.
Do you want my databse ?
yes, please. my email is alina0584@gmail.com.

cacahuete
Registered User
Posts: 25
Joined: Sun Mar 05, 2006 2:50 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by cacahuete » Sat Nov 17, 2007 8:44 pm

mail sent :)

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Sat Nov 17, 2007 9:29 pm

thanks! i received your mail.

zamri
Registered User
Posts: 27
Joined: Thu Feb 24, 2005 12:04 pm

Re: IPB 2.3.x to phpBB 3

Post by zamri » Wed Nov 28, 2007 2:57 am

How about converting board full of MOD? Are there any special steps involved?

Klia
Registered User
Posts: 21
Joined: Sun Aug 26, 2007 8:28 pm
Contact:

Re: IPB 2.3.x to phpBB 3

Post by Klia » Wed Nov 28, 2007 6:31 am

No. I have used unmodified IPB. Many MODs are commercial.

VVVas
Registered User
Posts: 22
Joined: Sun Jun 26, 2005 8:42 am
Location: RU - MSK
Contact:

Bugs

Post by VVVas » Fri Jan 04, 2008 4:03 pm

Klia
Bugs:
users not added in standart group "Registered Users"
in post bbcode is disabled
and very important for me is: bbcode_uid != uid in bbcode in posts and signatures
(12, 12, 0, 1195, 0, '33.7.0.37', 1090741961, 1, 0, 0, 1, 1, 1, 'Геккон', '', 'Обмен на хардах по Москве.\r\n\r\n[b:2fdw1dkq]Trigun[/b:2fdw1dkq] - 8\r\nПодробности - [url=http://anime.sugoi.ru:2fdw1dkq]http://anime.sugoi.ru[/url:2fdw1dkq]\r\nСписок XLS - [url=http://anime.sugoi.ru/Ani_Geckon.xls:2fdw1dkq]http://anime.sugoi.ru/Ani_Geckon.xls[/url:2fdw1dkq]', '', 0, '', 'x025fwpb', 1, 1092168411, '', 0, 0, 0)
also there is any problem with username, but that I am concrete still has not understood
I am sorry for my bad english. I do not know it. I am from Russian.
forum.VVVas.ru

Locked

Return to “[3.0.x] Convertors”