In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]

[ View Advanced ] [ Issue History ] [ Print ]

Tags

No tags attached.

Reference

Change Log Message

Estimate Points

Attached Files

Table-IgnoreKeywords-is-unused.patch [^] (1,449 bytes) 2010-12-03 16:23 [Show Content]

Index: install/install_schema.sql
===================================================================
--- install/install_schema.sql	(revision 14094)
+++ install/install_schema.sql	(working copy)
@@ -900,11 +900,6 @@
   KEY SearchType (SearchType)
 );
 
-CREATE TABLE IgnoreKeywords (
-  keyword varchar(20) NOT NULL default '',
-  PRIMARY KEY  (keyword)
-);
-
 CREATE TABLE SpamControl (
   ItemResourceId int(11) NOT NULL default '0',
   IPaddress varchar(20) NOT NULL default '',
Index: install/remove_schema.sql
===================================================================
--- install/remove_schema.sql	(revision 14094)
+++ install/remove_schema.sql	(working copy)
@@ -49,7 +49,6 @@
 DROP TABLE Relationship;
 DROP TABLE SearchConfig;
 DROP TABLE SearchLog;
-DROP TABLE IgnoreKeywords;
 DROP TABLE SpamControl;
 DROP TABLE StatItem;
 DROP TABLE SysCache;
Index: install/upgrades.sql
===================================================================
--- install/upgrades.sql	(revision 14094)
+++ install/upgrades.sql	(working copy)
@@ -1993,4 +1993,7 @@
 	SET l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron to run Agents'
 	WHERE PhraseKey = 'LA_USECRONFORREGULAREVENT' AND l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron for Running Regular Events';
 
-# ===== v 5.1.1 =====
\ No newline at end of file
+# ===== v 5.1.1 =====
+
+# ===== v 5.1.2-B1 =====
+DROP TABLE IF EXISTS IgnoreKeywords;
\ No newline at end of file

Table-IgnoreKeywords-is-unused-v2.patch [^] (1,439 bytes) 2010-12-06 13:24 [Show Content]

Index: install/install_schema.sql
===================================================================
--- install/install_schema.sql	(revision 14094)
+++ install/install_schema.sql	(working copy)
@@ -900,11 +900,6 @@
   KEY SearchType (SearchType)
 );
 
-CREATE TABLE IgnoreKeywords (
-  keyword varchar(20) NOT NULL default '',
-  PRIMARY KEY  (keyword)
-);
-
 CREATE TABLE SpamControl (
   ItemResourceId int(11) NOT NULL default '0',
   IPaddress varchar(20) NOT NULL default '',
Index: install/remove_schema.sql
===================================================================
--- install/remove_schema.sql	(revision 14094)
+++ install/remove_schema.sql	(working copy)
@@ -49,7 +49,6 @@
 DROP TABLE Relationship;
 DROP TABLE SearchConfig;
 DROP TABLE SearchLog;
-DROP TABLE IgnoreKeywords;
 DROP TABLE SpamControl;
 DROP TABLE StatItem;
 DROP TABLE SysCache;
Index: install/upgrades.sql
===================================================================
--- install/upgrades.sql	(revision 14094)
+++ install/upgrades.sql	(working copy)
@@ -1993,4 +1993,7 @@
 	SET l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron to run Agents'
 	WHERE PhraseKey = 'LA_USECRONFORREGULAREVENT' AND l<%PRIMARY_LANGUAGE%>_Translation = 'Use Cron for Running Regular Events';
 
-# ===== v 5.1.1 =====
\ No newline at end of file
+# ===== v 5.1.1 =====
+
+# ===== v 5.1.2-B1 =====
+DROP TABLE IgnoreKeywords;
\ No newline at end of file

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0003103) Dmitry (manager) 2010-12-03 16:23	Please review and test.

(0003112) alex (manager) 2010-12-06 11:41	During upgrade process "DROP TABLE" is replaced to "DROP TABLE IF EXISTS" and sql will be "DROP TABLE DROP TABLE IF EXISTS" and this will raise sql error.

(0003119) Dmitry (manager) 2010-12-06 13:24	New patch uploaded for testing!

(0003141) alex (manager) 2011-01-05 04:33	Fix committed to 5.1.x branch. Commit Message: Fixes 0000345: Table "IgnoreKeywords" is unused Commit on behalf of Dmitry

(0003366) Dmitry (manager) 2011-03-30 09:53	Closing, since 5.1.2 release has been released.

Related Changesets
In-Portal CMS: 5.1.x r14109 Timestamp: 2011-01-05 04:33:05 Author: alex [ Details ] [ Diff ]	Fixes 0000345: Table "IgnoreKeywords" is unused Commit on behalf of Dmitry
	mod - /in-portal/branches/5.1.x/core/install/install_schema.sql	[ Diff ] [ File ]
	mod - /in-portal/branches/5.1.x/core/install/remove_schema.sql	[ Diff ] [ File ]
	mod - /in-portal/branches/5.1.x/core/install/upgrades.sql	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2011-03-30 09:53	Dmitry	Note Added: 0003366
2011-03-30 09:53	Dmitry	Status	resolved => closed
2011-01-05 04:33	alex	Changeset attached	5.1.x r14109
2011-01-05 04:33	alex	Note Added: 0003141
2011-01-05 04:33	alex	Status	needs testing => resolved
2011-01-05 04:33	alex	Fixed in Version	=> 5.1.2-B1
2011-01-05 04:33	alex	Resolution	open => fixed
2011-01-05 04:33	alex	Assigned To	!COMMUNITY => alex
2010-12-06 13:24	Dmitry	Note Added: 0003119
2010-12-06 13:24	Dmitry	Status	needs work => needs testing
2010-12-06 13:24	Dmitry	File Added: Table-IgnoreKeywords-is-unused-v2.patch
2010-12-06 11:41	alex	Note Added: 0003112
2010-12-06 11:41	alex	Status	needs testing => needs work
2010-12-03 16:23	Dmitry	Note Added: 0003103
2010-12-03 16:23	Dmitry	Assigned To	Dmitry => !COMMUNITY
2010-12-03 16:23	Dmitry	Status	needs work => needs testing
2010-12-03 16:23	Dmitry	File Added: Table-IgnoreKeywords-is-unused.patch
2010-09-28 14:03	Dmitry	Assigned To	=> Dmitry
2010-09-28 14:03	Dmitry	Status	active => needs work
2010-09-28 13:58	Dmitry	Target Version	Icebox => 5.1.2
2010-09-28 13:58	Dmitry	Fixed in Version	5.1.2 =>
2010-09-28 13:41	Dmitry	Developer	=> Dmitry
2010-09-28 13:41	Dmitry	Fixed in Version	=> 5.1.2
2009-10-03 12:22	alex	Target Version	=> Icebox
2009-10-03 12:22	alex	New Issue

Web Development by Intechnic

In-Portal Open Source CMS