managerblue wrote:

My b2evolution Version: 4.0.5

I would like to upgrade b2evolution 3.3.3 to 4.0.5

- Error, when "Upgrading data in existing b2evolution database..."
- Detail in picture (2 files)
- http://www.blogtika.com/ (blog zone)

How to fix problem?
Thank you.

Hey buddy! Is your blog new? Is this your 1st time installing it? If this is your 1st time, I got the perfect video for you which teaches you how to install the blog.

This video is linked from youtube and walks you through the install process. Let me know if you have other questions:

http://www.youtube.com/watch?v=hncf_09N29M

I would like to upgrade b2evolution 3.3.3 to 4.0.5

@SkyWolfX7
It's not about installing b2evo. Nice video by the way ;)

@managerblue
Find and edit the following line in /install/_functions_evoupgrade.php line 2776

$DB->query( 'ALTER TABLE T_items__tag CHANGE COLUMN tag_name tag_name varbinary(50) not null' );

Chande to

$DB->query( 'ALTER TABLE T_items__tag CHANGE COLUMN tag_name tag_name varbinary(100) not null' );

You may need to remove all previous database modification statements, just make sure you have the following on lines 2648-2662

if( $old_db_version < 10000 )
{	// 4.0 part 4
	task_begin( 'Upgrading tags table...' );
	$DB->query( 'ALTER TABLE T_items__tag CHANGE COLUMN tag_name tag_name varbinary(100) not null' );
	task_end();

	// fp> I don't understand why we need to carry this out "again" but I observed the installer barking on
	// this setting missing when upgrading from older 2.x versions. I figured it would be no big deal to do it twice...
	task_begin( 'Makin sure usersettings table is InnoDB...' );
	$DB->query( 'ALTER TABLE T_users__usersettings ENGINE=innodb' );
	task_end();

	// set_upgrade_checkpoint( '10000' );
}

Oh woops. I am sorry. Didn't read the part he was upgrading his blog not installing it. :P Totally sorry.

All I saw was the picture and jumped to a conclusion.