| View previous topic :: View next topic |
| Author |
Message |
ptitmain
New Poster
Joined: 17 Nov 2003
Posts: 2
  
|
 Posted: Wed Jul 14, 2004 10:08 Post subject: Upgrading from 0.8.6.2 to 0.9.0.10 (8030 to 8050): mysql pb |
 |
|
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 |
|
| Back to top |
|
 |
blueyed
Core Developer
Joined: 10 Nov 2003
Posts: 1856
votes: 18
|
| Posted: Wed Jul 14, 2004 17:18 Post subject: |
|
|
replace the function set_upgrade_checkpoint at top of install/_functions_evoupgrade.php with this:
| Code: |
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";
}
|
_________________
.\|/. Create rainforest .\|/. | daniel.hahler.de | Ubuntu Linux |
|
| Back to top |
|
|
ptitmain
New Poster
Joined: 17 Nov 2003
Posts: 2
|
| Posted: Thu Jul 15, 2004 3:45 Post subject: It works ! |
|
|
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! |
|
| Back to top |
|
|
fplanque
Core Developer
Joined: 13 Jun 2003
Posts: 863
votes: 9
|
|
| Back to top |
|
|
Graham
Expert
Joined: 14 Jun 2003
Posts: 727
|
| Posted: Fri Jul 16, 2004 19:03 Post subject: |
|
|
Just put it into the current 0.9.0.10 package - those that already have upgraded with no problems don't need it anyway...
_________________
tin-men - it's not that awful.
Honest.*
*Not really
Please use the search and manual. |
|
| Back to top |
|
|
sselden
New Poster
Joined: 20 Jun 2004
Posts: 22
|
| Posted: Sun Aug 01, 2004 1:25 Post subject: |
|
|
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
_________________
I'm not really a geek, I just play one on tv. |
|
| Back to top |
|
|
sselden
New Poster
Joined: 20 Jun 2004
Posts: 22
|
| Posted: Sun Aug 01, 2004 1:26 Post subject: Re: It works ! |
|
|
| 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?
_________________
I'm not really a geek, I just play one on tv. |
|
| Back to top |
|
|
sselden
New Poster
Joined: 20 Jun 2004
Posts: 22
|
| Posted: Sun Aug 01, 2004 1:39 Post subject: |
|
|
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:
| Code: |
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";
} |
_________________
I'm not really a geek, I just play one on tv. |
|
| Back to top |
|
|
Topanga
ChairWoman
Joined: 14 Jun 2003
Posts: 1430
votes: 12
|
| Posted: Sun Aug 01, 2004 5:25 Post subject: |
|
|
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)
_________________
www.tenderfeelings.net (english) - www.tenderfeelings.be (nederlands) - www.hungryfeelings.be (nederlands)
Help on a forum is a work of 'paying it forward'
We help you and then you help another one.. |
|
| Back to top |
|
|
fplanque
Core Developer
Joined: 13 Jun 2003
Posts: 863
votes: 9
|
|
| Back to top |
|
|
sselden
New Poster
Joined: 20 Jun 2004
Posts: 22
|
| Posted: Sun Aug 01, 2004 19:46 Post subject: |
|
|
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!
_________________
I'm not really a geek, I just play one on tv. |
|
| Back to top |
|
|
|
Home
Search
Usergroups
Register
Log in
