Allow bigger values for a topic's Sort Order field (feature request #0001011) HEAD
authorDirk Haun <dirk@haun-online.de>
Thu Oct 29 11:37:11 2009 +0100 (4 months ago)
branchHEAD
changeset 7393d0952e303944
parent 73923872f0c040e4
child 7395bb675c876cb9
Allow bigger values for a topic's Sort Order field (feature request #0001011)
public_html/docs/history
sql/mysql_tableanddata.php
sql/updates/mysql_1.6.0_to_1.6.1.php
     1.1 --- a/public_html/docs/history	Sun Oct 25 23:15:27 2009 +0000
     1.2 +++ b/public_html/docs/history	Thu Oct 29 11:37:11 2009 +0100
     1.3 @@ -3,6 +3,8 @@
     1.4  Oct ??, 2009 (1.6.1)
     1.5  ------------
     1.6  
     1.7 +- Allow bigger values for a topic's Sort Order field (feature request #0001011)
     1.8 +  [Dirk]
     1.9  - When a Story Admin did not have permission to edit a story, Geeklog threw a
    1.10    "call to a member function on a non-object" error when trying to display a
    1.11    proper "access denied" message (reported by Chase and Cesar) [Dirk]
     2.1 --- a/sql/mysql_tableanddata.php	Sun Oct 25 23:15:27 2009 +0000
     2.2 +++ b/sql/mysql_tableanddata.php	Thu Oct 29 11:37:11 2009 +0100
     2.3 @@ -396,7 +396,7 @@
     2.4    imageurl varchar(255) default NULL,
     2.5    meta_description TEXT NULL,
     2.6    meta_keywords TEXT NULL,
     2.7 -  sortnum tinyint(3) default NULL,
     2.8 +  sortnum smallint(3) default NULL,
     2.9    limitnews tinyint(3) default NULL,
    2.10    is_default tinyint(1) unsigned NOT NULL DEFAULT '0',
    2.11    archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
     3.1 --- a/sql/updates/mysql_1.6.0_to_1.6.1.php	Sun Oct 25 23:15:27 2009 +0000
     3.2 +++ b/sql/updates/mysql_1.6.0_to_1.6.1.php	Thu Oct 29 11:37:11 2009 +0100
     3.3 @@ -3,10 +3,12 @@
     3.4  // Add meta tag columns to story table 
     3.5  $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD meta_description TEXT NULL AFTER frontpage, ADD meta_keywords TEXT NULL AFTER meta_description";
     3.6  
     3.7 -
     3.8  // Add meta tag columns to topics table 
     3.9  $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD meta_description TEXT NULL AFTER imageurl, ADD meta_keywords TEXT NULL AFTER meta_description";
    3.10  
    3.11 +// allow bigger values for topic sort number
    3.12 +$_SQL[] = "ALTER TABLE {$_TABLES['topics']} CHANGE sortnum sortnum smallint(3) default NULL";
    3.13 +
    3.14  /**
    3.15   * Add new config options
    3.16   *