[geeklog-devel] 1.4.1 to 1.5.0 upgrade bug?

Chris 'Chipper' Chiapusio chipper at llamas.net
Sat Jul 26 12:23:19 EDT 2008


I'm not sure how anyone did a clean upgrade to 1.5.0 since
linksubmission.date has never existed and was not included in the upgrade sql
scripts.

patch attached.

Chip
-- 
------
				**** Warning ****
This e-mail message, without warrant or warning, and despite US law as set
forth in the Foreign Intelligence Surveillance Act of 1978, may be subject
to monitoring by the United States National Security Agency and/or the
Department of Defense. Information contained in this message may be used
against any senders or recipients, now or in the future, in a public trial
or secret tribunal.
                       Please encrypt anything important.
    PGP Key: http://wwwkeys.pgp.net:11371/pks/lookup?op=get&search=0x6CFA486D
-------------- next part --------------
--- mysql_1.4.1_to_1.5.0.php.broke      2008-07-26 12:16:36.000000000 -0400
+++ mysql_1.4.1_to_1.5.0.php    2008-07-26 12:13:14.000000000 -0400
@@ -620,6 +620,7 @@
     $blockadmin_id = DB_getItem($_TABLES['groups'], 'grp_id',
                                 "grp_name='Block Admin'");

+    $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} ADD date datetime NULL AFTER hits";
     $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} ADD owner_id mediumint(8) unsigned NOT NULL default '1' AFTER date";
     $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE category cid varchar(32) NOT NULL";
     $P_SQL[] = "ALTER TABLE {$_TABLES['links']} CHANGE category cid varchar(32) NOT NULL";


More information about the geeklog-devel mailing list