Recent Topics

Upgrading from 0.8.6.2 to 0.9.0.10 (8030 to 8050): mysql pb

Started by on Jul 14, 2004 – Contents updated: Jul 14, 2004

Jul 14, 2004 17:08    

Hi,

I am trying to upgrade b2. But when using the installer to migrate the databases, I have this trouble:

V?rification de la version du sch?ma BD... 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...

Erreur MySQL!

Unknown column 'set_name' in 'where clause'(Errno=1054)

Your query:
UPDATE evo_settings SET set_value = '8050' WHERE set_name = 'db_version'

I can restore my database, but I do not know that to do to solve that. So I need some help...

JFL

Jul 15, 2004 00:18

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";
}

Jul 15, 2004 10:45

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!

Jul 16, 2004 20:20

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

Jul 17, 2004 02:03

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

Aug 01, 2004 08:25

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

Aug 01, 2004 08:26

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?

Aug 01, 2004 08:39

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"; 
 } 

Aug 01, 2004 12:25

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)

Aug 02, 2004 02:46

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!


Form is loading...

Photo gallery software – This forum is powered by b2evolution CMS, a complete engine for your website.