Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Treasury and Supporters » [fixed] Upgrade missed events and subscribers tables
[fixed] Upgrade missed events and subscribers tables
For managing donations, site expenses and supporters - further enhancements only in the Donations Pro version.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Treasury and Supporters

View previous topic :: View next topic  
Author Message
Maven
New Poster
New Poster

Offline Offline
Joined: Apr 09, 2008
Posts: 1

PostPosted: Wed Apr 09, 2008 1:58 pm
Post subject: [fixed] Upgrade missed events and subscribers tables

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:

Code::
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

Code::
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


Maven's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/Apache/5.0.45/4.3.11/9.2.1
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Thu Apr 10, 2008 8:33 am
Post subject: Re: Upgrading

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.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Treasury and Supporters
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum