[geeklog-cvs] geeklog: Fixed inconsistency between MySQL and MS SQL in Static ...

[geeklog-cvs at lists.geeklog.net]

changeset 8290:97c8d884d6f8
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/97c8d884d6f8
user: Dirk Haun <dirk at haun-online.de>
date: Sun May 29 09:42:06 2011 +0200
description:
Fixed inconsistency between MySQL and MS SQL in Static Pages upgrade: Set commentcode for existing pages to -1, i.e. disabled

diffstat:

 sql/updates/mssql_1.4.1_to_1.5.0.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 3b31d9c4930c -r 97c8d884d6f8 sql/updates/mssql_1.4.1_to_1.5.0.php
--- a/sql/updates/mssql_1.4.1_to_1.5.0.php	Sun May 29 09:18:16 2011 +0200
+++ b/sql/updates/mssql_1.4.1_to_1.5.0.php	Sun May 29 09:42:06 2011 +0200
@@ -486,7 +486,7 @@
     $P_SQL = array();
     $P_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} ADD [commentcode] TINYINT NOT NULL default '0'";
     // disable comments on all existing static pages
-    $P_SQL[] = "UPDATE {$_TABLES['staticpage']} SET commentcode = 0";
+    $P_SQL[] = "UPDATE {$_TABLES['staticpage']} SET commentcode = -1";
     $P_SQL[] = "UPDATE {$_TABLES['plugins']} SET pi_version = '1.5.0', pi_gl_version = '1.5.0' WHERE pi_name = 'staticpages'";
 
     foreach ($P_SQL as $sql) {