[fixed] Upgrade missed events and subscribers tables Reply to topic

When I upgraded from 9.2.3 to 9.3.0 I had to create cms_treas_subscribers and cms_treas_events tables. Until I had I kept getting errors.

I went back to 9.2.3 and didn't find an installation for those tables so if they were supposed to be there I don't know what happened. Anyway I just though y'all might like to know.

Here's the structure I used to create the tables, I manually wrote them in:

CREATE TABLE `cms_treas_events` ( `id` smallint(8) NOT NULL default '0', `user_id` int(10) NOT NULL default '0', `group_id` int(10) NOT NULL default '0', `group_end` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM

CREATE TABLE `cms_treas_events` ( `eid` smallint(8) NOT NULL default '0', `date_start` int(10) NOT NULL default '1207742400', `date_end` int(10) NOT NULL default '0', `title` varchar(25) NOT NULL default '', `description` text NOT NULL default '', `target` varchar(10) NOT NULL default '0', `actual` varchar(10) NOT NULL default '0', PRIMARY KEY (`eid`) ) ENGINE=MyISAM

I've only just noticed this topic - it should have been reported in Bugger where I get notification.

Initially I was thinking it was the bug I have just fixed, and updated the download, but yours is an upgrade, so that isn't the case at all.

It appears that my fix for the new install bug has affected the upgrade process. You actually have those 2 tables missing because there was an install error and the installer removed those tables when it rolled back.