[geeklog-hg] geeklog: missing blank caused an SQL error during upgrade/migration

[geeklog-cvs at lists.geeklog.net]

changeset 9207:5ad7b8704786
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/5ad7b8704786
user: Dirk Haun <dirk at haun-online.de>
date: Wed Jul 17 20:05:38 2013 +0200
description:
missing blank caused an SQL error during upgrade/migration

diffstat:

 plugins/staticpages/sql/mysql_updates.php |  2 +-
 plugins/staticpages/sql/pgsql_updates.php |  2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diffs (24 lines):

diff -r b02e3a846275 -r 5ad7b8704786 plugins/staticpages/sql/mysql_updates.php
--- a/plugins/staticpages/sql/mysql_updates.php	Wed Jul 17 07:03:07 2013 -0400
+++ b/plugins/staticpages/sql/mysql_updates.php	Wed Jul 17 20:05:38 2013 +0200
@@ -71,7 +71,7 @@
     
     '1.6.5' => array(
         "ALTER TABLE {$_TABLES['staticpage']} ADD `cache_time` INT NOT NULL DEFAULT '0' AFTER `template_id`", 
-        "ALTER TABLE {$_TABLES['staticpage']} CHANGE `sp_id``sp_id` VARCHAR(128) NOT NULL DEFAULT ''"
+        "ALTER TABLE {$_TABLES['staticpage']} CHANGE `sp_id` `sp_id` VARCHAR(128) NOT NULL DEFAULT ''"
     )
 );
 
diff -r b02e3a846275 -r 5ad7b8704786 plugins/staticpages/sql/pgsql_updates.php
--- a/plugins/staticpages/sql/pgsql_updates.php	Wed Jul 17 07:03:07 2013 -0400
+++ b/plugins/staticpages/sql/pgsql_updates.php	Wed Jul 17 20:05:38 2013 +0200
@@ -49,7 +49,7 @@
     
     '1.6.5' => array(
         "ALTER TABLE {$_TABLES['staticpage']} ADD `cache_time` INT NOT NULL DEFAULT '0' AFTER `template_id`", 
-        "ALTER TABLE {$_TABLES['staticpage']} CHANGE `sp_id``sp_id` VARCHAR(128) NOT NULL DEFAULT ''"
+        "ALTER TABLE {$_TABLES['staticpage']} CHANGE `sp_id` `sp_id` VARCHAR(128) NOT NULL DEFAULT ''"
     )  
 );