replace the function set_upgrade_checkpoint at top of install/_functions_evoupgrade.php with this:

function set_upgrade_checkpoint( $version )
{
	global $DB;

	echo "Creating DB schema version checkpoint at $version... ";

	if( $version < 8060 )
	{
		$query = 'UPDATE T_settings SET db_version = '.$version;
	}
	else
	{
		$query = "UPDATE T_settings
								SET set_value = '$version'
								WHERE set_name = 'db_version'" );
	}
	$DB->query( $query );

	echo "OK.<br />\n";
}

Thanks a lot !

Just an error here:
$query = "UPDATE T_settings
SET set_value = '$version'
WHERE set_name = 'db_version'" );

To transform in:
$query = "UPDATE T_settings
SET set_value = '$version'
WHERE set_name = 'db_version'";

And it's ok, the database was upgraded. Thanks a lot for the quick answer !

Checking DB schema version... 8030 : OK.
Creating table for Antispam Blackist... OK.
Creating default blacklist entries... OK.
Upgrading Settings table... OK.
Upgrading blogs table... OK.
Creating table for Groups... OK.
Creating default groups... OK.
Creating table for Blog-User permissions... OK.
Creating user blog permissions... OK.
Upgrading users table... OK.
Assigning user groups... OK.
Upgrading settings table... OK.
Creating DB schema version checkpoint at 8050... OK.
Creating table for Locales... OK.
Upgrading posts table... OK.
Converting langs to locales for evo_posts...
Converting lang 'fr' to locale 'fr-FR'
Converting lang 'en' forced to default locale 'en-US'
Upgrading blogs table... OK.
Converting langs to locales for evo_blogs...
Converting lang 'fr' to locale 'fr-FR'
Converting settings table... OK.
Upgrading Comments table... OK.
Upgrading Users table... OK.
Creating DB schema version checkpoint at 8060... OK.
Checking for extra quote escaping in posts... OK.
Creating DB schema version checkpoint at 8062... OK.
Checking for extra quote escaping in comments... OK.
Creating DB schema version checkpoint at 8064... OK.

Upgrade completed successfully!

I'm wondering if we should release a 0.9.0.11 with this fix included... :P

Just put it into the current 0.9.0.10 package - those that already have upgraded with no problems don't need it anyway...

I think there's more to this fix than that, as I tried both:
1.Running install script and getting the problem mentioned above
2.editing the install script with replacement function and rerunning it
=
I still got errors

I then uninstalled everything and reinstalled my old version, then ran the 9.0.10 install script with the change. I still got errors and was unable to upgrade.

(I am testing upgrading on a testing server before I upgrade my real blog which is why it's easy for me to keep starting from scratch.)

If there is a fix for this problem could you post step by step directions?
thank you,
sharon

ptitmain wrote:

Thanks a lot !

Just an error here:
$query = "UPDATE T_settings
SET set_value = '$version'
WHERE set_name = 'db_version'" );

To transform in:
$query = "UPDATE T_settings
SET set_value = '$version'
WHERE set_name = 'db_version'";

And it's ok, the database was upgraded. Thanks a lot for the quick answer !

What does it mean "to transform in" does that mean there are additional changes I need to make to the install script to get it to work?

this is the error I get when i add the code from above:
Parse error: parse error, unexpected T_STRING in <path edited out>/_functions_evoupgrade.php on line 23

This is the code I added:

function set_upgrade_checkpoint( $version ) 
 { 
 ? ?global $DB; 

 ? ?echo "Creating DB schema version checkpoint at $version... "; 

 ? ?if( $version < 8060 ) 
 ? ?{ 
 ? ?? ?$query = 'UPDATE T_settings SET db_version = '.$version; 
 ? ?} 
 ? ?else 
 ? ?{ 
 ? ?? ?$query = "UPDATE T_settings 
 ? ?? ?? ?? ?? ?? ?? ?? ?SET set_value = '$version' 
 ? ?? ?? ?? ?? ?? ?? ?? ?WHERE set_name = 'db_version'"; 
 ? ?} 
 ? ?$DB->query( $query ); 

 ? ?echo "OK.<br />\n"; 
 } 

There is also the same error when upgrading from 0.8.7 (the one that yellowtip installs.

My sollution was at that point to install a new version (not upgrading) but if you have real posts in it, that it is a pain in the ass (I do have a 0.8.6 version running somawhere, but at this point I'm not updating yet)

There is a bug in 0.9.0.10 "copenhagen" that prevents seemless upgrade from older versions (prior to 0.8.9).

If you encounter this problem, please use this specially fixed "0.9.0.10b" release instead:

http://prdownloads.sourceforge.net/evocms/b2evolution-0.9.0.10b-2004-08-01.zip?download

And please let us know how it works for you. ;)

Problem solved. I have not yet tried on my "real" blog, but I was able to upgrade my testing set-up in -- about 5 mins!! WHOOO-HOOO!