IPB 2.3.4 to IPB 3 Upgrade

[gami]

I am using a 2.3.4 version of IPB .. and want to upgrade it to IPB 3 .. What is the safest way to do that .. I already backup all files and db .. Can you explain me what to do step by step ..

Edytowane 23 Stycznia 2010 przez gami

[DawPi]

Hello,

it's quite simply.

• Remove all files from FTP - EXCEPT - conf_global.php and uploads/ folder ( if you have addons like ip.downloads or ip.gallery make sure to keep their folders too! ).
  
• Upload all files from IP.Board 3.x package.
  
• Visit www.yourboard.com/admin/upgrade site and follow by upgrader.
  

[gami]

Error: RENAME TABLE ibf_custom_bbcode TO ibf_custom_bbcode_old;

Table 'ibf_custom_bbcode_old' already exists

Error: CREATE TABLE ibf_custom_bbcode (
bbcode_id int(10) NOT NULL auto_increment,
bbcode_title varchar(255) NOT NULL default '',
bbcode_desc text,
bbcode_tag varchar(255) NOT NULL default '',
bbcode_replace text,
bbcode_useoption tinyint(1) NOT NULL default '0',
bbcode_example text,
bbcode_switch_option int(1) NOT NULL default '0',
bbcode_menu_option_text varchar(200) NOT NULL default '',
bbcode_menu_content_text varchar(200) NOT NULL default '',
bbcode_single_tag tinyint(1) NOT NULL default '0',
bbcode_groups varchar(255) default NULL,
bbcode_sections varchar(255) default NULL,
bbcode_php_plugin varchar(255) default NULL,
bbcode_parse smallint(2) NOT NULL default '1',
bbcode_no_parsing tinyint(1) NOT NULL default '0',
bbcode_protected tinyint(1) NOT NULL default '0',
bbcode_aliases varchar(255) default NULL,
bbcode_optional_option tinyint(1) NOT NULL default '0',
bbcode_image varchar(255) default NULL,
bbcode_strip_search tinyint(1) NOT NULL default '0',
bbcode_app varchar(50) NOT NULL default '',
PRIMARY KEY (bbcode_id)
) TYPE=MyISAM;

Table 'ibf_custom_bbcode' already exists

Error: CREATE TABLE ibf_profile_friends_flood (
friends_id int(10) NOT NULL auto_increment,
friends_member_id int(10) unsigned NOT NULL default '0',
friends_friend_id int(10) unsigned NOT NULL default '0',
friends_removed int(10) unsigned NOT NULL default '0',
PRIMARY KEY (friends_id),
KEY my_friends (friends_member_id,friends_friend_id),
KEY friends_member_id (friends_member_id)
) TYPE=MyISAM;

Table 'ibf_profile_friends_flood' already exists... 

It's quite long error .. I try to instaled once before and didn't suceed but I restore my db before that .. and once more got this error msg .. what should I do now?

Edytowane 23 Stycznia 2010 przez gami

[DawPi]

Click on this red button -> continue or sth similar to this.

[gami]

you mean clic here if not forwarded in instaler?

[DawPi]

Hm, i think yes. Don't remember right now.

Could you show screen?

[gami]

I try that .. and on the end got this error :

mySQL query error: UPDATE ibf_custom_bbcode SET bbcode_title='Post Snap Back',bbcode_desc='This tag displays a little linked image which links back to a post - used when quoting posts from the board. Opens in same window by default.',bbcode_tag='snapback',bbcode_replace='',bbcode_useoption=0,bbcode_example='100[/snapback]',bbcode_switch_option=0,bbcode_menu_option_text='',bbcode_menu_content_text='',bbcode_php_plugin='defaults.php',bbcode_parse=2,bbcode_no_parsing=0,bbcode_optional_option=0,bbcode_aliases='',bbcode_image='',bbcode_single_tag=0,bbcode_app='core',bbcode_protected=0 WHERE bbcode_tag='snapback'

SQL error: Unknown column 'bbcode_php_plugin' in 'field list'

SQL error code: 1054

Date: Saturday 23rd o January 2010 01:20:39 AM

Edytowane 23 Stycznia 2010 przez gami

[DawPi]

Skip this if you may..

I hope you made database backup?

Tesh kcę być w oknie z podglądem styli.

[gami]

I already said in first post .. I got all backups .. what should I do next ? restore it ?

[DawPi]

Nope. Could you move on and skip this step?

[gami]

Move it on another step and got some errors to .. eventually on the end this came threw

[DawPi]

Oh, that's odd.

Well, for sure - restore database and try do this again.

I suggest you do this in this order:

IP.Board 2.3.4

IP.Board 2.3.6 IP.Board 3.0.5

[gami]

I have to upgrade to 2.3.6 first and after that on 3.0.5 ?

[DawPi]

Yes, try in this way.

[gami]

This will take a while .. I'll let you know what's progress ..

[DawPi]

Sure. Take your time.

[gami]

I successfully updated forum to 2.3.6 version no errors in database or anywhere else .. what should I do next ? same thing from your first post ? Delete all files except - conf_global.php and uploads/ folder.. then Upload IPb 3 files and run upgrade .. nothing else ?

Edytowane 24 Stycznia 2010 przez gami

[DawPi]

Yes..

[gami]

damn .. got a same error like in post 3 ...

Edytowane 24 Stycznia 2010 przez gami

[DawPi]

So open ticket, IPS will do this for you for free.

[gami]

I manage to fix this once for all finaly

[DawPi]

This is great news!