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!

Index: install/install_schema.sql
===================================================================
--- install/install_schema.sql	(revision 14094)
+++ install/install_schema.sql	(working copy)
@@ -82,13 +82,6 @@
   KEY MailingId (MailingId)
 );
 
-CREATE TABLE EmailSubscribers (
-  EmailMessageId int(11) NOT NULL default '0',
-  PortalUserId int(11) NOT NULL default '0',
-  KEY EmailMessageId (EmailMessageId),
-  KEY PortalUserId (PortalUserId)
-);
-
 CREATE TABLE Events (
   EventId int(11) NOT NULL AUTO_INCREMENT,
   `Event` varchar(40) NOT NULL DEFAULT '',
Index: install/remove_schema.sql
===================================================================
--- install/remove_schema.sql	(revision 14094)
+++ install/remove_schema.sql	(working copy)
@@ -3,7 +3,6 @@
 DROP TABLE CustomField;
 DROP TABLE ConfigurationValues;
 DROP TABLE EmailQueue;
-DROP TABLE EmailSubscribers;
 DROP TABLE Events;
 DROP TABLE IdGenerator;
 DROP TABLE Language;
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 EmailSubscribers;
\ No newline at end of file

Index: install/install_schema.sql
===================================================================
--- install/install_schema.sql	(revision 14094)
+++ install/install_schema.sql	(working copy)
@@ -82,13 +82,6 @@
   KEY MailingId (MailingId)
 );
 
-CREATE TABLE EmailSubscribers (
-  EmailMessageId int(11) NOT NULL default '0',
-  PortalUserId int(11) NOT NULL default '0',
-  KEY EmailMessageId (EmailMessageId),
-  KEY PortalUserId (PortalUserId)
-);
-
 CREATE TABLE Events (
   EventId int(11) NOT NULL AUTO_INCREMENT,
   `Event` varchar(40) NOT NULL DEFAULT '',
Index: install/remove_schema.sql
===================================================================
--- install/remove_schema.sql	(revision 14094)
+++ install/remove_schema.sql	(working copy)
@@ -3,7 +3,6 @@
 DROP TABLE CustomField;
 DROP TABLE ConfigurationValues;
 DROP TABLE EmailQueue;
-DROP TABLE EmailSubscribers;
 DROP TABLE Events;
 DROP TABLE IdGenerator;
 DROP TABLE Language;
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 EmailSubscribers;
\ No newline at end of file

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0003104) Dmitry (manager) 2010-12-03 16:26	Please test.

(0003111) 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.

(0003120) Dmitry (manager) 2010-12-06 13:26	New patch uploaded for testing.

(0003139) alex (manager) 2011-01-05 04:29	ok

(0003140) alex (manager) 2011-01-05 04:31	Fix committed to 5.1.x branch. Commit Message: Fixes 0000872: Remove deprecated "EmailSubscribers" table Commit on behalf of Dmitry

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

Related Changesets
In-Portal CMS: 5.1.x r14108 Timestamp: 2011-01-05 04:31:20 Author: alex [ Details ] [ Diff ]	Fixes 0000872: Remove deprecated "EmailSubscribers" table 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: 0003367
2011-03-30 09:53	Dmitry	Status	resolved => closed
2011-01-05 04:31	alex	Note Added: 0003140
2011-01-05 04:31	alex	Status	reviewed and tested => resolved
2011-01-05 04:31	alex	Fixed in Version	=> 5.1.2-B1
2011-01-05 04:31	alex	Resolution	open => fixed
2011-01-05 04:31	alex	Assigned To	!COMMUNITY => alex
2011-01-05 04:31	alex	Changeset attached	5.1.x r14108
2011-01-05 04:29	alex	Note Added: 0003139
2011-01-05 04:29	alex	Status	needs testing => reviewed and tested
2010-12-06 13:26	Dmitry	Note Added: 0003120
2010-12-06 13:26	Dmitry	Status	needs work => needs testing
2010-12-06 13:26	Dmitry	File Added: Remove-deprecated-EmailSubscribers-table-v2.patch
2010-12-06 11:41	alex	Note Added: 0003111
2010-12-06 11:41	alex	Status	needs testing => needs work
2010-12-03 16:26	Dmitry	Note Added: 0003104
2010-12-03 16:26	Dmitry	Assigned To	Dmitry => !COMMUNITY
2010-12-03 16:26	Dmitry	Status	needs work => needs testing
2010-12-03 16:26	Dmitry	File Added: Remove-deprecated-EmailSubscribers-table.patch
2010-09-28 14:00	Dmitry	Assigned To	=> Dmitry
2010-09-28 14:00	Dmitry	Status	active => needs work
2010-09-28 14:00	Dmitry	Fixed in Version	5.1.2 =>
2010-09-28 14:00	Dmitry	Target Version	Icebox => 5.1.2
2010-09-28 12:15	Dmitry	Developer	=> Dmitry
2010-09-28 12:14	Dmitry	Fixed in Version	=> 5.1.2
2010-09-23 15:17	Dmitry	New Issue
2010-09-23 15:17	Dmitry	Reference	=> http://groups.google.com/group/in-portal-bugs/browse_thread/thread/8d206bd5dff43002
2010-09-23 15:17	Dmitry	Change Log Message	=> Removed deprecated database table