View Issue Details

IDProjectCategoryView StatusLast Update
0000251WackoWikiinstallerpublic2009-10-13 16:03
Reporterpascalvmf Assigned Topascalvmf  
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.2 
Target Version5.0.betaFixed in Version5.0.beta 
Summary0000251: upgrade fails in alter_revisions due to a typo (fix included)
DescriptionWhen upgrading from 4.2 to 4.3 in a mysql environnement an error is reported while altering sql tables for revisions.

It is due to a typo in setup/database-install.php where the wrong variable is used.

The following order is used :
$alter_revisions_r4_3_1 $alter_revisions_r4_3_2

$alter_revisions_r4_3_1 does not exist, so it should be :
$alter_revisions_r4_3_2 $alter_revisions_r4_3_3
Steps To Reproduceupgrade from 4.2 to 4.3
Additional InformationFix for setup/database-install.php

/setup# diff -u database-install.php.old database-install.php
--- database-install.php.old 2009-01-06 14:10:42.000000000 +0100
+++ database-install.php 2009-01-06 14:11:50.000000000 +0100
@@ -225,8 +225,8 @@
                         test(str_replace("%1","pages",$lang["AlterTable"]), @mysql_query($alter_pages_r4_3, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
                         test(str_replace("%1","pages",$lang["AlterTable"]), @mysql_query($alter_pages_r4_3_2, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
                         test(str_replace("%1","pages",$lang["AlterTable"]), @mysql_query($alter_pages_r4_3_3, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
- test(str_replace("%1","revisions",$lang["AlterTable"]), @mysql_query($alter_revisions_r4_3_1, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
                         test(str_replace("%1","revisions",$lang["AlterTable"]), @mysql_query($alter_revisions_r4_3_2, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
+ test(str_replace("%1","revisions",$lang["AlterTable"]), @mysql_query($alter_revisions_r4_3_3, $dblink), str_replace("%1", "pages", $lang["ErrorAlteringTable"]));
                         test($lang["InstallingLogoImage"], @mysql_query($insert_logo_image, $dblink), str_replace("%1","logo image",$lang["ErrorAlreadyExists"]));
                   }
                print(" \n");
TagsNo tags attached.

Relationships

related to 0000245 resolvedTann San Upgrade -> PDO Error: invalid data source name 
related to 0000115 resolvedTann San var dbclick = "page"; 

Activities

administrator

2009-01-08 10:56

administrator   ~0000559

Last edited: 2009-01-08 11:17

note to same error -> 0000115:0000535

administrator

2009-01-08 11:24

administrator   ~0000560

Last edited: 2009-01-09 22:54

Fix SVNed with revision 220

btw. it should be r4_2_x instead of r4_3_x because R4.2 is upgraded

 svn:220

Issue History

Date Modified Username Field Change
2009-01-06 13:37 pascalvmf New Issue
2009-01-06 13:37 pascalvmf Legacy => NEW
2009-01-06 15:44 administrator Relationship added related to 0000245
2009-01-08 10:03 administrator Relationship added related to 0000115
2009-01-08 10:10 administrator Status new => confirmed
2009-01-08 10:56 administrator Note Added: 0000559
2009-01-08 11:17 administrator Note Edited: 0000559
2009-01-08 11:24 administrator Note Added: 0000560
2009-01-08 11:24 administrator Assigned To => pascalvmf
2009-01-08 11:24 administrator Status confirmed => resolved
2009-01-08 11:24 administrator Resolution open => fixed
2009-01-08 11:24 administrator Fixed in Version => 5.0.0
2009-01-09 22:45 administrator Note Edited: 0000560
2009-01-09 22:45 administrator Note Edited: 0000560
2009-01-09 22:47 administrator Note Edited: 0000560
2009-01-09 22:54 administrator Note Edited: 0000560
2009-10-13 16:00 administrator Target Version 5.0.0 => 5.0.beta
2009-10-13 16:03 administrator Fixed in Version 5.0.0 => 5.0.beta
2010-03-08 10:14 administrator Category Installer => installer